https://bugs.documentfoundation.org/show_bug.cgi?id=157109
Bug ID: 157109
Summary: open .csv changes content
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: pelardona...@gmail.com
Description:
Calc dialog offer an import option to "Detect Special Numbers", which cannot be
turned off.
Steps to Reproduce:
1.File > Open a .csv file with numbers and text mixed in groups, select
separation criteria.
2. Uncheck "detect special numbers"
3. Uncheck ALL auto correction features
Actual Results:
letter+text combinations looking like hex code, IE3, 2E5, 2E6 etc, are
converted to decimal, or scientific notation
Expected Results:
2E22 is converted to 2E+22, etc etc etc
Reproducible: Always
User Profile Reset: No
Additional Info:
Calc should have imported the numbers exactly like they where in the original
file.
Moreover, Paste> Paste Special > brings up the same import dialog, with the
same results.
Manually checking a list with like 4000 numbers is 3$%$#!.
--
You are receiving this mail because:
You are the assignee for the bug.
