search

hougaard / BCCL_support

BCCL Support Repository
3 stars 0 forks source link

Handle international date-, time- and number format #3

Closed cahan0506 closed 3 years ago

cahan0506 commented 3 years ago

See https://en.wikipedia.org/wiki/Category:Date_and_time_representation_by_country https://en.wikipedia.org/wiki/Decimal_separator

Or just possible to specify format in Nav/BC-format or something like Excel-format. https://support.microsoft.com/en-us/office/number-format-codes-5026bbd6-04bc-48cd-bf33-80f18b4eae68

If BCCL should work cross-platform (Linux, Mac, Windows) you might consider a configuration of line breaks as well. https://stackoverflow.com/questions/3720612/what-is-the-universal-newline-for-all-operating-systems-lf-and-cr

Unless line breaks already are handled by your cross-platform compiler.

hougaard commented 3 years ago

Line breaks should work fine across all platforms. We'll take a look at adding a CSV international setting.

Thanks for the report.

hougaard commented 3 years ago

LanguageId to cultureinfo name https://docs.microsoft.com/en-us/openspecs/office_standards/ms-oe376/6c085406-a698-4e12-9d4d-c3b0ee3dbc4a

hougaard commented 3 years ago

https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings

hougaard commented 3 years ago

Supported in build 92 https://www.hougaard.com/bccl-data-formatting-for-csv-files/