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 790639 - t6590 fails for xlsx and biff8
t6590 fails for xlsx and biff8
Status: RESOLVED OBSOLETE
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
git master
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2017-11-20 21:53 UTC by Morten Welinder
Modified: 2018-05-22 14:31 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Morten Welinder 2017-11-20 21:53:33 UTC
xlsx has style issues as in bug 790637 and then

@@ -673,7 +853,7 @@
         <gnm:Cell Row="352" Col="1" ValueType="60">fib</gnm:Cell>
         <gnm:Cell Row="352" Col="2">=fib(23)</gnm:Cell>
         <gnm:Cell Row="353" Col="1" ValueType="60">floor</gnm:Cell>
-        <gnm:Cell Row="353" Col="2">=floor(0.5)</gnm:Cell>
+        <gnm:Cell Row="353" Col="2">=rounddown(0.5,0)</gnm:Cell>
         <gnm:Cell Row="354" Col="2">=floor(5,2)</gnm:Cell>
         <gnm:Cell Row="355" Col="2">=floor(-5,-2)</gnm:Cell>
         <gnm:Cell Row="356" Col="2">=floor(-5,2)</gnm:Cell>
@@ -941,7 +1121,7 @@
         <gnm:Cell Row="505" Col="1" ValueType="60">harmean</gnm:Cell>
         <gnm:Cell Row="505" Col="2">=harmean(11.4,17.300000000000001,21.300000000000001,25.899999999999999,40.100000000000001)</gnm:Cell>
         <gnm:Cell Row="506" Col="1" ValueType="60">hypgeomdist</gnm:Cell>
-        <gnm:Cell Row="506" Col="2">=hypgeomdist(1,2,3,10)</gnm:Cell>
+        <gnm:Cell Row="506" Col="2">=hypgeomdist(1,2,3,10,FALSE)</gnm:Cell>
         <gnm:Cell Row="507" Col="1" ValueType="60">kurt</gnm:Cell>
         <gnm:Cell Row="507" Col="2">=kurt(11.4,17.300000000000001,21.300000000000001,25.899999999999999,40.100000000000001)</gnm:Cell>
         <gnm:Cell Row="508" Col="1" ValueType="60">kurtp</gnm:Cell>




biff8 is in more trouble:
# ../src/ssconvert -T Gnumeric_Excel:excel_biff8 samples-filter.gnumeric samples.xls
| 
| ** (/home/welinder/gnome/gnumeric/src/.libs/lt-ssconvert:23590): WARNING **: unknown op class '
| 
| ** (/home/welinder/gnome/gnumeric/src/.libs/lt-ssconvert:23590): WARNING **: unknown op class '
| 
| ** (/home/welinder/gnome/gnumeric/src/.libs/lt-ssconvert:23590): WARNING **: unknown op class '
| W Too many arguments for function 'ERROR', MS Excel can only handle -1 not 1
[...]
@@ -464,11 +465,11 @@
         <gnm:Cell Row="215" Col="2">=cell(&quot;col&quot;,A1)</gnm:Cell>
         <gnm:Cell Row="216" Col="2">=cell(&quot;width&quot;,A1)</gnm:Cell>
         <gnm:Cell Row="217" Col="1" ValueType="60">error</gnm:Cell>
