[Octave-bug-tracker] [bug #49286] Named ranges sometimes work, sometimes not

[Steven Weinberg]

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

                 Summary: Named ranges sometimes work, sometimes not
                 Project: GNU Octave
            Submitted by: wstevena
            Submitted on: Thu 06 Oct 2016 04:32:19 PM GMT
                Category: Libraries
                Severity: 3 - Normal
                Priority: 5 - Normal
              Item Group: Incorrect Result
                  Status: None
             Assigned to: None
         Originator Name: wstevena
        Originator Email: 
             Open/Closed: Open
         Discussion Lock: Any
                 Release: 4.0.3
        Operating System: Microsoft Windows

    _______________________________________________________

Details:


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



    _______________________________________________________

File Attachments:


-------------------------------------------------------
Date: Thu 06 Oct 2016 04:32:19 PM GMT  Name: testfile.xlsx  Size: 28kB   By:
wstevena
Here is a file with named ranges
<http://savannah.gnu.org/bugs/download.php?file_id=38676>

    _______________________________________________________

Reply to this item at:

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

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