https://bz.apache.org/bugzilla/show_bug.cgi?id=65266
Bug ID: 65266
Summary: Reading conditional formatting not working when format
references another sheet
Product: POI
Version: 5.0.0-FINAL
Hardware: PC
OS: Mac OS X 10.1
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 37824
--> https://bz.apache.org/bugzilla/attachment.cgi?id=37824&action=edit
Testcase and excel files
reading the number of conditional formatting via getNumConditionalFormattings
is only working if the condition references cells in the same sheet.
Attached two simple Excel files and a simple testcase:
If you run it with "conditional_formatting_issue.xlsx", you see this ouput:
Tabelle1 has 0 conditional formattings
MyData has 0 conditional formattings
here you see that conditional formattings were not correctly read, although
there is one (referencing another sheet).
If the conditional formatting references same sheet (
conditional_formatting_issue_ok.xlsx), I get the output:
Tabelle1 has 1 conditional formattings
which shows that in this case it works.
I tested both with POI 4.1.2 and POI 5.0.0
--
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]
