ONLYOFFICE
Exporting spreadsheet to CSV change the format of the dates
This issue is unique.
- [X] I have used the search tool and did not find an issue describing my bug.
Operating System
Windows 10 / 8.1 / 7
Version information
8.0.1
Expected Behavior
When saving a spreadsheet into CSV file, expect the dates keep the same actual format.
Actual Behavior
When saving a spreadsheet into CSV file, the dates formatted as dd/mm/yyyy are changed to dd.mm.yyyy what is not valid when import the file in another app.
Reproduction Steps
- Open or create a spreadsheet file with dates formatted as dd/mm/yyyy.
- Save as CSV file.
- Open CSV saved file in any text editor.
- Check the dates.
Additional information
No response
Hello! @jpberdejo I can confirm - this is bug, issue #55431. Thanks for your report!
I have the reverse problem! I am trying to IMPORT a comma delimited csv with correct dates viewed in an ascii editor but in the format yyyy-mm-dd. Upon importing as comma delimited, UTF-8 file, the dates are really strange.
"Account Name","Processed Date","Description","Check Number","Credit or Debit","Amount" "checking",2023-12-29,"desc esth rt srtnsgf1",,"Debit",9.99 "checking",2023-12-26,"desc esth rt srtnsgf2",,"Credit",1.99 "checking",2023-12-21,"desc esth rt srtnsgf3",,"Credit",1.99
When I open it in OnlyOffice I get this:
Account Name Processed Date Description Check Number Credit or Debit Amount checking 26.03.7369 desc esth rt srtnsgf1 Debit 9.99 checking 30.05.7368 desc esth rt srtnsgf2 Credit 1.99 checking 16.01.7367 desc esth rt srtnsgf3 Debit 1.99
Any suggestions on how to correct this problem?
THANKS!!
--Update 30 minutes later... I got a workaround. The bank can send data as .csv, .txt, and .ofx. I downloaded the .txt file and opened it in OnlyOffice and then copied it and pasted it into new spreadsheet and it formatted the date and numbers correctly!!!
The issue is actual in DocumentServer.
No, it is not in the server. I am getting this issue in the MacOS app when opening a CSV file.
Hello! @ZachreyNM, @bigbeka Instead of just opening the CSV/TXT file, try to extract the data from it. To do this, open the spreadsheet editor. Go to the Data tab and use the 'Get data' function.
Hello! @ZachreyNM, @bigbeka Instead of just opening the CSV/TXT file, try to extract the data from it. To do this, open the spreadsheet editor. Go to the Data tab and use the 'Get data' function.
Other spreadsheet editors don't do that when opening a CSV, plus when importing data from CSV with "Get data" function, it imports the Quotations, see screenshot. I would say opening a CSV is fairly common use case as it is opening XLSX files instead of "Get data" every time.