[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

Mike Kaganski  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=15
   ||0635

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Status|RESOLVED|CLOSED

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Resolution|--- |NOTABUG
 Status|NEW |RESOLVED

--- Comment #31 from Eike Rathke  ---
See also further above
https://opengrok.libreoffice.org/xref/core/sal/rtl/math.cxx?r=be8da979#283 for
how representable integer values are handled. If it reaches line 381 it means
the value is no such.

The error is on user side to import the ID values as numeric instead of text.
Floating point IEEE 754 double precision values are limited in their accuracy,
the largest representable unambiguous whole integer number is (2^53)-1 or
9007199254740991.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

Julien Nabet  changed:

   What|Removed |Added

 CC||er...@redhat.com

--- Comment #30 from Julien Nabet  ---
(In reply to kartis56 from comment #28)
> \core\svl\source\numbers\zformat.cxx(57,40)
> 
> const double EXP_ABS_UPPER_BOUND = 1.0E15;  // use exponential notation
> above that absolute value.
> // Back in time was E16 that lead
> // to display rounding errors,
> see
> // also sal/rtl/math.cxx
> // doubleToString()
> 
> line 1750
> 
> void SvNumberformat::ImpGetOutputStandard(double& fNumber, OUString&
> rOutString)
> {
> sal_uInt16 nStandardPrec = rScan.GetStandardPrec();
> 
> if ( fabs(fNumber) > EXP_ABS_UPPER_BOUND )
> {
> nStandardPrec = ::std::min(nStandardPrec,
> static_cast(14)); // limits to 14 decimals
> 
> but why use this ?

Taking a look at sal/rtl/math.cxx, we got:
381 switch (eFormat)
382 {
383 case rtl_math_StringFormat_Automatic:
384 {   // E or F depending on exponent magnitude
385 int nPrec;
386 if (nExp <= -15 || nExp >= 15)  // was <-16, >16 in ancient
versions, which leads to inaccuracies
387 {
388 nPrec = 14;
389 eFormat = rtl_math_StringFormat_E;
390 }
(see
https://opengrok.libreoffice.org/xref/core/sal/rtl/math.cxx?r=be8da979#380)

Eike: it seems it might be a WONTFIX, any thoughts?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

--- Comment #29 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

--- Comment #28 from kartis56  ---

\core\svl\source\numbers\zformat.cxx(57,40)

const double EXP_ABS_UPPER_BOUND = 1.0E15;  // use exponential notation above
that absolute value.
// Back in time was E16 that lead
// to display rounding errors, see
// also sal/rtl/math.cxx
// doubleToString()

line 1750

void SvNumberformat::ImpGetOutputStandard(double& fNumber, OUString&
rOutString)
{
sal_uInt16 nStandardPrec = rScan.GetStandardPrec();

if ( fabs(fNumber) > EXP_ABS_UPPER_BOUND )
{
nStandardPrec = ::std::min(nStandardPrec, static_cast(14));
// limits to 14 decimals

but why use this ?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

--- Comment #27 from Lionel Elie Mamane  ---
(In reply to kartis56 from comment #26)
> (In reply to Lionel Elie Mamane from comment #25)
>> (In reply to Julien Nabet from comment #23)

>> The formatting is done by a system that is shared with Calc; I don't
>> remember out of the top of my head where it is, but look for
>> "SvNumberFormatsSupplier" in svl

> maybe here?

> core\svl\source\numbers\numfmuno.hxx 
> https://docs.libreoffice.org/svl/html/classSvNumberFormatterServiceObj.html

Yes, that looks right.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

--- Comment #26 from kartis56  ---
(In reply to Lionel Elie Mamane from comment #25)
> (In reply to Julien Nabet from comment #23)
> 
> > Lionel: any codepointer about table gui management?
> 
> My guess is that it is because a formatted field use a double (IEEE 64bit
> double precision floating point number) for the number that is contained in
> it and/or for the formatting.
> 
> See forms/source/component/FormattedField.[ch]xx
> 
> The formatting is done by a system that is shared with Calc; I don't
> remember out of the top of my head where it is, but look for
> "SvNumberFormatsSupplier" in svl

maybe here?

core\svl\source\numbers\numfmuno.hxx 

or this?

https://docs.libreoffice.org/svl/html/classSvNumberFormatterServiceObj.html

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

--- Comment #25 from Lionel Elie Mamane  ---
(In reply to Julien Nabet from comment #23)

> Lionel: any codepointer about table gui management?

My guess is that it is because a formatted field use a double (IEEE 64bit
double precision floating point number) for the number that is contained in it
and/or for the formatting.

See forms/source/component/FormattedField.[ch]xx

The formatting is done by a system that is shared with Calc; I don't remember
out of the top of my head where it is, but look for "SvNumberFormatsSupplier"
in svl

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

--- Comment #24 from rob...@familiegrosskopf.de ---
(In reply to Julien Nabet from comment #23)

> (remark: "csv" table can't be seen on table list unless restarting LO but
> that's another story)

You have to chose View > Refresh tables (or something like this - haven't
looked in English GUI). This is the normal way to show the GUI tables have been
added through direct SQL.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

--- Comment #23 from Julien Nabet  ---
Thank you Robert, I reproduced exactly what you indicated.

Lionel: any codepointer about table gui management?

(remark: "csv" table can't be seen on table list unless restarting LO but
that's another story)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

--- Comment #22 from rob...@familiegrosskopf.de ---
Have tested it a little bit.
1. Opened the database
https://bugs.documentfoundation.org/attachment.cgi?id=125563
2. Executed there in Tools > SQL:
CREATE TEXT TABLE "Csv" ("ID" BIGINT PRIMARY KEY);
(creates a text-table with BIGINT)
SET TABLE "Csv" SOURCE "new.csv;ignore_first=true;encoding=UTF-8";
(creates a connection to the first attached *.csv-file)
SELECT * FROM "Csv";
(shows the correct numbers)
3. Opened the same table in the GUI - couldn't display the right number, shows
12345678912345700 instead of 12345678912345678

Displaying numbers with more than 16 digit seems to be impossible in the GUI.
But this numbers were saved in the database.

4. Now I created a query:
SELECT CAST("ID" AS VARCHAR(18)) FROM "Csv"
Shows the right value.

The bug for Base and Calc has nothing to do with DECIMAL or BIGINT, but with
displaying the right value inside the GUI.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

--- Comment #21 from kartis56  ---
OK I'll give up using LO .

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

--- Comment #20 from kartis56  ---
and next test

1) make new table at BASE
   ID as INTEGER primary key
   id as BIGINT(19) 

2) id format change to #,##0

3) open table and enter new record such as 
   1 and 1234567890123456789

4) id is zero filled1,234,567,890,123,460,000

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

--- Comment #19 from kartis56  ---
and test next

1) open " quote csv by CALC, text separator is ", field separtor is conma
   wizard view is correct. 12345678912345678

2) there is float... 1.23E+16

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

--- Comment #18 from kartis56  ---
I see bug 39124   https://bugs.documentfoundation.org//show_bug.cgi?id=39124
and test this

1) " quote csv for test

2) import BASE by wizard as qwuoted ", type VARCHAR

3) view table and, copy all

4) make new CALC file, and paste

5) DATA is float type and zero filled. such as 12,345,678,912,345,700

maybe something wrong at CALC wizard

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

--- Comment #17 from kartis56  ---
Created attachment 125567
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125567=edit
DB wizard

maybe separator {null}  works as field type DECIMAL?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

--- Comment #16 from kartis56  ---
Ok I make 2 file and check separator

1) " quote csv
2) original null quote csv

1) makes corerct view. data type is VARCHAR and copy makes correct.
2) has same ploblem. DECIMAL data type and incorrect view.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

--- Comment #15 from kartis56  ---
I'm using locale ja-JP, so at CALC import wizard encoding to ASCII, lang en.
wizard view is correct, but imported data is incorrect such as 1.23E+16

maybe not only murtibyte ploblem...

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

--- Comment #14 from Alex Thurgood  ---
Note that when you create a link to a CSV file on setting up the connection,
the user gets asked by the connection setup wizard to specify the value
separator characters and decimal point separator character. There seems to be
no way to avoid this part of the connection setup wizard.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

--- Comment #13 from kartis56  ---
Created attachment 125566
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125566=edit
CALC import wizard

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

Summary|Import LONG INTGER as   |Incorrect import of BIG
   |Decimal(18) from CSV, copy  |INTEGER as Decimal(18) from
   |has zero filled under 3 |CSV
   |digits  |

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

 OS|Windows (All)   |All

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs