TsWorksheetGrid shows incorrect day for dates between 01-jan-1900 and 28-feb-1900
Original Reporter info from Mantis: MAndreato @mandreato
-
Reporter name:
Original Reporter info from Mantis: MAndreato @mandreato
- Reporter name:
Description:
On TsWorksheetGrid, the day representation is incorrect for dates between 01-jan-1900 and 28-feb-1900.
Steps to reproduce:
Create a new Excel (XLSX) spreadsheet; on A1 type, for example, "8/1/1900" and press enter (Excel will recognize it as a date), then save and close the file.
Create a new Lazarus Application project; on Form1 drop a TsWorksheetGrid and set the filename (and path) of its internal WorkbookSource to the saved Excel.
The A1 cell will show "7/jan" (a day before the correct value).
I've tested it with dates between 01-jan-1900 and 28-feb-1900 and it always show a day before.
Mantis conversion info:
- Mantis ID: 38742
- OS: Windows
- OS Build: 10
- Platform: x86-64