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 553506 - OpenOffice calc ods import loses formatting
OpenOffice calc ods import loses formatting
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export OOo / OASIS
1.9.x
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2008-09-24 02:30 UTC by Mike Hurley
Modified: 2008-09-27 03:19 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
Example ods that loses its formatting upon importing into gnumeric. (7.36 KB, application/octet-stream)
2008-09-24 02:32 UTC, Mike Hurley 		  Details
calculate the style extent (5.10 KB, patch)
2008-09-27 03:12 UTC, Jody Goldberg 		committed Details | Review

Description Mike Hurley 2008-09-24 02:30:07 UTC 
Please describe the problem:
Gnumeric does not correctly import cell and text formatting from Open Office Calc's ods format.

Steps to reproduce:
1. Create a spreadsheet with Open Office Calc 2.4
2. Color some cells (background), bold some others
3. Save as ods
4. Import into gnumeric


Actual results:
Data is ok but formatting (colors and bolding) is lost.

Expected results:
The colors font formatting should be kept on import.

Does this happen every time?
Yes

Other information:
This may be related to Bug 532635.
Comment 1 Mike Hurley 2008-09-24 02:32:10 UTC 
Created attachment 119269 [details]
Example ods that loses its formatting upon importing into gnumeric.
Comment 2 Jody Goldberg 2008-09-27 02:07:32 UTC 
That is a surprise.  We should be able to import standard styles.  I'll take a look.
Comment 3 Jody Goldberg 2008-09-27 03:12:58 UTC 
Created attachment 119463 [details] [review]
calculate the style extent

I'll put this on trunk for 1.9.3, and backport for 1.8
Comment 4 Jody Goldberg 2008-09-27 03:19:51 UTC 
committed.