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: dev@poi.apache.org Reporter: ben.klos...@amana.de 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: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org