When I try to copy and paste a textbased spreadsheet (f.e. a copy of a query-result from ms-sql server or from textpad) into calc, first the Textimport shows the entries like in the source but then in the converted sheet in calc, the 2746e becomes a 2746. The 7101d still is a 7101d. Everything else is ok. Example to copy and paste: Hersteller Modell Bestandsnummer Zebra 2746e PR-1000 HP Laserjet 5500 PR-1020 Kyocera FS-3900DN 7101d Oki C9600 PR-1013 2746e is converted into 2746 After trying a little bit I found that all numerical ending with an e (2746e, 55e, 7101e) is changed to 2746, 55 or 7101. Why? Never had that before in calc. Regards, Martin
Can you provide a document that we can copy FROM. Ie. can you provide some form of a query-result from ms-sql server? Without this it's hard for us to reproduce the problem. Let me know what you can provide us. Marking as NEEDINFO until we figure out what you can provide us so that we can easily reproduce the problem. Thanks for your patience and support of LibO :D
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/FDO/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team
Created attachment 80541 [details] Example csv file containing numbers with trailing E. I'm seeing this DATA CORRUPTION bug in 4.0.3.3. Number codes like 10E turn into the data value 10 in the spreadsheet cell. Attached is an example input file. The problem also occurs for - (menu) File / Open (select csv file requiring text import) - (menu) Insert / Sheet from file ... (select csv file requiring text import) (Guess: the number parser erroneously accepts numbers with a trailing 'E'. It should not parse this as a number for two reasons: - "Detect special numbers" is off, so it should not accept scientific notation. - Scientific notation requires an exponent after the E, but there is none.)
Created attachment 80542 [details] Trailing E appears in Text Import Dialog, but ...
Created attachment 80543 [details] Trailing E is dropped in imported spreadsheet cell values
Workaround: in the Text Import dialog, select the columns where this problem occurs, and change the column type to "text" (not "standard").
*** Bug 62370 has been marked as a duplicate of this bug. ***
Changing Platform from Windows-specific to All as I can confirm this bug occurs under Crunchbang 11 running TDF/LO v4.1.0.4. It does not occur under v3.5.7.2 on the same platform.
@Eike: didn't you fix that recently?
Yup. *** This bug has been marked as a duplicate of bug 70319 ***