https://bz.apache.org/bugzilla/show_bug.cgi?id=61638
--- Comment #2 from Nick Burch <[email protected]> --- 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: [email protected] For additional commands, e-mail: [email protected]
