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
