Importing MS Excel into Gnumeric/ssconvert Error: All entries in the set must be references
I have a few hundred messy excel files that i would like to convert from excel to text or ods using the terminal. I am using ubuntu 20.04 and gnumeric 1.12.46. when i run ssconvert untitled2.xslx untitled2.txt, i run into an error "All entries in the set must be references". my expectation was that gnumeric saves the formula if it cannot evaluate it. None of the errors in my excel files are actual formulas but rather capturing typos, and thus need to be ignored. but also, i hoped that gnumeric does not throw away the data as it does in this case. See the attached file to reproduce the error. I only realised the issue when i started noticing data gaps when the data were supposed to be complete.