Consider the attached .gnumeric file.
Set it up so that the first sheet ("foo") is current.
:; ./ssconvert demo.gnumeric tmp.csv
:; head -1 tmp.csv
foo!A1,foo!B1,foo!C1,foo!D1,foo!E1,foo!F1,foo!G1,foo!H1,foo!I1,foo!J1
which is as expected. So far so good. Contrast that with:
:; ./ssconvert demo.gnumeric -O sheet=bar tmp.csv
:; head -1 tmp.csv
foo!A1,foo!B1,foo!C1,foo!D1,foo!E1,foo!F1,foo!G1,foo!H1,foo!I1,foo!J1
which is the wrong answer. The -O option is being ignored.
Applying the patch improves things immensely.
:; ../new/ssconvert demo.gnumeric -O sheet=bar tmp.csv
:; head -1 tmp.csv
bar!A1,bar!B1,bar!C1,bar!D1,bar!E1,bar!F1,bar!G1,bar!H1,bar!I1,bar!J1
This patch is not the only way to fix the problem, but it seemed
like the least-intrusive way.
This patch applies to very recently-pulled git sources.