The evaluation of all formula cells in a XSSFWorkbook fails due to an AbstractMethodError. It was working fine in previous versions. java.lang.AbstractMethodError: org.apache.poi.xssf.usermodel.XSSFCell.getCellTypeEnum()Lorg/apache/poi/ss/usermodel/CellType; at org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluateAllFormulaCells(BaseFormulaEvaluator.java:267) at org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluateAllFormulaCells(BaseFormulaEvaluator.java:259) at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateAllFormulaCells(HSSFFormulaEvaluator.java:176) at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateAllFormulaCells(XSSFFormulaEvaluator.java:91) The culprit seems to be this statement: "c.getCellTypeEnum()". My workaround is to call "workbook.setForceFormulaRecalculation(true);" instead, which is working fine for Microsoft Office but fails for Libre Office and makes opening the worksheet a little bit slower.
An AbstractMethodError usually indicates a mixup of different jar-versions between poi-ooxml and poi, please check which jars you actually include. If you still think this is a problem in poi itself, please try to provide a unit-test which allows to reproduce it.
You are right, I had two different versions in my pom file: poi 3.15 and poi-ooxml 3.14. Sorry and thank you for pointing me in the right direction.
No problem, closing this then.
https://poi.apache.org/faq.html#faq-N10006