[Octave-bug-tracker] [bug #60825] io oct2xls corrupts content.xml

[Greg Holmberg]

URL:
  <https://savannah.gnu.org/bugs/?60825>

                 Summary: io oct2xls corrupts content.xml
                 Project: GNU Octave
            Submitted by: gholmberg
            Submitted on: Fri 25 Jun 2021 07:15:41 PM PDT
                Category: Octave Forge Package
                Severity: 3 - Normal
                Priority: 5 - Normal
              Item Group: Incorrect Result
                  Status: None
             Assigned to: None
         Originator Name: Greg Holmberg
        Originator Email: 
             Open/Closed: Open
                 Release: 6.2.0
         Discussion Lock: Any
        Operating System: GNU/Linux

    _______________________________________________________

Details:

I have an .ods file created by Google Sheets (File > Download > OpenDocument
format (.ods)).  I unzipped it, and I see that the meta.xml file says:


office:version="1.2">
<office:meta>
<meta:generator>LibreOfficeDev/6.0.5.2$Linux_X86_64 LibreOffice_project/


After download, I can open the file in LibreOffice 7.0.6.2 on Ubuntu 20.10
(Linux 5.8.0).

However, 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,111654(row,col).


The following script reproduces the problem with the attached .ods file.  I'm
using Octave 6.2.0 and io 2.6.3.


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




    _______________________________________________________

File Attachments:


-------------------------------------------------------
Date: Fri 25 Jun 2021 07:15:41 PM PDT  Name: sample.ods  Size: 24KiB   By:
gholmberg

<http://savannah.gnu.org/bugs/download.php?file_id=51599>

    _______________________________________________________

Reply to this item at:

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

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