CSV Data Consistency Issues

Desktop editors
, ,
1

OS version: Windows 10 LTSC (21H2)
App version: Community version 9.3.1.8 (x64 exe)
Downloaded from: ONLYOFFICE website

I am facing an issue where making even a small change to a csv file, then saving it, results the entire csv file changing.

The files and video of the problem are available here: CSV Issues - Proton Drive Link

This issue maybe related to Issue 9095 however there are some differences.

Here’s what happens, if I open the csv file, it opens correctly. If I save it without making any change, everything is fine.

If I make any change to the csv (such as adding a column or editing even a single value), upon saving, all the decimal point values in the csv go down to zero. This doesn’t appear to be a parsing issue, as even when I open the same file in other text editors, the numbers are still zero.

2

Hello, @Pager3341 !

Thank you for the video and the file. The CSV you shared appears to already be the saved result after the issue occurs, so we cannot compare it with the original data state.

Could you please upload the original CSV file before any edits/saving, so we can reproduce the issue and check the behavior on our side?

3

Sorry. I’ve added the origninal file to the folder now.

Thanks.

1 Like
4

Thank you for sharing the original file. We can reproduce the issue on our side.
Could you please clarify where this CSV file was originally created?

6

I think this one was made in R, however, I’ve experienced the same thing when it was created in Excel or via Node.

1 Like
8

Hello,
Thank you for the additional details and the original file. We were able to reproduce the issue on our side, and we have registered it in our internal bug tracker.

At the moment, we do not have an ETA for a fix, but we will post an update here as soon as we have any news.

Best regards!