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 725458 - odf auto-filter roundtrip problem
odf auto-filter roundtrip problem
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
unspecified
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2014-03-01 18:25 UTC by Morten Welinder
Modified: 2014-03-02 18:07 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
Current version of file (2.78 KB, application/x-gnumeric)
2014-03-01 21:33 UTC, Morten Welinder 		Details
Test script (1.35 KB, application/x-perl)
2014-03-01 21:34 UTC, Morten Welinder 		Details

Description Morten Welinder 2014-03-01 18:25:56 UTC 
New t6510 (yet to be committed).

-    <gnm:Sheet DisplayFormulas="0" HideZero="0" HideGrid="0" HideColHeader="0" HideRowHeader="0" DisplayOutlines="0" OutlineSymbolsBelow="1" OutlineSymbolsRight="1" Visibility="GNM_SHEET_VISIBILITY_VISIBLE" GridColor="0:0:0">
+    <gnm:Sheet DisplayFormulas="0" HideZero="0" HideGrid="0" HideColHeader="0" HideRowHeader="0" DisplayOutlines="1" OutlineSymbolsBelow="1" OutlineSymbolsRight="1" Visibility="GNM_SHEET_VISIBILITY_VISIBLE" GridColor="0:0:0">

Having an auto-filter seems to affect DisplayOutlines.  Eh?
Comment 1 Morten Welinder 2014-03-01 18:52:11 UTC 
Note the following

1. ssconvert auto-filter-tests.gnumeric a.ods
2. Use localc to read a.ods and write a.xlsx

The file a.xlsx has no auto-filter for Sheet3.  I assume that's localc's
problem, but it just might be a.ods not being completely right.
Comment 2 Andreas J. Guelzow 2014-03-01 19:24:05 UTC 
This is difficult to fix without access to auto-filter-tests.gnumeric.
Comment 3 Morten Welinder 2014-03-01 21:33:50 UTC 
Created attachment 270651 [details]
Current version of file

For reference.  Please do not commit.
Comment 4 Morten Welinder 2014-03-01 21:34:40 UTC 
Created attachment 270652 [details]
Test script

For reference.
Comment 5 Andreas J. Guelzow 2014-03-02 05:10:58 UTC 
Saving the file as an extended-conformance ODF 1.2 file yields a file that does not validate:
a.ods/content.xml[618,123]: Error: element "table:filter-condition" was found where no element may occur
Comment 6 Andreas J. Guelzow 2014-03-02 07:53:53 UTC 
The export part is fixed. We are now creating a valid odf file on export of the autofilter test file.
Comment 7 Andreas J. Guelzow 2014-03-02 08:28:16 UTC 
I cannot imagine that the DisplayOutlines change has anything to do with ODF. Our ODF exporter does not read or write anything related to outlines at the moment.
Comment 8 Morten Welinder 2014-03-02 15:41:13 UTC 
display-outlines was bug 725504.  I fix the .gnumeric file shortly.
Comment 9 Andreas J. Guelzow 2014-03-02 18:06:40 UTC 
With the fix to bug 725504 there doesn't seem to be anything left here with respect to ODF. I only see:

 t6510-auto-filter.pl: Check auto-filter xlsx roundtrip.
| Using exporter Gnumeric_XmlIO:sax
| Resizing to 1048576x16384
| Using exporter Gnumeric_XmlIO:sax
--- auto-filter-tests.xml	2014-03-02 11:05:43.009078951 -0700
+++ auto-filter-tests-new.xml	2014-03-02 11:05:43.017078952 -0700
@@ -384,9 +384,7 @@
       </gnm:Cells>
       <gnm:SheetLayout TopLeft="A1"/>
       <gnm:Filters>
-        <gnm:Filter Area="A3:G15">
-          <gnm:Field Index="3" Type="expr" Op0="eq" Value0="60" ValueType0="welinder"/>
-        </gnm:Filter>
+        <gnm:Filter Area="A3:G15"/>
       </gnm:Filters>
       <gnm:Solver ModelType="0" ProblemType="0" MaxTime="60" MaxIter="1000" NonNeg="1" Discr="0" AutoScale="0" ProgramR="0"/>
     </gnm:Sheet>
@@ -564,10 +562,7 @@
       </gnm:Cells>
       <gnm:SheetLayout TopLeft="A1"/>
       <gnm:Filters>
-        <gnm:Filter Area="A3:G15">
-          <gnm:Field Index="3" Type="expr" Op0="eq" Value0="60" ValueType0="users"/>
-          <gnm:Field Index="0" Type="expr" Op0="eq" Value0="60" ValueType0="-rw-r--r--"/>
-        </gnm:Filter>
+        <gnm:Filter Area="A3:G15"/>
       </gnm:Filters>
       <gnm:Solver ModelType="0" ProblemType="0" MaxTime="60" MaxIter="1000" NonNeg="1" Discr="0" AutoScale="0" ProgramR="0"/>
     </gnm:Sheet>
Comment 10 Andreas J. Guelzow 2014-03-02 18:07:50 UTC 
Oh, then it is just bug #725460.

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.