GNOME Bugzilla – Bug 790639
t6590 fails for xlsx and biff8
Last modified: 2018-05-22 14:31:47 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("col",A1)</gnm:Cell> <gnm:Cell Row="216" Col="2">=cell("width",A1)</gnm:Cell> <gnm:Cell Row="217" Col="1" ValueType="60">error</gnm:Cell> - <gnm:Cell Row="217" Col="2">=error("#N/A")</gnm:Cell> - <gnm:Cell Row="218" Col="2">=isna(error("#N/A"))</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("#X"))</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("HOME")</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,"Sheet99")</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,"Apple","Orange","Grape","Perry")</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>
-- 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.