t6590 fails for ods
Submitted by an unknown user
Link to original bug (#790637)
Description
This is a new test that uses all documentation samples for testing roundtrip.
./t6590-samples.pl --verbose --subtests ods
../src/gnumeric --samples-file=samples.csv
No samples for getpivotdata [...]
../src/ssconvert samples.csv samples.gnumeric
[stuff related to styles] @@ -518,7 +688,7 @@ <gnm:Cell Row="250" Col="2">=and(0,1)</gnm:Cell> <gnm:Cell Row="251" Col="2">=and(FALSE,na())</gnm:Cell> <gnm:Cell Row="252" Col="1" ValueType="20">FALSE</gnm:Cell>
-
<gnm:Cell Row="252" Col="2">=false()</gnm:Cell>
-
<gnm:Cell Row="252" Col="2">=FALSE</gnm:Cell> <gnm:Cell Row="253" Col="1" ValueType="60">if</gnm:Cell> <gnm:Cell Row="253" Col="2">=if(1+2=3,"x","y")</gnm:Cell> <gnm:Cell Row="254" Col="1" ValueType="60">iferror</gnm:Cell>
@@ -539,7 +709,7 @@ <gnm:Cell Row="264" Col="1" ValueType="60">switch</gnm:Cell> <gnm:Cell Row="264" Col="2">=switch(weekday(today()),0,"Sunday",1,"Saturday","not weekend")</gnm:Cell> <gnm:Cell Row="265" Col="1" ValueType="20">TRUE</gnm:Cell>
-
<gnm:Cell Row="265" Col="2">=true()</gnm:Cell>
-
<gnm:Cell Row="265" Col="2">=TRUE</gnm:Cell> <gnm:Cell Row="266" Col="1" ValueType="60">xor</gnm:Cell> <gnm:Cell Row="266" Col="2">=xor(TRUE,FALSE)</gnm:Cell> <gnm:Cell Row="267" Col="2">=xor(0,1)</gnm:Cell>
@@ -673,7 +843,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,sign(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>
@@ -1040,9 +1210,9 @@ <gnm:Cell Row="558" Col="1" ValueType="60">code</gnm:Cell> <gnm:Cell Row="558" Col="2">=code("A")</gnm:Cell> <gnm:Cell Row="559" Col="1" ValueType="60">concat</gnm:Cell>
-
<gnm:Cell Row="559" Col="2">=concat("aa","bb")</gnm:Cell>
-
<gnm:Cell Row="559" Col="2" ExprID="3">=concat("aa","bb")</gnm:Cell> <gnm:Cell Row="560" Col="1" ValueType="60">concatenate</gnm:Cell>
-
<gnm:Cell Row="560" Col="2">=concatenate("aa","bb")</gnm:Cell>
-
<gnm:Cell Row="560" Col="2" ExprID="3"/> <gnm:Cell Row="561" Col="1" ValueType="60">dollar</gnm:Cell> <gnm:Cell Row="561" Col="2">=dollar(12345)</gnm:Cell> <gnm:Cell Row="562" Col="1" ValueType="60">exact</gnm:Cell>
The style diffs are related to functions that attach a date format to values.
The question is, does anything here need fixing? We can blank out stuff we don't want to see with a few filters.
Version: git master