https://issues.apache.org/bugzilla/show_bug.cgi?id=56140
Bug ID: 56140
Summary: ConditionalFormat with formula returns wrong target
Product: POI
Version: 3.9
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: POIFS
Assignee: [email protected]
Reporter: [email protected]
Created attachment 31314
--> https://issues.apache.org/bugzilla/attachment.cgi?id=31314&action=edit
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.
--
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]
