bugGNU Octave - Bugs: bug #45915, io 2.2.9: xlswrite 'OCT' interface...

 
 

bug #45915: io 2.2.9: xlswrite 'OCT' interface fails to write to empty LibreOffic worksheet

Submitter:  Andreas Weber <andy1978>
Submitted:  Thu 10 Sep 2015 07:16:36 AM UTC
   
 
Category:  Octave Package Severity:  3 - Normal
Priority:  5 - Normal Item Group:  Incorrect Result
Status:  Fixed Assigned to:  philipnienhuis
Originator Name:  Open/Closed:  * Closed
Release:  * other Operating System:  * Any
Fixed Release:  None Planned Release:  None
* Mandatory Fields

Add a New Comment Rich Markup
   

Jump to the original submission

Thu 10 Sep 2015 09:12:12 PM UTC, comment #6: 
Philip Nienhuis <philipnienhuis>
Group Member
Thu 10 Sep 2015 08:32:52 PM UTC, comment #5: 

Repeating the steps with Excel 2013 instead of LO works fine => LibreOffice may be suspicious here (I take MS-Excel as the reference as it is usually the pickiest as regards .xlsx files).
I'd argue that even if LO creates an empty workbook, LO should at least create relevant fields in the xml.

Anyway I'll add a workaround for this.

Philip Nienhuis <philipnienhuis>
Group Member
Thu 10 Sep 2015 05:59:29 PM UTC, comment #4: 

Sorry I overlooked that :-)

Philip Nienhuis <philipnienhuis>
Group Member
Thu 10 Sep 2015 05:58:37 PM UTC, comment #3: 

Confirmed as well.

Philip Nienhuis <philipnienhuis>
Group Member
Thu 10 Sep 2015 05:56:47 PM UTC, comment #2: 

@Philip: Are you kidding me? The summary is "io 2.2.9: xlswrite 'OCT' interface fails to write to empty LibreOffic worksheet" what else do you need?

Andreas Weber <andy1978>
Group Member
Thu 10 Sep 2015 05:49:36 PM UTC, comment #1: 

Which io package version?

Philip Nienhuis <philipnienhuis>
Group Member
Thu 10 Sep 2015 07:16:36 AM UTC, original submission:  

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


Andreas Weber <andy1978>
Group Member

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by andy1978 (Submitted the item)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only group members can vote.

     

    Follow 8 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2015-09-10 philipnienhuis StatusConfirmed Fixed
        Open/ClosedOpen Closed
        Operating SystemGNU/Linux Any
    2015-09-10 philipnienhuis Release4.0.0 other
    2015-09-10 philipnienhuis StatusNeed Info Confirmed
        Assigned toNone philipnienhuis
    2015-09-10 philipnienhuis StatusNone Need Info
    2015-09-10 andy1978 Summaryio 2.2.9: xlswrite \'OCT\' interface fails to write to empty worksheet io 2.2.9: xlswrite 'OCT' interface fails to write to empty LibreOffic worksheet

    Back to the top

    Powered by Savane 3.13-02a9.
    Corresponding source code