bugGNU Octave - Bugs: bug #43354, xlsopen: Adding several worksheets...

 
 

bug #43354: xlsopen: Adding several worksheets to empty file creates corrupted xlsx-file (io-2.2.4)

Submitted by:  Malte Hinrichs <maldje>
Submitted on:  Sat 04 Oct 2014 12:23:40 AM UTC  
 
Category: Octave Forge PackageSeverity: 3 - Normal
Priority: 5 - NormalItem Group: Inaccurate Result
Status: FixedAssigned to: Philip Nienhuis <philipnienhuis>
Originator Name: Malte HinrichsOpen/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)

Fri 10 Oct 2014 03:12:42 PM UTC, comment #6:

I tested it, and it solves the problem when writing to an empty file.

Thanks a lot!

Unfortunately I found more bugs which I will report shortly.

Malte Hinrichs <maldje>
Wed 08 Oct 2014 08:23:59 PM UTC, comment #5:

@Malte:

Please:
- grab _OCT_oct2xlsx_.m from the usual place (see bug #43352)
- replace it in your io package install folder
- try again and report back.

Philip Nienhuis <philipnienhuis>
Project MemberIn charge of this item.
Tue 07 Oct 2014 02:39:59 PM UTC, comment #4:

Thanks, it seems I had already made code along those lines when writing to xlsx. But, of course, with a few idiosyncrasies that now interfered with the fix for this bug here.

I have a bug fix ready & working but need some more time for first tests.

Philip Nienhuis <philipnienhuis>
Project MemberIn charge of this item.
Tue 07 Oct 2014 11:10:10 AM UTC, comment #3:

the specifications for Office Open XML can be found at http://www.ecma-international.org/publications/standards/Ecma-376.htm

For the structural requirements, see the PDF file in the zip file "ECMA-376 4th edition Part 1", section "ยง 12.2 Package structure" on page 65 (PDF page 75).

(this also refers to bug #43331)

Anonymous
Sat 04 Oct 2014 09:47:49 AM UTC, comment #2:

I tested it with and without your patch. The behavior is the same.

Malte Hinrichs <maldje>
Sat 04 Oct 2014 09:29:51 AM UTC, comment #1:

Is this with or without the patches from bug #43331?

On my system it doesn't work properly either so the bug is confirmed.

FYI, I've changed OS to "Any" and Release to "other" as it refers to a platform-independent issue not relating to core Octave.

Please continue to indicate your own OS and Octave version.

Philip Nienhuis <philipnienhuis>
Project MemberIn charge of this item.
Sat 04 Oct 2014 12:23:40 AM UTC, original submission:

The following creates a corrupted file:

A simple workaround consist in first creating the file and than adding more worksheets:

Malte Hinrichs <maldje>

 

(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 maldje (Submitted the item)
  • -unavailable- added by maldje
  •  

    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 9 latest changes.

    Date Changed By Updated Field Previous Value => Replaced By
    Mon 13 Oct 2014 01:25:43 PM UTCphilipnienhuisStatusReady For Test=>Fixed
      Open/ClosedOpen=>Closed
    Wed 08 Oct 2014 08:23:59 PM UTCphilipnienhuisStatusIn Progress=>Ready For Test
    Sat 04 Oct 2014 07:05:12 PM UTCphilipnienhuisStatusNeed Info=>In Progress
    Sat 04 Oct 2014 09:29:51 AM UTCphilipnienhuisStatusNone=>Need Info
      Assigned toNone=>philipnienhuis
      Release3.8.0=>other
      Operating SystemMac OS=>Any
    Sat 04 Oct 2014 12:23:40 AM UTCmaldjeCarbon-Copy-=>Added -unavailable-

    Back to the top


    Powered by Savane 3.1-cleanup1