Hi Team,
With OnlyOffice running at version 9.0.0.172, I thought I would have another look at the Date formatting for CSV import again.
It is also annual taxation reporting time, so dated transaction analysis is the current theme for the coming couple of months 
And I did notice something quite unusual…
This is a screen shot of some raw CSV in a text editor ( Notepad++ )
It is an extract from a Bank transaction download, the date is DD/MM/YYYY format, which is expected from my region.
If I open this file with OnlyOffice, it ends up looking like the following;
The third and fourth lines should be 11 June 2025, but are parsed as 6 November 2025, which is wrong in this context.
However, if I open a blank spreadsheet, then use the menu option Data / Get Data / From Local TXT/CSV to import the CSV file, it ends up looking the following;
The third and fourth lines are being parsed as 11 June 2025.
It is like, once the spreadsheet is open, it is following the regional settings for data format, but not on a direct open operation.
… quite interesting.