Csv data format issue

Desktop editors
1

I have a csv file with 24 hr times in this format:
1,1,5:55,7:17,12:35,16:19,17:54,19:15,6:45,13:15,16:45,17:59,19:30,13:15
1,2,5:56,7:17,12:36,16:19,17:55,19:16,6:45,13:15,16:45,18:00,19:30,13:15 1,3,5:57,7:17,12:36,16:19,17:55,19:17,6:45,13:15,16:45,18:00,19:30,13:15

When I open it in other spreadsheet editors like WPS and LibreOffice, it opens fine, but when i open it in OnlyOffice, it shows up like this:
1 1 5.0:55 7.0:17 12.0:35 16.0:19 17.0:54 19.0:15 6.0:40 13.0:30 16.0:45 18.0:01 19.0:45 13.0:30
1 2 5.0:56 7.0:17 12.0:36 16.0:19 17.0:55 19.0:16 6.0:40 13.0:30 16.0:45 18.0:02 19.0:45 13.0:30
1 3 5.0:57 7.0:17 12.0:36 16.0:19 17.0:55 19.0:17 6.0:40 13.0:30 16.0:45 18.0:02 19.0:45 13.0:30

There is a .0 added to each hh value. Please assist me with this.

2

Hello @munirsid,

Thank you for reporting this issue with the time format display in CSV files.
We were able to successfully reproduce the problem on Document Server 9.2 — the .0 is being incorrectly inserted into the hour values exactly as you described.

Good news: We’ve tested this on our upcoming Document Server version 9.3, and the issue has been resolved. The time values now display correctly without the erroneous .0 formatting.
Please wait for the next version of ONLYOFFICE Desktop Editors to be released and upgrade to it. This will resolve the CSV time format parsing issue.

1 Like