https://bz.apache.org/bugzilla/show_bug.cgi?id=66022
Bug ID: 66022 Summary: FormulaParseException: Parse error near char 0 Product: POI Version: 5.2.2-FINAL Hardware: All OS: Linux Status: NEW Severity: normal Priority: P2 Component: SS Common Assignee: dev@poi.apache.org Reporter: dps...@gmail.com Target Milestone: --- nested exception is org.apache.poi.ss.formula.FormulaParseException: Parse error near char 0 ''' in specified formula ''[4]P1(振返(1):P4(方針書(2)'!#REF!'. Expected number, string, defined name, or data table] with root cause","stack_trace":"org.apache.poi.ss.formula.FormulaParseException: Parse error near char 0 ''' in specified formula ''[4]P1(振返(1):P4(方針書(2)'!#REF!'. Expected number, string, defined name, or data table at org.apache.poi.ss.formula.FormulaParser.expected(FormulaParser.java:272) at org.apache.poi.ss.formula.FormulaParser.parseAsName(FormulaParser.java:932) at org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:899) at org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:496) at org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:325) at org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1553) at org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1511) at org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1498) at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1872) at org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1999) at org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1983) at org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1940) at org.apache.poi.ss.formula.FormulaParser.intersectionExpression(FormulaParser.java:1913) at org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1894) at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:2041) at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:173) at org.apache.poi.xssf.usermodel.helpers.XSSFRowColShifter.updateNamedRanges(XSSFRowColShifter.java:63) at org.apache.poi.xssf.usermodel.helpers.XSSFRowShifter.updateNamedRanges(XSSFRowShifter.java:41) at org.apache.poi.xssf.usermodel.XSSFSheet.shiftRows(XSSFSheet.java:2981) -- 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