CODEWITHSUNDEEP
libreoffice-calc
Henry
Henry

Reputation: 200

How import text (csv) data into Libre Office Calc without auto-conversion to numbers

when importing csv data, i have a column where most of the text strings are all numerals, but many also have letters. Calc will invariably strip leading zeros from a string that is all numerals, and will also interpret a string with an 'E' as scientific notation.

There is a 'detect special numbers' checkbox in the import dialog, and an 'auto input' checkbox under the tools menu. Neither of these affect the behavior.

data file:

99762 0099762 9834G7 9834E7

expected is same text.

actual is:

99762 99762 9834G7 98340000000

Libre Office version 6.0.7.3, buildid 1:6.0.7-0ubuntu0.18.04.8

Upvotes: 1

Views: 1863

Answers (1)

Henry
Henry

Reputation: 200

in the import dialog, i can select a column and specify it should be imported as text. that works fine.

:-)

Upvotes: 2

Related Questions