[go: up one dir, main page]

Skip to content

Saving SBmeasurement XLS files with LibreOffice causes problems

Saving experimental data files with Libre Office can make them unreadable with the following error:

Error using xlsread (line 247)
XLSREAD unable to read sheet 'default'.
File does not contain recognized Excel data.  Try saving as Excel 98.

Error in SBimportXLSmeasurement (line 60)
    [NUMERIC,TXT,RAW] = xlsread(filename,dsc{sheet});

Error in SBmeasurement (line 114)
    [outputstructures,errorMsg] = SBimportXLSmeasurement(filename);


Error in ExpData (line 110)
              dataAll{i} = SBmeasurement(filenames{i});

Error in loadExpData (line 17)
            expData = ExpData(varargs{:});

Error in TFmain (line 13)
    expData = loadExpData(settings);

Error in abcdExperiment (line 62)
    [ runs, viabilityThreshold, p0, error0 ] = TFmain(p);

Opening and resaving with MS Excel solves the issue. See the two attached files.

Maybe this should be mentioned in the readme?

expData_libre.xls

expData.xls