XSSFFormulaEvaluator.evaluateAllFormulaCells(workBook) fails if the workbook contains a formula of the following type: =SUM(David:Anders!AL9) or SUM('David A:Anders p'!AL9) This type of formulas are described as the second tip in the following link: http://office.microsoft.com/en-us/excel-help/5-tips-for-working-with-multiple-worksheets-in-excel-HA001042919.aspx The text is also inserted here: Sum the value of a cell across multiple worksheets Another common Excel task is to sum the value of a cell in multiple worksheets and then display the result in another cell. For example, you may want to sum the number of a particular product that customers have ordered over a period of time, such as by quarterly periods. If worksheets are formatted in the same way for each period, the total sales for the product always appears in the same cell in each worksheet. Finding the sum in this situation is simple. You can use a formula: 1.Start Excel. A new, blank workbook appears. 2.In cell B3 in Sheet1, type 20. 3.In cell B3 in both Sheet2 and Sheet3, type 30. 4.In cell A1 in Sheet1, type the following formula: =SUM(Sheet1:Sheet3!B3) 5.Press ENTER. Notice that cell A1 displays 80, which is the total sum of the cells in the three worksheets.
Is this a duplicate of https://issues.apache.org/bugzilla/show_bug.cgi?id=48703 ?
Yes it looks like it is a dublicate and I have just tested 3.9 beta4 and the bug is also in there. Can I do more to help? The error is fairly easy to replicate
Resolving as a duplicate of bug #48703. See that bug for the details of what's currently needed *** This bug has been marked as a duplicate of bug 48703 ***