http://issues.apache.org/bugzilla/show_bug.cgi?id=44495
Summary: named cell references in formulas get erroneously
capitalized
Product: POI
Version: 3.0
Platform: Other
OS/Version: All
Status: NEW
Severity: major
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
I have a workbook that has formulas that refer to named cells. For example
"=actStart". Very simple. Using a technique I saw on the list, in my code I
iterate through all cells to ensure that Excel re-evaluates the references. I
do this by getting the cell formula and setting the formula value back:
String formula = cell.getCellFormula();
cell.setCellType(HSSFCell.CELL_TYPE_FORMULA);
cell.setCellFormula(formula);
However, this seems to have the effect of modifying my formulas to refer to the
name in all upper case, like "=ACTSTART" for the example above. That's wrong
and breaks, causing a bunch of "#NAME?" to show up on the sheet.
By the way, I can't simply use sheet.setForceFormulaRecalculation(true) because
it doesn't always work for me, but that's a different issue.
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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]
