Summary: | Problems with POI-created formula cells | ||
---|---|---|---|
Product: | POI | Reporter: | Luca Billi <lucabilli> |
Component: | HSSF | Assignee: | POI Developers List <dev> |
Status: | RESOLVED INVALID | ||
Severity: | normal | ||
Priority: | P3 | ||
Version: | 2.0-pre3 | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | All | ||
Attachments: |
POI-created workbook
Excel-saved workbook |
Description
Luca Billi
2003-02-12 09:28:56 UTC
Created attachment 4823 [details]
POI-created workbook
Created attachment 4824 [details]
Excel-saved workbook
I am sorry it took so long to respond, but for some reason this has slipped under, and I hadnt read the bug report properly. What you describe is NOT a bug. There is no calculation engine in POI. POI just puts the formula in the workbook in a format that excel understands. It does NOT do any calculation. When you open the file in excel, it is excel that calculates the result and stores in the file. POI can only then read the value. Hope this explains how things work. If not, please continue to discuss this on the mailing lists, where we will be glad to help. |