Fwd: do not recalculate in 'ssconvert'



Dear gnumeric enthousiasts,

First of all thank you for this great contribution of ssconvert. It is the first time I find a reliable way to read xlsx files on Unix.

I am currently facing an issue quite annoying:
I am trying to convert the xlsx file that is attached to this mail into a csv, but it seems that the xlsx contains formula that link to a local file that I don't have (the creator of the file must have forgotten to paste as values instead of as formula)
so each time I use ssconvert, it tries to recalculate the formula, which fails hence I can't get the data:

ssconvert --export-type=Gnumeric_stf:stf_assistant  -O "locale=C format=automatic separator=, eol=unix sheet='3atab'" "STEO_m.xlsx" "text.csv"
(/usr/bin/ssconvert:14771): GLib-GObject-WARNING **: g_object_set_valist: object class `SheetObjectImage' has no property named `style'
'7etab'!BM7 : 'VLOOKUP($A7,[1]oracle_allbbb!$2:$89130,Dates!BM$12+1,FALSE)' Invalid _expression_

I have seen that there is also a --recalc argument in your ssconvert function but actually I want to do the opposite!

ssconvert --recalc=FALSE --export-type=Gnumeric_stf:stf_assistant  -O "locale=C format=automatic separator=, eol=unix sheet='3atab'" "STEO_m.xlsx" "text.csv"

Is there any piece of advice you could give me to find a solution here? May I suggest to add an argument to force not to recompute?
Thank you

Xavier

Attachment: STEO_m.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]