[Libreoffice-bugs] [Bug 136973] New: 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

            Bug ID: 136973
           Summary: 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
           Product: LibreOffice
           Version: 7.0.1.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: Bug2020 at JohnMurrell.org.uk

Description:
I was importing a .CSV file into calc. The first field contains a 19 digit
integer reference number. I have previously attempted to import this as a
number but due to the length it is truncated and shown as in exponential
format. Since I wanted to concatenate additional text to it I selected Text as
the import type for the first column.

Having imported the data I inserted a column to the right and this appeared to
be already formatted as text as entering a formula in it appeared as text and
was not executed.

I then repeated the formula which was to concatenate some fixed text with the
'text' in the first column. The formula failed as the text in the first column
was being interpreted as a number even though it had been imported as text. I
then used the TEXT function to convert the value in the first column to a
number and it truncated it - not much use as I need all 19 digits to reference
the database. 

At that point I gave up and used TOPCAT to concatenate the strings

I can send a copy of the .CSV file if required it is from a public (Gaia DR2)
ftp server.

Steps to Reproduce:
1.As above
2.
3.

Actual Results:
Long integer values imported as text appear to be a number though too long to
be represented in Calc

Expected Results:
Data should have been imported as text as this had been selected as the import
type for this column even though it is an integer number


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Data should have been imported as text as this had been selected as the import
type for this column even though it is an integer number.

Source .CSV file can be supplied if required for testing / rectification

Result after concatenation was intended to be as follows ( other imported
columns have been deleted)

GAIA DR2 1002377510699543296
GAIA DR2 1033149641409442432
GAIA DR2 1056014230522694912
GAIA DR2 1189102863162477952
GAIA DR2 1223491257550872192
..............

-- 
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/ceb19585/attachment.htm>