[Octave-bug-tracker] [bug #49558] Spreadsheet named range error

[Steven Weinberg]

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

                 Summary: Spreadsheet named range error
                 Project: GNU Octave
            Submitted by: wstevena
            Submitted on: Tue 08 Nov 2016 01:39:28 PM GMT
                Category: Octave Forge Package
                Severity: 3 - Normal
                Priority: 5 - Normal
              Item Group: Incorrect Result
                  Status: None
             Assigned to: None
         Originator Name: Steve Weinberg
        Originator Email: 
             Open/Closed: Open
         Discussion Lock: Any
                 Release: 4.2.0-rc3
        Operating System: Microsoft Windows

    _______________________________________________________

Details:

++
intfname='gvarbriefdemo3.xlsx';
[status,sheets] = xlsfinfo(intfname); % assuming gvar.xls is the name of the
interface file
wnames=sheets(:,1);
maxlag_du = xlsread(intfname,'DOMINANT UNIT','maxlag_du');
--
error: Worksheet name "'DOMINANT UNIT'" not present
error: called from
    __COM_spsh2oct__ at line 84 column 7
    xls2oct at line 173 column 25
    xlsread at line 202 column 29
    du at line 12 column 11
>> wnames
wnames =
{
  [1,1] = MAIN
  [2,1] = DOMINANT UNIT
}

However if I change the call to:
++
maxlag_du = xlsread(intfname,'DOMINANT UNIT','J14');
--

then the read works. I have also attached the chknmrange.m file I was provided
to correct an earlier named range issue.




    _______________________________________________________

File Attachments:


-------------------------------------------------------
Date: Tue 08 Nov 2016 01:39:28 PM GMT  Name: gvarBriefDemo3.xlsx  Size: 2MB  
By: wstevena

<http://savannah.gnu.org/bugs/download.php?file_id=38903>
-------------------------------------------------------
Date: Tue 08 Nov 2016 01:39:28 PM GMT  Name: chknmrange.m  Size: 3kB   By:
wstevena

<http://savannah.gnu.org/bugs/download.php?file_id=38904>

    _______________________________________________________

Reply to this item at:

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

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