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 2009/02/10 10:20:13 UTC
DO NOT REPLY [Bug 46687] New: XLSX is corrupted after set value to
cell.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46687
Summary: XLSX is corrupted after set value to cell.
Product: POI
Version: 3.5-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: major
Priority: P2
Component: XSSF
AssignedTo: dev@poi.apache.org
ReportedBy: matthew.knl@gmail.com
Created an attachment (id=23244)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23244)
excel for testing
I use following code try to set a cell value, but after it cannot be opened by
MS Word. (It prompted an error message and asked for recover)
--
Workbook wb = new XSSFWorkbook("original.xlsx");
Sheet sheet = wb.getSheet("HouseShippingOrder");
Cell cell = sheet.getRow(1).getCell(10);
cell.setCellFormula(null);
cell.setCellValue("ABC");
wb.write(new FileOutputStream("output.xlsx"));
--
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 46687] XLSX is corrupted after set value to cell.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46687
--- Comment #2 from Matthew <ma...@gmail.com> 2009-02-11 22:11:46 PST ---
Sorry for typo mistake. The bug description should be:
I use following code try to set a cell value, but after it cannot be opened by
MS EXCEL. (It prompted an error message and asked for recover)
--
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 46687] XLSX is corrupted after set value to cell.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46687
--- Comment #1 from Matthew <ma...@gmail.com> 2009-02-10 01:21:32 PST ---
Created an attachment (id=23245)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23245)
excel error log
--
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 46687] XLSX is corrupted after set value to cell.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46687
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #3 from Yegor Kozlov <ye...@dinom.ru> 2009-02-15 12:50:23 PST ---
Fixed in r744750 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=744750 )
There was another issue with formula calculation chain - if it becomes empty,
the chain object must be removed because the SpreadsheetML schema requires it
to be non-empty.
Yegor
--
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