<c r="D7" s="25"> <f>SUBTOTAL(9,D8:D14)</f> <v>0</v> </c> <xf numFmtId="43" fontId="5" fillId="2" borderId="2" xfId="1" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1"> <alignment vertical="center"/> </xf> <numFmt numFmtId="43" formatCode="_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ "/> java: sval = formatter.formatCellValue(cell, eval); // sval = - 0 ver 3.14 // sval = 0.0 ver 3.13
correct value should be: sval = - (Excel show)
Can you provide a more self-contained code for reproducing this. Or the Excel-file if you are working off of one built in another application. With only the pieces you provided it is quite hard to reproduce the problem.
This is handled in bug #62242 as well and there a PR is already discussed, so duplicating this one. *** This bug has been marked as a duplicate of bug 62242 ***