[Bug 61148] New: Formula evaluation on an SXSSFCell is not working

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 61148] New: Formula evaluation on an SXSSFCell is not working

Bugzilla from bugzilla@apache.org
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: [hidden email]
          Reporter: [hidden email]
  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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61148] Formula evaluation on an SXSSFCell is not working

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61148

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61148] Formula evaluation on an SXSSFCell is not working

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61148

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |60302

--- Comment #1 from Dominik Stadler <[hidden email]> ---
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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61148] Formula evaluation on an SXSSFCell is not working

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61148

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |david.neuer.vendor@crowncas
                   |                            |tle.com

--- Comment #2 from Dominik Stadler <[hidden email]> ---
*** 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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61148] Formula evaluation on an SXSSFCell is not working

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61148

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |FIXED
             Status|NEW                         |RESOLVED

--- Comment #3 from Dominik Stadler <[hidden email]> ---
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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61148] Formula evaluation on an SXSSFCell is not working

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61148

--- Comment #4 from Dominik Stadler <[hidden email]> ---
*** 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: [hidden email]
For additional commands, e-mail: [hidden email]