Bug 59433

Summary:	Account special format not processed when value is 0 (zero)
Product:	POI	Reporter:	GuoHui Chen <cgh_chen>
Component:	XSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED DUPLICATE
Severity:	normal
Priority:	P2
Version:	3.14-FINAL
Target Milestone:	---
Hardware:	PC
OS:	All

Description GuoHui Chen 2016-05-06 07:15:59 UTC

<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_ ;_ * &quot;-&quot;??_ ;_ @_ "/>

java:
sval = formatter.formatCellValue(cell, eval);
// sval = - 0  ver 3.14
// sval = 0.0  ver 3.13

Comment 1 GuoHui Chen 2016-05-06 07:23:08 UTC

correct value should be:
 sval = - (Excel show)

Comment 2 Dominik Stadler 2016-05-17 09:07:29 UTC

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.

Comment 3 Dominik Stadler 2020-03-07 16:04:17 UTC

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 ***