| Summary: | ConditionalFormat with formula returns wrong target | ||
|---|---|---|---|
| Product: | POI | Reporter: | picard09 |
| Component: | HSSF | Assignee: | POI Developers List <dev> |
| Status: | NEW --- | ||
| Severity: | normal | ||
| Priority: | P2 | ||
| Version: | 3.9-FINAL | ||
| Target Milestone: | --- | ||
| Hardware: | All | ||
| OS: | All | ||
| Attachments: |
Example file from website (with other package)
created xls |
||
Created attachment 31315 [details]
created xls
I tried to debug this, as far as I see we create the correct structures for the PtgRef object according to the MS-XLS spec, however also OpenOffice loads the conditional format incorrectly for this case. I also saw that OpenOffice creates a PtgRefN, which has offsets instead of relative/absolute coordinates, something which POI seems to totally ignore and handle equal to PtgRef for now! However this does not explain the issue we are seeing here, at least as far as I see. |
Created attachment 31314 [details] Example file from website (with other package) 1. Take your example from the website (see file attached). 2. Use -xls as parameter. 3. Change to sheet duplicates 4. go to cell A2 5. look at the conditional formula: it says: =ZÄHLENWENN($A$2:$A$11;A3)>1 What did i expect? Look at the code: it says ConditionalFormattingRule rule1 = sheetCF.createConditionalFormattingRule("COUNTIF($A$2:$A$11,A2)>1"); So, I expected the formula to refer to cell A2 instead of A3! This occurs with various formulas some how randomly (e.g. I tried E3 and got I5, or O3 and I got AC5) Please check and confirm.