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 2015/08/09 22:43:22 UTC
[Bug 58227] New: Excel Data table not evaluated
https://bz.apache.org/bugzilla/show_bug.cgi?id=58227
Bug ID: 58227
Summary: Excel Data table not evaluated
Product: POI
Version: unspecified
Hardware: PC
OS: Mac OS X 10.4
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: dev@poi.apache.org
Reporter: nirzohar@hotmail.com
If you'll go in the Excel application, and click on "Recalculate All", it will
evaluate all formulas and Data Tables at the workbook. But if you'll run
FormulaEvaluator.evaluateAll() (from Java code) it's calculate only formulas
without Data Tables.
I was looking for alternative solution to run and calculate Data Table, cannot
find any.
Thanks
--
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 58227] Excel Data table not evaluated
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58227
--- Comment #4 from nirzohar@hotmail.com ---
The attached excel file contains data table (M4:P52).
If you'll change the input 3 for the data table, and run "Recalculate All",
you'll see the values in the data tables changes. (Only after click on
recalculate all).
The same logic in the attached java file. I change the 3rd input (cell C4), and
recalculate all cells, but data tables values do not effected.
Note, I use private method evaluateAllCells which run over all cells and
calculate the formula. I use this method since FormulaEvaluator.evaluateAll()
throw an exception.
Thanks
--
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 58227] Excel Data table not evaluated
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58227
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
Currently, the Formula Evaluator only iterates over sheets, rows and cells
Any chance you could create a very small test file with a data table in it
along with some regular formulas, and a junit test case that tweaks some values
in the spreadsheet and table, then does a recalculate, and finally asserts the
updated values? That should pass for the sheets, but fail for the data table,
but will be a good start for an eventual fix
--
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 58227] Excel Data table not evaluated
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58227
--- Comment #3 from nirzohar@hotmail.com ---
Created attachment 32987
--> https://bz.apache.org/bugzilla/attachment.cgi?id=32987&action=edit
Java file example
--
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 58227] Excel Data table not evaluated
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58227
--- Comment #2 from nirzohar@hotmail.com ---
Created attachment 32986
--> https://bz.apache.org/bugzilla/attachment.cgi?id=32986&action=edit
Excel file with example
--
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 58227] Excel Data table not evaluated
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58227
Javen O'Neal <on...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS|Mac OS X 10.4 |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 58227] Excel Data table not evaluated
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58227
--- Comment #6 from nirzohar@hotmail.com ---
The java program (line 42) get the value from M4 cell. This value should be
updated after recalculate with data table.
To manually simulate this, open the file with excel, change the value in cell
C4. Look at the value at M4 (just random cell in the data table), this value in
cell M4 will be change only after you'll run "recalculate all".
The java app do the same logic.
Thanks
--
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 58227] Excel Data table not evaluated
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58227
--- Comment #5 from Nick Burch <ap...@gagravarr.org> ---
Thanks for that. However, the test java program doesn't seem to be doing any
checks on the data table part, on the main sheet part. Any chance you could add
that check in too?
--
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 58227] Excel Data table not evaluated
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58227
Javen O'Neal <on...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Depends on| |57840
--
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