[Octave-bug-tracker] [bug #49579] Error reading xlsx with OCT interface

[anonymous]

URL:
  <http://savannah.gnu.org/bugs/?49579>

                 Summary: Error reading xlsx with OCT interface 
                 Project: GNU Octave
            Submitted by: None
            Submitted on: Fri 11 Nov 2016 07:51:09 PM UTC
                Category: Octave Function
                Severity: 3 - Normal
                Priority: 5 - Normal
              Item Group: None
                  Status: None
             Assigned to: None
         Originator Name: Will
        Originator Email: 
             Open/Closed: Open
         Discussion Lock: Any
                 Release: 4.0.3
        Operating System: Microsoft Windows

    _______________________________________________________

Details:

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.  



    _______________________________________________________

File Attachments:


-------------------------------------------------------
Date: Fri 11 Nov 2016 07:51:09 PM UTC  Name: Test Report D16-051-1.xlsx  Size:
17kB   By: None
1) Spreadsheet that generates the error.  2) Original xlsx2oct scipt.  3)
Temporary modified xlsx2oct script
<http://savannah.gnu.org/bugs/download.php?file_id=38937>
-------------------------------------------------------
Date: Fri 11 Nov 2016 07:51:09 PM UTC  Name: __OCT_xlsx2oct__ - TEMP.m  Size:
12kB   By: None
1) Spreadsheet that generates the error.  2) Original xlsx2oct scipt.  3)
Temporary modified xlsx2oct script
<http://savannah.gnu.org/bugs/download.php?file_id=38938>
-------------------------------------------------------
Date: Fri 11 Nov 2016 07:51:09 PM UTC  Name: __OCT_xlsx2oct__.m  Size: 12kB  
By: None
1) Spreadsheet that generates the error.  2) Original xlsx2oct scipt.  3)
Temporary modified xlsx2oct script
<http://savannah.gnu.org/bugs/download.php?file_id=38939>

    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/bugs/?49579>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/