-        <gnm:Cell Row="217" Col="2">=error(&quot;#N/A&quot;)</gnm:Cell>
-        <gnm:Cell Row="218" Col="2">=isna(error(&quot;#N/A&quot;))</gnm:Cell>
+        <gnm:Cell Row="217" Col="2">=error()</gnm:Cell>
+        <gnm:Cell Row="218" Col="2">=isna(error())</gnm:Cell>
         <gnm:Cell Row="219" Col="1" ValueType="60">error.type</gnm:Cell>
         <gnm:Cell Row="219" Col="2">=error.type(na())</gnm:Cell>
-        <gnm:Cell Row="220" Col="2">=error.type(error(&quot;#X&quot;))</gnm:Cell>
+        <gnm:Cell Row="220" Col="2">=error.type(error())</gnm:Cell>
         <gnm:Cell Row="221" Col="1" ValueType="60">getenv</gnm:Cell>
         <gnm:Cell Row="221" Col="2">=getenv(&quot;HOME&quot;)</gnm:Cell>
         <gnm:Cell Row="222" Col="1" ValueType="60">info</gnm:Cell>
@@ -551,7 +552,7 @@
         <gnm:Cell Row="272" Col="2">=address(5,4,4,FALSE)</gnm:Cell>
         <gnm:Cell Row="273" Col="2">=address(5,4,4,FALSE,&quot;Sheet99&quot;)</gnm:Cell>
         <gnm:Cell Row="274" Col="1" ValueType="60">areas</gnm:Cell>
-        <gnm:Cell Row="274" Col="2">=areas(A1,B2,C3)</gnm:Cell>
+        <gnm:Cell Row="274" Col="2">=areas(A1)</gnm:Cell>
         <gnm:Cell Row="275" Col="1" ValueType="60">choose</gnm:Cell>
         <gnm:Cell Row="275" Col="2">=choose(3,&quot;Apple&quot;,&quot;Orange&quot;,&quot;Grape&quot;,&quot;Perry&quot;)</gnm:Cell>
         <gnm:Cell Row="276" Col="1" ValueType="60">column</gnm:Cell>
@@ -673,7 +674,7 @@
         <gnm:Cell Row="352" Col="1" ValueType="60">fib</gnm:Cell>
         <gnm:Cell Row="352" Col="2">=fib(23)</gnm:Cell>
         <gnm:Cell Row="353" Col="1" ValueType="60">floor</gnm:Cell>
-        <gnm:Cell Row="353" Col="2">=floor(0.5)</gnm:Cell>
+        <gnm:Cell Row="353" Col="2">=floor(0.5,)</gnm:Cell>
         <gnm:Cell Row="354" Col="2">=floor(5,2)</gnm:Cell>
         <gnm:Cell Row="355" Col="2">=floor(-5,-2)</gnm:Cell>
         <gnm:Cell Row="356" Col="2">=floor(-5,2)</gnm:Cell>
@@ -745,18 +746,18 @@
         <gnm:Cell Row="396" Col="2">=roman(999,3)</gnm:Cell>
         <gnm:Cell Row="397" Col="2">=roman(999,4)</gnm:Cell>
         <gnm:Cell Row="398" Col="1" ValueType="60">round</gnm:Cell>
-        <gnm:Cell Row="398" Col="2">=round(5.5)</gnm:Cell>
-        <gnm:Cell Row="399" Col="2">=round(-3.2999999999999998)</gnm:Cell>
+        <gnm:Cell Row="398" Col="2">=round(5.5,)</gnm:Cell>
+        <gnm:Cell Row="399" Col="2">=round(-3.2999999999999998,)</gnm:Cell>
         <gnm:Cell Row="400" Col="2">=round(1501.1500000000001,1)</gnm:Cell>
         <gnm:Cell Row="401" Col="2">=round(1501.1500000000001,-2)</gnm:Cell>
         <gnm:Cell Row="402" Col="1" ValueType="60">rounddown</gnm:Cell>
-        <gnm:Cell Row="402" Col="2">=rounddown(5.5)</gnm:Cell>
-        <gnm:Cell Row="403" Col="2">=rounddown(-3.2999999999999998)</gnm:Cell>
+        <gnm:Cell Row="402" Col="2">=rounddown(5.5,)</gnm:Cell>
+        <gnm:Cell Row="403" Col="2">=rounddown(-3.2999999999999998,)</gnm:Cell>
         <gnm:Cell Row="404" Col="2">=rounddown(1501.1500000000001,1)</gnm:Cell>
         <gnm:Cell Row="405" Col="2">=rounddown(1501.1500000000001,-2)</gnm:Cell>
         <gnm:Cell Row="406" Col="1" ValueType="60">roundup</gnm:Cell>
-        <gnm:Cell Row="406" Col="2">=roundup(5.5)</gnm:Cell>
-        <gnm:Cell Row="407" Col="2">=roundup(-3.2999999999999998)</gnm:Cell>
+        <gnm:Cell Row="406" Col="2">=roundup(5.5,)</gnm:Cell>
+        <gnm:Cell Row="407" Col="2">=roundup(-3.2999999999999998,)</gnm:Cell>
         <gnm:Cell Row="408" Col="2">=roundup(1501.1500000000001,1)</gnm:Cell>
         <gnm:Cell Row="409" Col="2">=roundup(1501.1500000000001,-2)</gnm:Cell>
         <gnm:Cell Row="410" Col="1" ValueType="60">sec</gnm:Cell>
Comment 1 GNOME Infrastructure Team 2018-05-22 14:31:47 UTC
-- GitLab Migration Automatic Message --

This bug has been migrated to GNOME's GitLab instance and has been closed from further activity.

You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/gnumeric/issues/329.