Patch to fix incorrect date format interpretation in Numbers for iOS and Mac OS X
Original Reporter info from Mantis: emal-2003
-
Reporter name: Alexey Emelyanov
Original Reporter info from Mantis: emal-2003
- Reporter name: Alexey Emelyanov
Description:
Date values in cells of spreadsheet files, exported using FPSpreadsheet package, displayed incorrectly in Numbers for iOS and Mac OS X.
Date format string "DD.MM.YYYY" with upper case letters misinterpreted by Numbers and leads to display number of days since start of year in first field instead of number of days since start of month.
Presumably problem caused by implementation of spreadsheet import exactly according to current excel format specification which allows only lower case letters in date format string.
Steps to reproduce:
- Export sample spreadsheet file in Excel 8 format (.xls), Office Open XML (.xlsx) with date values in cells and date format string "DD.MM.YYYY"
- Open spreadsheet file in Numbers for iOS and Mac OS X
Additional information:
BuildFormatStringFromSection function in fpsnumformat.pas receives a set of flags to specify the rules for format string creation.
That set of flags prepared by GetNumberFormatOptions method of TsWorkbook class according to existence of boStrictFormat flag in Options property of workbook.
Mantis conversion info:
- Mantis ID: 36137
- Platform: Apple