https://bz.apache.org/bugzilla/show_bug.cgi?id=61638
--- Comment #1 from PJ Fanning <[email protected]> --- For this data format, POI is using the java.text.DecimalFormat class. This class treats format "60#########" as illegal. Formats like "AB########" work but the Java class does not like the attempt to prefix the number with another number. This format "60#########" does work in Excel. I still think that the Java behaviour is better than the Excel behaviour in the case. I think there are better ways to prepend 60 onto a number, eg using a formula like `=CONCATENATE("60", A1)`. -- 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]
