Bug 54562

Summary:	FILEOPEN INSERT CSV: Textimport in Calc makes strange text conversion when field ends with "e", drops trailing E
Product:	LibreOffice	Reporter:	martin.pasi
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	CLOSED DUPLICATE
Severity:	normal	CC:	arturofm, erack, jmadero.dev
Priority:	medium	Keywords:	regression
Version:	3.6.1.2 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Example csv file containing numbers with trailing E. Trailing E appears in Text Import Dialog, but ... Trailing E is dropped in imported spreadsheet cell values

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 ***