Bug 57154 - FILEOPEN: Importing excel file changes column width
Summary: FILEOPEN: Importing excel file changes column width
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.5.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-11-15 13:30 UTC by Shunesburg69
Modified: 2015-05-18 07:08 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Cell width Changed (116.00 KB, application/vnd.ms-excel)
2015-05-18 07:00 UTC, Yogesh Bharate 		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 Shunesburg69 2012-11-15 13:30:38 UTC 
Problem description: 
The cell sizes in Excel and Calc for the same file
are different.

Steps to reproduce:
1. show the file in Excel
2. show the size of the cell
3. show the file in Calc
4. show the size of the cell

Current behavior:

Expected behavior:

Platform (if different from the browser): 
              
Browser: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:16.0) Gecko/20100101 Firefox/16.0
Comment 1 Joel Madero 2013-05-30 20:40:32 UTC 
I am almost positive this is a duplicate - marking as such

shunesburg- if not, please provide an attachment as an example and we'll look at it once yo set it to UNCONFIRMED.

*** This bug has been marked as a duplicate of bug 56105 ***
Comment 2 Yogesh Bharate 2015-05-18 07:00:17 UTC 
Created attachment 115690 [details]
Cell width Changed
Comment 3 Yogesh Bharate 2015-05-18 07:02:59 UTC 
Problem Description:

For a file in excel (XLS) format, when I open it with Libreoffice 3.5, it changes its column sizes.

If I open the same file with Libreoffice 3.3 o 3.4, the sizes are right.

Steps to reproduce:

1. Open attached file ("P1.xls") with Libreoffice 3.5.5.3 
2. Right-click on column F and select "Column width"
3. You will see "5,26 cm"


When you open it with Libreoffice 3.3 o 3.4, the column width is "4.73 cm".

I'm using es_AR locale. 

I tested it with:
 * libreoffice 3.5.5.3 (wrong)
 * libreoffice 3.3.4 (right)
Comment 4 Yogesh Bharate 2015-05-18 07:07:38 UTC 
If I first click F and then right click - column width I get 4,17 cm.

Build ID :

Version: 5.0.0.0.alpha1+
Build ID: 4073afa350387f9fc9194347ad78c6cbdabbb812
Locale: en-IN (en_IN)