Data types not correctly displayed from csv files - Githubissues

ONLYOFFICE / DesktopEditors

An office suite that combines text, spreadsheet and presentation editors allowing to create, view and edit local documents

https://www.onlyoffice.com

Other

2.76k stars 318 forks source link

Data types not correctly displayed from csv files #1281

Closed nr23730 closed 1 year ago

nr23730 commented 1 year ago

This issue is unique.

[X] I have used the search tool and did not find an issue describing my bug.

Operating System

Linux (DEB package)

Version information

7.3.3.50 (flatpak)

Expected Behavior

Value is shown as 230100000001

Actual Behavior

Value is shown as 2.301E+11

Reproduction Steps

Create a csv file like so
```
barcode
230100000001
```
Open csv in OnlyOffice
The value will be displayed with General as 2.301E+11
Change the datatype to Text

Additional information

No response

rsnegirev commented 1 year ago

Hi @nr23730

We compared the behavior in MS Excel and OnlyOffice and it matches. So this behavior is considered as correct.

Value will be show as 230100000001 after you re-enter a cell from the Formula string in both editors.