bugGNU Octave - Bugs: bug #43400, [OF] oct2xls (OCT) fails when...

 
 

bug #43400: [OF] oct2xls (OCT) fails when sheet names are being used

Submitted by:  Malte Hinrichs <maldje>
Submitted on:  Fri 10 Oct 2014 04:42:34 PM 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)

Wed 29 Oct 2014 09:54:53 PM UTC, comment #6:

AFAICS the actual bug has been fixed, and the additional bugs I found while working on it as well. So I consider this fixed; the fixes are all in the io package repo.

I'm still not convinced that the original fix for bug #43331 (related) was ever necessary; but I'll respond on that in that bug report thread later on.

Anyway this all will be part of a soon-to-be-released io-2.2.5 release.

Philip Nienhuis <philipnienhuis>
Project MemberIn charge of this item.
Sun 26 Oct 2014 10:12:15 PM UTC, comment #5:

Just a progress report:

The actual bug here has been fixed already in my local repo; the bug was introduced with the fix for bug #43331.
But delving into this one uncovered some other issues that hamper more reliable reading/writing of .xlsx.

So, it will take a little more time before I can finally push the fixes.

Philip Nienhuis <philipnienhuis>
Project MemberIn charge of this item.
Sun 12 Oct 2014 07:12:15 PM UTC, comment #4:

I used the bugfix-version.

Also, I had already implemented the workaround with xlsfinfo. It works fine.

Malte Hinrichs <maldje>
Fri 10 Oct 2014 08:24:41 PM UTC, comment #3:

Confirmed.

It seems sheet names and sheet numbers got mixed up.
This one seems a bit harder.

Philip Nienhuis <philipnienhuis>
Project MemberIn charge of this item.
Fri 10 Oct 2014 07:11:11 PM UTC, comment #2:

Did you use the latest file versions from the repo, or the plain io-2.2.4 files? (i.e., the fix from bug #43331)

Another trick may be to use
xlsfinfo (<filename>, <interface>)
(same for odsfinfo)

Philip Nienhuis <philipnienhuis>
Project MemberIn charge of this item.
Fri 10 Oct 2014 04:44:13 PM UTC, comment #1:

It should be fid=xlsopen(xlsxfile, 0, "OCT") for reading.
The result is the same.

Malte Hinrichs <maldje>
Fri 10 Oct 2014 04:42:34 PM UTC, original submission:

Please use the attached xlsx-file for testing.

This fails:

It works when sheet numbers are used instead.

Malte Hinrichs <maldje>

 

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

Attach File(s):
   
   
Comment:
   

Attached Files
file #32252:  template1.xlsx added by maldje (34KiB - application/vnd.openxmlformats-officedocument.spreadsheetml.sheet - created with Excel Version 14.3.8 130913 for OSX)

 

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

    Date Changed By Updated Field Previous Value => Replaced By
    Wed 29 Oct 2014 09:54:53 PM UTCphilipnienhuisStatusIn Progress=>Fixed
      Open/ClosedOpen=>Closed
    Mon 13 Oct 2014 01:26:13 PM UTCphilipnienhuisStatusConfirmed=>In Progress
    Fri 10 Oct 2014 08:24:41 PM UTCphilipnienhuisStatusNone=>Confirmed
      Assigned toNone=>philipnienhuis
      Release3.8.0=>other
      Operating SystemMac OS=>Any
      Summaryoct2xls fails when sheet names are being used=>[OF] oct2xls (OCT) fails when sheet names are being used
    Fri 10 Oct 2014 04:42:34 PM UTCmaldjeAttached File-=>Added template1.xlsx, #32252
      Carbon-Copy-=>Added -unavailable-

    Back to the top


    Powered by Savane 3.1-cleanup1