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 2017/06/02 14:20:03 UTC
[Bug 61148] New: Formula evaluation on an SXSSFCell is not working
https://bz.apache.org/bugzilla/show_bug.cgi?id=61148
Bug ID: 61148
Summary: Formula evaluation on an SXSSFCell is not working
Product: POI
Version: 3.16-FINAL
Hardware: PC
Status: NEW
Severity: blocker
Priority: P2
Component: SXSSF
Assignee: dev@poi.apache.org
Reporter: mortenkabel@deltek.com
Target Milestone: ---
When evaluation an SXSSFCell containing a formula, the value of the cell is
always cleared.
In the following code, I would expect the output to be 3.0, but it is 0.0. If I
instead created the Workbook as an XSSFWorkbook, the code works as expected.
final Workbook wb = new SXSSFWorkbook();
final Cell cell = wb.createSheet().createRow(0).createCell(0);
cell.setCellFormula("1+2");
wb.getCreationHelper().createFormulaEvaluator().evaluateInCell(cell);
System.out.println(cell.toString());
wb.close();
--
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
[Bug 61148] Formula evaluation on an SXSSFCell is not working
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=61148
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--
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
[Bug 61148] Formula evaluation on an SXSSFCell is not working
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=61148
--- Comment #4 from Dominik Stadler <do...@gmx.at> ---
*** Bug 61532 has been marked as a duplicate of this bug. ***
--
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
[Bug 61148] Formula evaluation on an SXSSFCell is not working
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=61148
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Blocks| |60302
--- Comment #1 from Dominik Stadler <do...@gmx.at> ---
FYI, I have a fix pending for this that is waiting for another fix to land.
When this is done, we should check if it also solves bug 60302 by fixing the
cached formula content.
Referenced Bugs:
https://bz.apache.org/bugzilla/show_bug.cgi?id=60302
[Bug 60302] Formulas not working correctly on LibreOffice with SXSSF
--
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
[Bug 61148] Formula evaluation on an SXSSFCell is not working
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=61148
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |david.neuer.vendor@crowncas
| |tle.com
--- Comment #2 from Dominik Stadler <do...@gmx.at> ---
*** Bug 61532 has been marked as a duplicate of this bug. ***
--
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
[Bug 61148] Formula evaluation on an SXSSFCell is not working
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=61148
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |FIXED
Status|NEW |RESOLVED
--- Comment #3 from Dominik Stadler <do...@gmx.at> ---
Fixed some related problem with SXSSF via r1808874 and the core issue reported
here via r1808929, unfortunately a slight hack needed to be employed, see the
fix for details.
So this should be fixed now.
--
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