bugGNU Octave - Bugs: bug #49286, Named ranges sometimes work,...

 
 

bug #49286: Named ranges sometimes work, sometimes not

Submitter:  Steven Weinberg <wstevena>
Submitted:  Thu 06 Oct 2016 04:32:19 PM UTC
   
 
Category:  Octave Package Severity:  3 - Normal
Priority:  5 - Normal Item Group:  Incorrect Result
Status:  Fixed Assigned to:  philipnienhuis
Originator Name:  wstevena Open/Closed:  * Closed
Release:  * other Operating System:  * Other
Fixed Release:  None Planned Release:  None
* Mandatory Fields

Add a New Comment Rich Markup
   

Thu 06 Oct 2016 09:27:08 PM UTC, comment #5: 

Good!
Thanks for reporting & testing.

I think an io-2.4.4 bug fix release should be out soon. I already have one here for testing, so in a way this bug report came just in time :-)

Closing as fixed.

Philip Nienhuis <philipnienhuis>
Group Member
Thu 06 Oct 2016 08:58:09 PM UTC, comment #4: 

It works now! Reads it just fine.
Thank you.

Steven Weinberg <wstevena>
Thu 06 Oct 2016 08:30:19 PM UTC, comment #3: 

Please swap the attached chknmrange.m with the one in the subdir given by the following commands:

pkg load io    ## if io wasn't already loaded
strrep (which ("xls2oct"), "xls2oct.m", "private")

then try again the offending xlsread commands, and report back whether it fixed the problem for you.


(file #38678)

Philip Nienhuis <philipnienhuis>
Group Member
Thu 06 Oct 2016 04:51:00 PM UTC, comment #2: 

Sorry I overlooked the last line (io 2.4.1).


Philip Nienhuis <philipnienhuis>
Group Member
Thu 06 Oct 2016 04:49:19 PM UTC, comment #1: 

Which io package release?  (look in the output of "pkg list")

I'll have a look anyway.

Category -> Octave-Forge pckage (io package)
Release -> other (not core Octave but an OF package)
Operating system -> any

Philip Nienhuis <philipnienhuis>
Group Member
Thu 06 Oct 2016 04:32:19 PM UTC, original submission:  


intfname = 'testfile.xlsx';

>> [junk cnames_long] = xlsread(intfname,'MAIN','cnames_long');

>> junk
junk = [](0x0)
>> cnames_long
cnames_long =
{
  [1,1] = ARGENTINA
  [2,1] = AUSTRALIA
  [3,1] = AUSTRIA
  [4,1] = BELGIUM
  [5,1] = BRAZIL
  [6,1] = CANADA
  [7,1] = CHINA
  [8,1] = CHILE
  [9,1] = FINLAND
  [10,1] = FRANCE
  [11,1] = GERMANY
  [12,1] = INDIA
  [13,1] = INDONESIA
  [14,1] = ITALY
  [15,1] = JAPAN
  [16,1] = KOREA
  [17,1] = MALAYSIA
  [18,1] = MEXICO
  [19,1] = NETHERLANDS
  [20,1] = NORWAY
  [21,1] = NEW ZEALAND
  [22,1] = PERU
  [23,1] = PHILIPPINES
  [24,1] = SOUTH AFRICA
  [25,1] = SAUDI ARABIA
  [26,1] = SINGAPORE
  [27,1] = SPAIN
  [28,1] = SWEDEN
  [29,1] = SWITZERLAND
  [30,1] = THAILAND
  [31,1] = TURKEY
  [32,1] = UNITED KINGDOM
  [33,1] = USA
}
>> [junk cnames] = xlsread(intfname,'MAIN','cnames');

error: Invalid call to isempty.  Correct usage is:

 -- Built-in Function: isempty (A)
error: called from
    print_usage at line 90 column 5
    chknmrange at line 63 column 9
    xls2oct at line 148 column 23
    xlsread at line 203 column 27

>> [junk cnames] = xlsread(intfname,'MAIN','F5:F500');

>> cnames
cnames =
{
  [1,1] = arg
  [2,1] = austlia
  [3,1] = austria
  [4,1] = bel
  [5,1] = bra
  [6,1] = can
  [7,1] = china
  [8,1] = chl
  [9,1] = fin
  [10,1] = france
  [11,1] = germ
  [12,1] = india
  [13,1] = indns
  [14,1] = italy
  [15,1] = japan
  [16,1] = kor
  [17,1] = mal
  [18,1] = mex
  [19,1] = neth
  [20,1] = nor
  [21,1] = nzld
  [22,1] = per
  [23,1] = phlp
  [24,1] = safrc
  [25,1] = sarbia
  [26,1] = sing
  [27,1] = spain
  [28,1] = swe
  [29,1] = switz
  [30,1] = thai
  [31,1] = turk
  [32,1] = uk
  [33,1] = usa
}
>>


I am using the io package 2.4.1

Steven Weinberg <wstevena>

 

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

Attach Files:
   
   
Comment:
   

Attached Files
file #38678:  chknmrange.m added by philipnienhuis (3KiB - text/x-matlab)
file #38676:  testfile.xlsx added by wstevena (28KiB - application/vnd.openxmlformats-officedocument.spreadsheetml.sheet - Here is a file with named ranges)

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by wstevena (Submitted 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-10-06 philipnienhuis StatusReady For Test Fixed
        Open/ClosedOpen Closed
    2016-10-06 philipnienhuis Attached File- Added chknmrange.m, #38678
        StatusNone Ready For Test
        Assigned toNone philipnienhuis
    2016-10-06 philipnienhuis StatusNeed Info None
    2016-10-06 philipnienhuis CategoryLibraries Octave Package
        StatusNone Need Info
        Release4.0.3 other
        Operating SystemMicrosoft Windows Other
    2016-10-06 wstevena Attached File- Added testfile.xlsx, #38676

    Back to the top

    Powered by Savane 3.13-4448.
    Corresponding source code