GNOME Bugzilla – Bug 726297
ssconvert always recalculates the formulae, even when not using argument --recalc
Last modified: 2017-03-09 15:36:02 UTC
I am trying to convert using 'ssconvert' (command line) a xlsx file (attached below) into a csv. This xlsx contains formulae 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) But there are numbers in gnumeric when I open the file without recalculating the formulae. I need to get these values. But when I use ssconvert, it seems that it first recalculates 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 (1).xlsx" "STEO_m.csv" '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: do not recalc!
File is on the mailing list. It's too big to attach here.
I just verified that no recalculation is going on when I load that file or during the ssconvert call. What, precisely, is the problem you are observing?
I have fixed an xlsx importer problem that might be the cause of whatever problem you are observing. Cells whose expressions were referencing other workbooks (and thus end up with #REF in them) had their values cleared at the end.
Thanks Morten! How can I test the new version to check if the problem is indeed solved? Does the latest source http://ftp.gnome.org/pub/GNOME/sources/gnumeric/1.12/gnumeric-1.12.9.tar.xz contains the fix?
Next version will contain the fix. That will be 1.12.13. (Current version is .12, not .9.) Assuming fixed. Please reopen if that turns out to be wrong.
Hi, I am also having this issue "VLOOKUP(...)' Invalid expression". My version is 1.12.31. Any help? Regards, Ahmet
Indeed, it is working, csv files are generated but it hangs and does not terminate.
Ahmet: open a new bug and attach the file with complete instructions.