After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 163406 - Wrong xls column width
Wrong xls column width
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
1.4.x
Other Windows
: High minor
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2005-01-09 03:24 UTC by j.gnome
Modified: 2005-01-11 04:08 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
test file (8.00 KB, application/vnd.ms-excel)
2005-01-09 03:26 UTC, j.gnome 		Details

Description j.gnome 2005-01-09 03:24:04 UTC 
Excel import/export seems to have trouble with column widths.

1. New workbook
2. Look at the width of column A, don't change it (48 pts, 64 pixels, click and
hold left mouse button between column headers A and B to see this)
3. Save as test.xls
4. Open test.xls in Gnumeric
5. Column width is now 47,25 pts, 63 pixels
6. Open test.xls in Excel
7. column width is now "7.29, 56 pixels"

The number of pixels changes. It shouldn't.
Comment 1 j.gnome 2005-01-09 03:26:49 UTC 
Created attachment 35699 [details]
test file

This is what you get after step 3.

Row height was 64 pixels when saving, now it's 63 pixels in Gnumeric and 56
pixels in Excel.
Comment 2 Jody Goldberg 2005-01-09 04:23:20 UTC 
In #1 I assume you mean 'width' not 'height'

Hmm, thanks for noticing this.  I had specificly tested Sans at one point.  One
of the later fixes must have broken things.
Comment 3 Jody Goldberg 2005-01-11 04:08:47 UTC 
Looks like it was just an incorrect entry in the font table.
I can now export to xls and re-read in gnumeric or XL and still see 64pixels