Bug 66634 - UI Calc Column Width with Scientific Notation Numbers Is Poorly Chosen
Summary: UI Calc Column Width with Scientific Notation Numbers Is Poorly Chosen
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.2.2 release
Hardware: All All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-07-06 00:19 UTC by Steve Ramage
Modified: 2013-12-30 15:35 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Column width is set to 63 cm. (29 bytes, text/csv)
2013-07-06 00:19 UTC, Steve Ramage 		Details
Working CSV file (28 bytes, text/csv)
2013-07-06 00:20 UTC, Steve Ramage 		Details
Calc with CSV imported (62.14 KB, image/png)
2013-12-30 15:33 UTC, Luc 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Steve Ramage 2013-07-06 00:19:26 UTC 
Created attachment 82109 [details]
Column width is set to 63 cm.

It seems as though when importing a CSV file, the column width is chosen incorrectly in some times for scientific notation numbers.  It's as though it interprets the number (1.79E308) as 17900000...(308) of them, chooses the column width and then formats them better, in some cases. I have attached two CSV files, one works, the other doesn't. The only difference is the row order is flipped.
Comment 1 Steve Ramage 2013-07-06 00:20:01 UTC 
Created attachment 82110 [details]
Working CSV file

Works fine
Comment 2 ign_christian 2013-07-08 02:57:29 UTC 
I can confirm reproducible on LO 4.0.4.2 (Win7 32bit). 

Column width incorrectly loaded if cell A2 'Scientific' formatted, while the other cells is 'Number' Standard Format.
But in Bug 59820 that happens even all cell A 'Number' Standard formatted. So possibly it's a duplicate to that bug.
Comment 3 Luc 2013-12-30 15:33:27 UTC 
Created attachment 91337 [details]
Calc with CSV imported
Comment 4 Luc 2013-12-30 15:35:47 UTC 
I opened Cthe SV in LibreOffice

Versie: 4.2.0.1 
Build ID: 7bf567613a536ded11709b952950c9e8f7181a4a

(on Debian Linux machine)

The behaviour is correct (I added a screenshot of the resulting Calc document)