search

ONLYOFFICE / DesktopEditors

An office suite that combines text, spreadsheet and presentation editors allowing to create, view and edit local documents
https://www.onlyoffice.com
Other
2.64k stars 311 forks source link

Year is always 1975 with YYYY/MM/DD format in opening a CSV #1549

Closed KoichiM0 closed 2 months ago

KoichiM0 commented 2 months ago

This issue is unique.

Operating System

macOS 10.12 or higher

Version information

8.0.1

Expected Behavior

In importing a csv file with dates in YYYY/MM/DD format in spreadsheat, the four digit number should be interpreted as year, but ONLYOFFICE converts it to MM.DD.1975, discarding the year information. Sorry but this is the first time I use ONLYOFFICE and I do not know how it worked in previous versions.

Actual Behavior

Example file containing one liner: 2024/03/06, In the spreadsheet after opening it, it appears as: 03.06.1975 or 6/3/1975 in the entering box. "2024" is lost from the data.

Reproduction Steps

Example file containing one liner: 2024/03/06, In the spreadsheet after opening it, it appears as: 03.06.1975 or 6/3/1975 in the entering box. "2024" is lost from the data.

Additional information

No response

PJF-NZ commented 2 months ago

Please see my issue #1544, which is similar to yours - thanks to @HectorB-2020 for drawing attention to this :-)

VladimirProkofiev52 commented 2 months ago

Hello! @KoichiM0

I can confirm - this is bug, issue #55431. Thanks for your report!

Rita-Bubnova commented 2 months ago

Duplicate of https://github.com/ONLYOFFICE/DocumentServer/issues/2629.

VladimirProkofiev52 commented 2 months ago

@KoichiM0, Your issue is a duplicate, all discussions will be directed to another one. If you have any additional questions, please write them in this issue.