GNOME Bugzilla – Bug 681009
problems in export of sheet objects
Last modified: 2012-08-02 19:17:17 UTC
Created attachment 220083 [details] sample file When saving the attached gnumeric file as ODS file, there are aparently two problems: (1) the vertical ordering of the ellipses is switched (2) the alpha component of the fill colour of the ellipses is lost At least this is the way the file looks afterwards when opened in AOO, KSpread and Gnumeric. Note that LO fails to correctly size and place tose ellipses at all, but that has been filed against LO in https://bugs.freedesktop.org/show_bug.cgi?id=53054
The problem with (1) is that we were neither writing nor reading a z-index, so the order of the objects in the file (given by the scanning order of the cells to which the objects are anchored) determined the layering. We now correctly export the z-index. We still so not use it when reading ODF files.
Does ods have an alpha component in its colours? (Don't even try googling for that!)
no, there is no alpha component but there is an opacity attribute that can be used for some things.
I created a blue and 50% transparent ellipse inside a using LOCalc. When loaded in gnumeric the ellipse is white. In the ods file, I see for the style: draw:opacity="50%". The color does not appear at all, seems that light blue is the default.
Problem (1) is fixed.
We are now exporting the opacity of sheet objects' fill colour. The is half of problem #2.
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. Jean, ODF producer unfortunately are allowed to skip many style specifications and use "defaults" instead. These defaults vary between producers. For interoperability, producer are urged not to use defaults but to specify the colours in the file. Apparently LO does not do that.
Created attachment 220117 [details] Sample file created with LO calc Sampel file with a semi-transparent ellipse
We do not properly import above sample.
I don't see much wrong with our import. LibreOffice fails to save a fill-color.
I see we are somehow missing to fall-back to the specified default style....
The ellipse has transparency in LO, not in gnumeric.
The import of the LO generated ellipse (file from comment #8) should now work fine. But there is till a problem with the layering of objects: take the file from teh initial import and save it as an ODF file. Then open it several times. The layering is correct the first time it is opened but wrong the second, third, etc. time.
It crashes for me!
+ Trace 230617
that crash was probably due to an uninitialized variable.
The issue of comment #13 is now bug #681049. So everything else in here seems fixed.