poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 61638] Incorrect result from DataFormatter.formatCellValue for format 60#########
Date Sun, 05 Nov 2017 08:43:15 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=61638

--- Comment #2 from Nick Burch <apache@gagravarr.org> ---
The Java DecimalFormat version of "60#########" is "'60'000000000"

Note that we have to escape the initial 60 to force it to always display, then
swap the #s for 0s as the # in Java means "display if exists" while the 60
prefix means we always need to treat it as existing

Putting that translation in may not be that easy, as I believe the following
monster is valid in excel...

[$-809][>=100][Red]60#########;[$-410][<-100][Green]92##,####,###;[Yellow]0,000

(Interestingly, OpenOffice gets it slightly wrong too - it shows the leading 60
but not the "missing" 0s)

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message