https://bz.apache.org/bugzilla/show_bug.cgi?id=66611
Bug ID: 66611
Summary: XSSFFormulaUtils::updateFormula omits column fixation
when only used with column definitions
Product: POI
Version: 5.2.3-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
In my example the excelsheet consists of the following formula:
"=VLOOKUP("1000";$B:$C;2;FALSE)"
The Sheet needs to be renamed, which is why XSSFWorkbook::setSheetName is
called. The formula is changed to "=VLOOKUP("1000";B:C;2;FALSE)" by this
process.
Steps to Reproduce:
1) Use a new (XLSX) Excelsheet and enter the formula
"=VLOOKUP("1000";$B:$C;2;FALSE)"
2) Generate a new Excelsheet and change the name of the Excelsheet with POI.
Actual Results:
An Excelsheet is generated in which the formula is changed to
"=VLOOKUP("1000";B:C;2;FALSE)"
Expected Results:
An Excelsheet is generated in which the column fixation isn't omitted
With POI 4.0.1 our application worked: On closer inspection it can be seen that
POI 4.0.1 returns "=VLOOKUP("1000";$B$1:$C$1048576;2;FALSE)" which excel, when
reopening the file, normalized back to "=VLOOKUP("1000";$B:$C;2;FALSE)". This
behaviour is probably not ideal as well, but omitting the fixation entirely
can't be correct either.
--
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]
