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

Submitted by:  Andreas Weber <andy1978>
Submitted on:  Thu 10 Sep 2015 07:16:36 AM UTC  
 
Category: Octave Forge PackageSeverity: 3 - Normal
Priority: 5 - NormalItem Group: Incorrect Result
Status: FixedAssigned to: Philip Nienhuis <philipnienhuis>
Originator Name: Open/Closed: Closed
Release: otherOperating System: Any

Add a New Comment(Rich Markup)
   

You are not logged in

Please log in, so followups can be emailed to you.

 

(Jump to the original submission Jump to the original submission)

Thu 10 Sep 2015 09:12:12 PM UTC, comment #6:

Fixed here:
http://hg.code.sf.net/p/octave/io/rev/d57a595251d3

Philip Nienhuis <philipnienhuis>
Project MemberIn charge of this item.
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>
Project MemberIn charge of this item.
Thu 10 Sep 2015 05:59:29 PM UTC, comment #4:

Sorry I overlooked that :-)

Philip Nienhuis <philipnienhuis>
Project MemberIn charge of this item.
Thu 10 Sep 2015 05:58:37 PM UTC, comment #3:

Confirmed as well.

Philip Nienhuis <philipnienhuis>
Project MemberIn charge of this item.
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>
Project Member
Thu 10 Sep 2015 05:49:36 PM UTC, comment #1:

Which io package version?

Philip Nienhuis <philipnienhuis>
Project MemberIn charge of this item.
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:

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>
Project Member

 

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

Attach File(s):
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

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

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only project members can vote.

     

    Please enter the title of George Orwell's famous dystopian book (it's a date):

     

     

    Follow 8 latest changes.

    Date Changed By Updated Field Previous Value => Replaced By
    Thu 10 Sep 2015 09:12:12 PM UTCphilipnienhuisStatusConfirmed=>Fixed
      Open/ClosedOpen=>Closed
      Operating SystemGNU/Linux=>Any
    Thu 10 Sep 2015 05:58:42 PM UTCphilipnienhuisRelease4.0.0=>other
    Thu 10 Sep 2015 05:58:37 PM UTCphilipnienhuisStatusNeed Info=>Confirmed
      Assigned toNone=>philipnienhuis
    Thu 10 Sep 2015 05:49:36 PM UTCphilipnienhuisStatusNone=>Need Info
    Thu 10 Sep 2015 07:37:06 AM UTCandy1978Summaryio 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.1-cleanup1