https://issues.apache.org/bugzilla/show_bug.cgi?id=51089
Summary: Conditional formula is constant over cells, although
it shouldn't be
Product: POI
Version: 3.7
Platform: PC
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=26910)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=26910)
Test class, which is used to create ConditionalFormula.xls
The attached Java class creates a file called ConditionalFormula.xls. This file
is basically identical with the attached file ConditionalFormula2.xls, with one
important exception: The cells D3, D4, etc. have a conditional formula. When
inspecting this formula in the first file, which is created by POI, then the
formula is shown constant in Excel. In the second file, the formula is modified
by Excel and the row number matches the cells row number.
However, on the POI API level, there is no meaningful difference between the
files, as can be shown by running the "Test" class. This class is used to
extract the relevant information from the excel files.
--
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: [email protected]
For additional commands, e-mail: [email protected]
