Please support number formats [$-F400] and [$-F800] about xlsx-reader HOT 1 CLOSED

Greetings,

With the newest release (v1.1.0) the reader should no longer throw errors when given a file using format specifications such as this one.

Note that this does not add full support for date/time formatting based on locale, despite this technically being the point of the 0xf400/0xf800 format codes. This form of locale information has gone ignored thus far, as there hasn't been an explicit request for this functionality yet.

This is because, for various reasons, it may be more beneficial for the consuming code to either:

• enforce a consistent date/time format (via ReaderConfiguration::setForceDateFormat(), ::setForceTimeFormat() and/or ::setForceDateTimeFormat())
• use DateTime objects instead (see ReaderConfiguration::setReturnDateTimeObjects())

If, despite of that, you happen to require the current system format to be applied correctly (which may or may not match that of the user that initially wrote the XLSX file), please open another ticket for it, which we would then treat as a feature request.
Otherwise, everything should work fine now.

Thank you for the report, and take care.

from xlsx-reader.