[Octave-bug-tracker] [bug #45915] io 2.2.9: xlswrite 'OCT' interface fails to write to empty worksheet

[Andreas Weber]

URL:
  <http://savannah.gnu.org/bugs/?45915>

                 Summary: io 2.2.9: xlswrite 'OCT' interface fails to write to
empty worksheet
                 Project: GNU Octave
            Submitted by: andy1978
            Submitted on: Do 10 Sep 2015 07:16:36 GMT
                Category: Octave Forge Package
                Severity: 3 - Normal
                Priority: 5 - Normal
              Item Group: Incorrect Result
                  Status: None
             Assigned to: None
         Originator Name: 
        Originator Email: 
             Open/Closed: Open
         Discussion Lock: Any
                 Release: 4.0.0
        Operating System: GNU/Linux

    _______________________________________________________

Details:

Open LibreOffice (tested with 4.3.3.2
Build-ID: 430m0(Build:2)), create new shhet, save it without adding anything.

Try to write with xlswrite:

>> xlswrite ("sheet.xlsx", {"fooxyz"}, 1, "B1", 'OCT')
error: __OCT_oct2xlsx__: subscript indices must be either positive integers
less than 2^31 or logicals
error: called from
    __OCT_oct2xlsx__ at line 389 column 8
    __OCT_oct2spsh__ at line 74 column 18
    oct2xls at line 207 column 18
    xlswrite at line 218 column 20
stopped in /home/andy/octave/io-2.2.9/private/__OCT_oct2xlsx__.m at line 389


this is because __OCT_oct2xlsx__.m tries to read the modification date from
"dcterms:modified" but LibreOffice only adds this when something was added to
the sheet.

I don't know the OOXML specification so this could also be a bug in
LibreOffice Calc but it would easy to check if the xml node exists and insert
(in contrast to overwrite it) in line 389






    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/bugs/?45915>

_______________________________________________
  Nachricht gesendet von/durch Savannah
  http://savannah.gnu.org/