[forge: IO] Column spacing in created ODS spreadsheets

[Nir Krakauer]

With a script like the following:

  chk = chk_spreadsheet_support();

  file_out = 'demo.ods';

  if exist(file_out, "file")

    system(['rm ' file_out]); #deletes spreadsheet if already exists

  endif  

  ods = odsopen(file_out, true);

  n_sheets = 3;

  for sheet = 1:n_sheets

    sheet_name = num2str(sheet);

    [ods, status] = oct2ods ({'Hello'}, ods, sheet_name, 'A1');

    [ods, status] = oct2ods (sheet, ods, sheet_name, 'B1');  

  endfor

    

  ods = odsclose(ods);  

The output file has 3 sheets, as expected. Sheet 1 has typical column widths (0.89 inches), while sheets 2 and above have very wide columns A and B (6 inches). Is there any way to keep the column widths at reasonable values?

Thanks,

Nir