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

https://bugs.documentfoundation.org/show_bug.cgi?id=100254 Mike Kaganski changed: What|Removed |Added See Also||https://bugs.documentfounda

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

https://bugs.documentfoundation.org/show_bug.cgi?id=100254 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this

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

https://bugs.documentfoundation.org/show_bug.cgi?id=100254 Eike Rathke changed: What|Removed |Added Resolution|--- |NOTABUG Status|NEW

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

https://bugs.documentfoundation.org/show_bug.cgi?id=100254 Julien Nabet changed: What|Removed |Added CC||er...@redhat.com --- Comment #30

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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] [Bug 100254] Incorrect import of BIG INTEGER as Decimal(18) from CSV

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

https://bugs.documentfoundation.org/show_bug.cgi?id=100254 Alex Thurgood changed: What|Removed |Added Summary|Import LONG INTGER as |Incorrect

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

https://bugs.documentfoundation.org/show_bug.cgi?id=100254 Alex Thurgood changed: What|Removed |Added OS|Windows (All) |All --