Bug 59433 - Account special format not processed when value is 0 (zero)
Summary: Account special format not processed when value is 0 (zero)
Status: RESOLVED DUPLICATE of bug 62242
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.14-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-05-06 07:15 UTC by GuoHui Chen
Modified: 2020-03-07 16:04 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
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 ***