https://issues.apache.org/bugzilla/show_bug.cgi?id=46700
Yegor Kozlov <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |INVALID --- Comment #1 from Yegor Kozlov <[email protected]> 2009-02-26 00:21:11 PST --- shiftRows fails because of an unknown name UOM. This undefined name is used in formulas in the cells H2 and H3, and also in the data validation rule for J3. The formula in H2 that can't be parsed looks as follows: IF(ISERROR(VLOOKUP("",UOM,2,FALSE)),"",VLOOKUP("",UOM,2,FALSE)) Shifting a formula in XSSF includes the following operations: - parse formula into an array of tokens (Ptgs) - update column and row references of the parsed tokens according to the shifting rule - serialize the updated Ptgs into string - update the formula value in the cell To parse a formula all its parts must be defined. If FormulaParser fails to resolve a token it throws FormulaParseException as in your case. Please note, that FormulaParser has been recently updated to handle names with backslashes. With this change the exception message is different from reported. Current code in trunk throws org.apache.poi.ss.formula.FormulaParser$FormulaParseException: Specified named range 'UOM' does not exist in the current workbook. Yegor -- Configure bugmail: https://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]
