bugGNU Octave - Bugs: bug #49579, io package: Error reading xlsx...

 
 

bug #49579: io package: Error reading xlsx with OCT interface

Submitter:  None
Submitted:  Fri 11 Nov 2016 07:51:09 PM UTC
   
 
Category:  Octave Package Severity:  3 - Normal
Priority:  5 - Normal Item Group:  None
Status:  Fixed Assigned to:  philipnienhuis
Originator Name:  Will Originator Email:  -email is unavailable-
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

Mon 14 Nov 2016 09:16:35 PM UTC, comment #6: 

Thanks for testing.
I pushed the fix here:
http://hg.code.sf.net/p/octave/io/rev/9fb4f2ac6df8

For mxe a temporary fix has been pushed as well, see patch #9160

Closing report.

Philip Nienhuis <philipnienhuis>
Group Member
Mon 14 Nov 2016 02:31:18 PM UTC, comment #5: 

I used the fix suggested in comment #3.  L.199 now reads

vals(ids) = {""};


That fixes it.  I double checked a few different ways, and it handles the multiple empty cells correctly.

Thank you.

Will Drake <wdrake>
Sat 12 Nov 2016 12:15:54 PM UTC, comment #4: 

That should read:
(Not*e*: parens at LHS, curly braces at RHS)

Philip Nienhuis <philipnienhuis>
Group Member
Fri 11 Nov 2016 10:45:20 PM UTC, comment #3: 

OK, try replacing L.199 with:

vals(ids) = {""};


(not parens at LHS, curly braces at RHS)
and report back.

Philip Nienhuis <philipnienhuis>
Group Member
Fri 11 Nov 2016 09:13:57 PM UTC, comment #2: 

Replaced L.199 with

vals(ids) = "";


This generates a different error:

A(I) = X: X must have the same size as I



Will Drake <wdrake>
Fri 11 Nov 2016 08:43:27 PM UTC, comment #1: 

Please replace the line 199

vals {find (ids)} = "";


with

vals(ids) = "";


(note: parenthses, not curly braces) and report back.

OS => any, Release => other (s it's an OF package issue)

Philip Nienhuis <philipnienhuis>
Group Member
Fri 11 Nov 2016 07:51:09 PM UTC, original submission:  

i686-w64-mingw32
Octave Version 4.0.3
io-2.4.5

I had the following error trying to read an .xlsx file using the OCT interface.


invalid assignment to cs-list outside multiple assignment
error: called from '__OCT_xlsx2oct__'...


The error originate at L.199 when it attempts to fill "" for empty cells. The attached spreadsheet has two empty cells which L.199 attempts to fill simultaneously. In other words, size(ids) is 2, which generates an error here:


vals {find (ids)} = "";


I have a work around replacing the empty cells one-by-one but it is only a temporary fix.

Anonymous

 

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

Attach Files:
   
   
Comment:
   

Attached Files
file #38937:  Test Report D16-051-1.xlsx added by None (17KiB - application/vnd.openxmlformats-officedocument.spreadsheetml.sheet - 1) Spreadsheet that generates the error. 2) Original xlsx2oct scipt. 3) Temporary modified xlsx2oct script)
file #38938:  __OCT_xlsx2oct__ - TEMP.m added by None (12KiB - application/octet-stream - 1) Spreadsheet that generates the error. 2) Original xlsx2oct scipt. 3) Temporary modified xlsx2oct script)
file #38939:  __OCT_xlsx2oct__.m added by None (12KiB - application/octet-stream - 1) Spreadsheet that generates the error. 2) Original xlsx2oct scipt. 3) Temporary modified xlsx2oct script)

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by wdrake (Posted a comment)
  • -email is unavailable- added by mtmiller (Updated 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 11 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2016-11-14 philipnienhuis StatusConfirmed Fixed
        Open/ClosedOpen Closed
    2016-11-11 philipnienhuis StatusNone Confirmed
        Assigned toNone philipnienhuis
        Release4.0.3 other
        Operating SystemMicrosoft Windows Any
    2016-11-11 mtmiller CategoryOctave Function Octave Package
        SummaryError reading xlsx with OCT interface io package: Error reading xlsx with OCT interface
    2016-11-11 None Attached File- Added Test Report D16-051-1.xlsx, #38937
        Attached File- Added _OCT_xlsx2oct_ - TEMP.m, #38938
        Attached File- Added _OCT_xlsx2oct_.m, #38939

    Back to the top

    Powered by Savane 3.13-3230.
    Corresponding source code