You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/11/14 18:01:50 UTC
DO NOT REPLY [Bug 46213] New:
org.apache.poi.hssf.record.RecordFormatException: String record was supplied
but formula record flag is not set
https://issues.apache.org/bugzilla/show_bug.cgi?id=46213
Summary: org.apache.poi.hssf.record.RecordFormatException: String
record was supplied but formula record flag is not set
Product: POI
Version: 3.2-FINAL
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P1
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: duc.nguyen@sds.com.vn
CC: duc.nguyen@sds.com.vn
When I read the workbook with the object made by the POI and a patch file in
svn r713852 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=713852 ). I try to new HSSFWorkbook with that file, it throws
RecordFormatException.
the sample workbook is attached.
And this is detail exception:
Exception in thread "main" org.apache.poi.hssf.record.RecordFormatException:
String record was supplied but formula record flag is not set
at
org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate.<init>(FormulaRecordAggregate.java:51)
at
org.apache.poi.hssf.record.aggregates.ValueRecordsAggregate.construct(ValueRecordsAggregate.java:159)
at
org.apache.poi.hssf.record.aggregates.RowRecordsAggregate.<init>(RowRecordsAggregate.java:89)
at org.apache.poi.hssf.model.Sheet.<init>(Sheet.java:199)
at org.apache.poi.hssf.model.Sheet.createSheet(Sheet.java:161)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:282)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:196)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:178)
at com.sds.util.AceParser.main(AceParser.java:55)
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46213]
org.apache.poi.hssf.record.RecordFormatException: String record was supplied
but formula record flag is not set
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46213
--- Comment #4 from Duc Nguyen <du...@sds.com.vn> 2008-11-15 21:25:26 PST ---
Created an attachment (id=22878)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22878)
Input to create the example of this bug
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46213]
org.apache.poi.hssf.record.RecordFormatException: String record was supplied
but formula record flag is not set
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46213
--- Comment #1 from Duc Nguyen <du...@sds.com.vn> 2008-11-14 09:02:42 PST ---
Created an attachment (id=22874)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22874)
Input for this bug
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46213]
org.apache.poi.hssf.record.RecordFormatException: String record was supplied
but formula record flag is not set
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46213
Josh Micich <jo...@gildedtree.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #2 from Josh Micich <jo...@gildedtree.com> 2008-11-15 09:35:17 PST ---
Fixed in svn r717883 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=717883 )
Incidentally, do you have details on how the example file was created?
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46213]
org.apache.poi.hssf.record.RecordFormatException: String record was supplied
but formula record flag is not set
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46213
--- Comment #3 from Duc Nguyen <du...@sds.com.vn> 2008-11-15 21:23:15 PST ---
To create the example, I do steps:
1. Copy value of each cell in row #11 into row #10.
2. Delete row #11.
3. Call method HSSFFormulaEvaluator.evaluateAllFormulaCells.
4. Save.
You can get input in the attached file.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org