janxkoci
commented
3 months ago I have a similar problem, but I can reproduce my issue already in version 7.5.1.
test file
Save the following data in a new test.csv file:
rep,A,B,C
boot0,5.752358097e-07,6.241771831e-07,6.999271312e-07
boot1,5.772195833e-07,6.96334089e-07,7.699275178e-07
boot2,5.740492503e-07,6.570095073e-07,7.349709959e-07
boot3,5.350701888e-07,7.284086319e-07,7.706726658e-07
boot4,6.040161158e-07,6.815208175e-07,7.795943224e-07
boot5,4.912695988e-07,6.104015119e-07,6.836477531e-07
boot6,5.790822242e-07,6.43826624e-07,7.618649987e-07
boot7,5.249489454e-07,6.669570975e-07,7.294331419e-07
boot8,6.030653684e-07,7.332421268e-07,7.659650011e-07(This is part of an actual file I was working on when I discovered the issue.)
steps to reproduce
- Open the above file in OnlyOffice Desktop of version 7.5.1 or higher.
- Use UTF-8 encoding and comma as delimiter when prompted by OnlyOffice.
- Select any numeric cell and look at the formula bar (just above the cells) - it incorrectly displays the value as e.g. 0.000001 or even 0 (e.g. cell B7).
- Try selecting all numeric cells and convert to Scientific notation - most show the value of
1.00E-06, which is not correct. - Try converting to number with 12 decimal points - you will get numbers like 0.000001000000.
testing setup
I tried several versions of OnlyOffice, with older versions showing correct behaviour, while newer versions show incorrect behaviour. I noticed the issue first on my main laptop with OnlyOffice from flathub (version 8.0.1), then tried another laptop with OnlyOffice installed as deb package (7.4.0). After that I decided to test it with a few appimages to see when the bug started.
Correct
- OnlyOffice 7.4.0.163 (deb, Linux)
- OnlyOffice 7.4.1.36 (appimage, Linux)
Buggy
- OnlyOffice 8.0.1.31 (flatpak, Linux (from flathub))
- OnlyOffice 7.5.1.23 (appimage, Linux)
notes
It's possible (likely) that version 7.5.0 is already affected, but I haven't tried it (the appimages are rather large and I mostly needed some working version on my main laptop, testing all version was not the main priority).
HectorB-2020
HB9HIL
VladimirProkofiev52
This issue is unique.
Operating System
Linux (RPM package)
Version information
8.0.1.31
Expected Behavior
Import/format the text in the CSV file correctly in OnlyOffice spreadsheet. In earlier versions this worked correctly, but for a number of versions now it hasn't worked correctly.
Actual Behavior
The following text in the CSV file (5 lines) - 11 March 2024: (See 7 March) 12 March 2024: (See 7 March) 13 March 2024: (See 7 March) 7, xx March 2024: Organise login access to Charities Services; Obtain information needed to complete 2022 & 2023 Annual Returns; File 2022 & 2023 Annual Returns at Charities Services; Associated email correspondence 8 March 2024: (See 7 March)
becomes in the CSV import - 1/01/7389 11/04/7389 20/07/7389 7, xx March 2024: Organise login access to Charities Services; Obtain information needed to complete 2022 & 2023 Annual Returns; File 2022 & 2023 Annual Returns at Charities Services; Associated email correspondence 8 March 2024: (See 7 March)
Reproduction Steps
Select CSV file in Thunar file manager (opens by default in ONLYOFFICE Desktop Editors) Select default encoding option: Unicode (UTF-8) Select delimiter: Comma
Additional information
Operating system: Manjaro Linux rolling build, 64-bit Xfce version 4.18 GTK 3.24.41 Kernel 6.6.19-1-MANJARO