Hi, 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
conditional_formatting_issue.xlsx
Description: MS-Excel 2007 spreadsheet
conditional_formatting_issue_ok.xlsx
Description: MS-Excel 2007 spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
