https://bz.apache.org/bugzilla/show_bug.cgi?id=62373
Bug ID: 62373 Summary: #VALUE! result from FREQUENCY formula Product: POI Version: unspecified Hardware: PC Status: NEW Severity: normal Priority: P2 Component: HSSF Assignee: dev@poi.apache.org Reporter: skarjo...@gmail.com Target Milestone: --- The following formula is returning #VALUE! when I open the spreadsheet in Excel: setCellFormula("SUMPRODUCT(--(FREQUENCY(MATCH(" + rangeString + "," + rangeString + ",0),ROW(" + rangeString + ")-ROW(" + colString + finalFirstDataRowIndex + ")+1)>0))"); If I go into the cell and back out, it calculates properly. A colleague tried OpenOffice, and it worked fine. I added setForceFormulaRecalculation(true), but it didn't help. Clicking the Recalculate All button in Excel also didn't replace the #VALUE! with the proper calculation. Only going into and back out of the cell worked. I tried calculating the formula in Java before creating the workbook, but FREQUENCY is not supported. -- 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