Issue with Reading Dates in Brazilian Format in CSV Files

Desktop editors
1

Hello,

I hope you are well. I would like to report a problem that I identified in the latest version of ONLYOFFICE Desktop Editors (version 7.5.1.23 - rpm) while using it on Fedora Linux 39 (Workstation Edition).

The issue arises when I try to open CSV files containing dates in the Brazilian format (DD/MM/YYYY) in a spreadsheet. It seems that ONLYOFFICE cannot interpret these dates correctly, leading to errors in reading and displaying the information.

Here are some examples of dates in the Brazilian format that are causing issues:

test.csv

Date example 1;15/11/2023
Date example 2;22/07/2022
Date example 3;03/04/2021

When attempting to open the CSV file containing these dates, I notice that the spreadsheet does not recognize them correctly. I have tried using different encodings, such as Unicode (UTF-8) 65001 and Western European (Windows) 1252, but the problem persists.

I have included an image to illustrate how the dates are displayed in the spreadsheet.

image
image1240×508 40.9 KB

2

Olá @jlsmartins :handshake:
Thank you for the detailed description!

We are checking the situation.
I will let you know when I get something.

4

@jlsmartins

At the moment, there are issues with date formats when opening CSV files. Our team is already aware of this problem.

As a temporary solution, you can use the following steps to retrieve data from a CSV file:

  1. Go to the Data tab → Get data → From local TXT/CSV
    // Go to the Dados tab → Obter dados → De TXT/CSV local

  2. Choose the necessary file and load the data into the table.

5

Hello @Nikolas,

Just wanted to drop a quick note to say thanks for the speedy response and the solution you shared. I tried out the steps you mentioned, and it worked like a charm for getting data from the CSV file with those Brazilian date formats.

Really appreciate your help! It’s awesome to see such quick and useful support from the ONLYOFFICE team.

Thanks again!