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 652492 - incorrect style import from ODF
incorrect style import from ODF
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export OOo / OASIS
git master
Other Linux
: Normal normal
: ---
Assigned To: Andreas J. Guelzow
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2011-06-13 19:17 UTC by Andreas J. Guelzow
Modified: 2011-06-18 16:57 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
sample file (ODF file) (7.85 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-06-13 19:17 UTC, Andreas J. Guelzow 		Details
screen shot (2.47 KB, image/png)
2011-06-13 19:18 UTC, Andreas J. Guelzow 		Details

Description Andreas J. Guelzow 2011-06-13 19:17:39 UTC 
Created attachment 189844 [details]
sample file (ODF file)

If you open the enclosed file you see some strange background rendering: The background of cell A1 is slightly larger than that of A2 and A3. Note that the text "Hello" and the background are attached to A1 spanned across A1:A3.
Comment 1 Andreas J. Guelzow 2011-06-13 19:18:10 UTC 
Created attachment 189845 [details]
screen shot
Comment 2 Jean Bréfort 2011-06-18 13:42:59 UTC 
Looks like a style region import issue: saving to gnumeric format does not change things, but after setting the back color in A1 to black make things behave as wanted. The two gnumeric files are not that different. Seems to me that the relevant difference is:

-        <gnm:StyleRegion startCol="0" startRow="1" endCol="0" endRow="15">
+        <gnm:StyleRegion startCol="0" startRow="1" endCol="2" endRow="15">
           <gnm:Style HAlign="1" VAlign="2" WrapText="0" ShrinkToFit="0" Rotation="0" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
             <gnm:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0" Script="0">Sans</gnm:Font>

ODF import sets endCol to 0 while gnumeric uses 2.
Comment 3 Andreas J. Guelzow 2011-06-18 16:57:24 UTC 
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.