[Libreoffice-bugs] [Bug 136973] Calc: Long (19 digit integer) Numbers imported from .CSV file as Text appear to be a number though it is too long to be represented as a number

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=136973

--- Comment #1 from John Murrell <Bug2020 at JohnMurrell.org.uk> ---
I have tried this again and while the import type for the 19 digit integer was
selected as text when imported the cell format shows it as a 19 digit number
despite the text selection in the import wizard.

If the imported 19 digit integers are formatted as text using cell - format -
text it appears that calc then believes they are text and you can concatenate
them as expected.

It appears the problem is somewhere between the import wizard and calc itself.
The selected text format is being over written as it looks like a number even
though it is too large to be shown.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200923/ca5d94cf/attachment.htm>