[Octave-bug-tracker] [bug #64349] [IO] Writing into existing xlsx file failes because "dcterms:created" missing

[Georg Wiora]

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

                 Summary: [IO] Writing into existing xlsx file failes because
"dcterms:created" missing
                   Group: GNU Octave
               Submitter: gwiora
               Submitted: Mon 26 Jun 2023 01:04:33 PM CEST
                Category: Octave Forge Package
                Severity: 3 - Normal
                Priority: 5 - Normal
              Item Group: Regression
                  Status: None
             Assigned to: None
         Originator Name: georgw
        Originator Email: 
             Open/Closed: Open
                 Release: 8.2.0 8.X Series Bug Fix Release 
         Discussion Lock: Any
        Operating System: Microsoft Windows
           Fixed Release: None
         Planned Release: None


    _______________________________________________________

Follow-up Comments:


-------------------------------------------------------
Date: Mon 26 Jun 2023 01:04:33 PM CEST By: Georg Wiora <gwiora>
I try to write data into an xlsx file created by MS excel with the following
command with IO package v2.6.4:


xlswrite(filename,'tablename','sheetname','E2:AC10','OCT');



error: cxml(0): subscripts must be either integers 1 to (2^63)-1 or logicals
error: called from
    __OCT_oct2xlsx__ at line 305 column 8
    __OCT_oct2spsh__ at line 72 column 22
    oct2xls at line 236 column 22
    xlswrite at line 237 column 22
stopped in __OCT_oct2xlsx__ at line 305 [C:\Program Files\GNU
Octave\Octave-8.2.0\mingw64\share\octave\packages\io-2.6.4\private\__OCT_oct2xlsx__.m]
305:   cxml = [cxml(1:ia-1) strrep(cxml(ia:ib), modf, modtime)
cxml(ib+1:end)];


Looking into the code of __OCT_oct2xlsx__ shows that it is looking for a
missing xml element in the line 304:

 [modf, ia, ib] = getxmlnode (cxml, "dcterms:created", [], 1);



The contents of cxml looks like this:

cxml = <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<cp:coreProperties
xmlns:cp="http://schemas.openxmlformats.org/package/2006/metadata/core-properties";

     xmlns:dc="http://purl.org/dc/elements/1.1/"; 
     xmlns:dcterms="http://purl.org/dc/terms/";
     xmlns:dcmitype="http://purl.org/dc/dcmitype/";
     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
     <dc:title></dc:title>
     <dc:subject></dc:subject>
     <dc:creator></dc:creator>
     <cp:keywords></cp:keywords>
     <dc:description></dc:description>
     <cp:lastModifiedBy>Georg</cp:lastModifiedBy>
     <dcterms:modified
xsi:type="dcterms:W3CDTF">2023-06-26T10:47:26Z</dcterms:modified>
     <cp:category></cp:category>
     <cp:contentStatus></cp:contentStatus>
     <cp:version></cp:version>
 </cp:coreProperties>


Obviously there is no Element named "dcterms:created" thus the function fails.







    _______________________________________________________

Reply to this item at:

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

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