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

 
 

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

Submitted by:  None
Submitted on:  Fri 11 Nov 2016 07:51:09 PM UTC  
 
Category: Octave Forge PackageSeverity: 3 - Normal
Priority: 5 - NormalItem Group: None
Status: FixedAssigned to: Philip Nienhuis <philipnienhuis>
Originator Name: WillOriginator Email: -unavailable-
Open/Closed: ClosedRelease: other
Operating 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)

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>
Project MemberIn charge of this item.
Mon 14 Nov 2016 02:31:18 PM UTC, comment #5:

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

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:
(Note: parens at LHS, curly braces at RHS)

Philip Nienhuis <philipnienhuis>
Project MemberIn charge of this item.
Fri 11 Nov 2016 10:45:20 PM UTC, comment #3:

OK, try replacing L.199 with:

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

Philip Nienhuis <philipnienhuis>
Project MemberIn charge of this item.
Fri 11 Nov 2016 09:13:57 PM UTC, comment #2:

Replaced L.199 with

This generates a different error:

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

Please replace the line 199

with

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

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

Philip Nienhuis <philipnienhuis>
Project MemberIn charge of this item.
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.

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:

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 File(s):
   
   
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
  • -unavailable- added by wdrake (Posted a comment)
  • -unavailable- added by mtmiller (Updated the item)
  •  

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

    Date Changed By Updated Field Previous Value => Replaced By
    Mon 14 Nov 2016 09:16:35 PM UTCphilipnienhuisStatusConfirmed=>Fixed
      Open/ClosedOpen=>Closed
    Fri 11 Nov 2016 08:43:27 PM UTCphilipnienhuisStatusNone=>Confirmed
      Assigned toNone=>philipnienhuis
      Release4.0.3=>other
      Operating SystemMicrosoft Windows=>Any
    Fri 11 Nov 2016 08:03:21 PM UTCmtmillerCategoryOctave Function=>Octave Forge Package
      SummaryError reading xlsx with OCT interface =>io package: Error reading xlsx with OCT interface
    Fri 11 Nov 2016 07:51:09 PM UTCNoneAttached 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.1-cleanup1