[Octave-bug-tracker] [bug #53298] [octave forge] (io) OCT interface xlswrite wipes previous text cell contents

[Greg Holmberg]

Follow-up Comment #15, bug #53298 (project octave):

Not sure if this is the same problem, but I have an .ods file created by
Google Sheets (File > Download > OpenDocument format (.ods)).  After download,
I can open the file in LibreOffice 7.0.6.2 on Ubuntu 20.10 (Linux 5.8.0).

If I try to write data to it with oct2xls, and then open in LibreOffice,
LibreOffice says:

Read error.
Format error discovered in the file in sub-document content.xml at
2,356968(row,col).

Here's a simple script to re-create it.  I have also attached the .odf file,
"guitar data.ods".

ss_path="guitar data.ods";
worksheet="Modeling";
xls = xlsopen(ss_path, true);
[cells, xls, status] = xls2oct(xls, worksheet);
[xls, status] = oct2xls(cells, xls, worksheet);
xls = xlsclose(xls);



    _______________________________________________________

Reply to this item at:

  <https://savannah.gnu.org/bugs/?53298>

_______________________________________________
  Message sent via Savannah
  https://savannah.gnu.org/