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

 
 

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

Submitter:  Malte Hinrichs <maldje>
Submitted:  Fri 10 Oct 2014 04:42:34 PM UTC
   
 
Category:  Octave Package Severity:  3 - Normal
Priority:  5 - Normal Item Group:  Inaccurate Result
Status:  Fixed Assigned to:  philipnienhuis
Originator Name:  Malte Hinrichs 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

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>
Group Member
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>
Group Member
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>
Group Member
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>
Group Member
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:


xlsxfile="template1.xlsx"
fid=xlsopen(xlsxfile, 1, "OCT");
[cFEA fid stat]=xls2oct(fid, "FEA");
[cSM fid stat]=xls2oct(fid, "SM");
[cCLC fid stat]=xls2oct(fid, "CLC");
[cECU fid stat]=xls2oct(fid, "ECU");

error: Couldn't open worksheet xml file sheet6.xml


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

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

    Date Changed by Updated Field Previous Value => Replaced by
    2014-10-29 philipnienhuis StatusIn Progress Fixed
        Open/ClosedOpen Closed
    2014-10-13 philipnienhuis StatusConfirmed In Progress
    2014-10-10 philipnienhuis StatusNone 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
    2014-10-10 maldje Attached File- Added template1.xlsx, #32252
        Carbon-Copy- Added -email is unavailable-

    Back to the top

    Powered by Savane 3.13-4448.
    Corresponding source code