Bug 54562 - FILEOPEN INSERT CSV: Textimport in Calc makes strange text conversion when field ends with "e", drops trailing E
Summary: FILEOPEN INSERT CSV: Textimport in Calc makes strange text conversion when fi...
Status: CLOSED DUPLICATE of bug 70319
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.1.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
: 62370 (view as bug list)
Depends on:
Blocks:
 
Reported: 2012-09-05 14:42 UTC by martin.pasi
Modified: 2013-11-16 13:31 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Example csv file containing numbers with trailing E. (374 bytes, text/csv)
2013-06-09 00:41 UTC, gekacheka
Details
Trailing E appears in Text Import Dialog, but ... (11.21 KB, image/png)
2013-06-09 00:42 UTC, gekacheka
Details
Trailing E is dropped in imported spreadsheet cell values (16.75 KB, image/png)
2013-06-09 00:44 UTC, gekacheka
Details

Note You need to log in before you can comment on or make changes to this bug.
Description martin.pasi 2012-09-05 14:42:22 UTC
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
Comment 1 Joel Madero 2012-10-19 16:51:14 UTC
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
Comment 2 Joel Madero 2013-05-30 16:17:33 UTC
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
Comment 3 gekacheka 2013-06-09 00:41:10 UTC
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.)
Comment 4 gekacheka 2013-06-09 00:42:52 UTC
Created attachment 80542 [details]
Trailing E appears in Text Import Dialog, but ...
Comment 5 gekacheka 2013-06-09 00:44:39 UTC
Created attachment 80543 [details]
Trailing E is dropped in imported spreadsheet cell values
Comment 6 gekacheka 2013-06-09 01:31:38 UTC
Workaround:  in the Text Import dialog, select the columns where this problem occurs, and change the column type to "text" (not "standard").
Comment 7 Owen Genat (retired) 2013-08-25 09:16:02 UTC
*** Bug 62370 has been marked as a duplicate of this bug. ***
Comment 8 Owen Genat (retired) 2013-08-25 09:19:45 UTC
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.
Comment 9 Markus Mohrhard 2013-11-05 01:06:57 UTC
@Eike: didn't you fix that recently?
Comment 10 Eike Rathke 2013-11-05 18:57:04 UTC
Yup.

*** This bug has been marked as a duplicate of bug 70319 ***