org.apache.poi.ss.formula.FormulaParseException: Name 'Tax' is completely unknown in the current workbook


Solutions on the web

Solution icon of github
via GitHub by mattpalermo
, 8 months ago
Name 'Tax' is completely unknown in the current workbook

Solution icon of stackoverflow
Name 'SUMIFS' is completely unknown in the current workbook

Solution icon of stackoverflow
Name 'myfunc' is completely unknown in the current workbook

Solution icon of stackoverflow
Name 'MY_FUNC' is completely unknown in the current workbook

Stack trace

org.apache.poi.ss.formula.FormulaParseException: Name 'Tax' is completely unknown in the current workbook
	at org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:927)
	at org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:536)
	at org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:504)
	at org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:237)
	at org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1123)
	at org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1083)
	at org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1070)
	at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1430)
	at org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1530)
	at org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1514)
	at org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1471)
	at org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1451)
	at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1572)
	at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:145)
	at org.apache.poi.xssf.usermodel.XSSFCell.convertSharedFormula(XSSFCell.java:420)
	at org.apache.poi.xssf.usermodel.XSSFCell.getCellFormula(XSSFCell.java:392)
	at com.ka.spreadsheet.diff.CellExcel.getValue(SpreadSheetExcel.java:173)
	at com.ka.spreadsheet.diff.CellPos.getCellValue(CellPos.java:39)
	at com.ka.spreadsheet.diff.SpreadSheetDiffer.doDiff(SpreadSheetDiffer.java:61)
	at com.ka.spreadsheet.diff.SpreadSheetDiffer.doDiff(SpreadSheetDiffer.java:25)
	at com.ka.spreadsheet.diff.SpreadSheetDiffer.main(SpreadSheetDiffer.java:17)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Once, 4 months ago
Samebug visitor profile picture
Unknown user
Once, 7 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
6 more bugmates