[Octave-bug-tracker] [bug #49558] Spreadsheet named range error relating to sheet names containing spaces or quotes

[Philip Nienhuis]

Update of bug #49558 (project octave):

                  Status:                    None => Fixed                  
             Assigned to:                    None => philipnienhuis         
             Open/Closed:                    Open => Closed                 
                 Release:               4.2.0-rc3 => other                  
        Operating System:       Microsoft Windows => Any                    
                 Summary: Spreadsheet named range error => Spreadsheet named
range error relating to sheet names containing spaces or quotes

    _______________________________________________________

Follow-up Comment #4:

I fixed it in the repo and I'll upload a new io release soon [1].
The culprit was having sheet names containing spaces or quotes. They get
enclosed in single quotes when requested by the getnmranges functions. So
those outer quotes will have to be removed using a regular expression.

Spaces and quotes are allowed AFAIK, but need special treatment.

Thanks for reporting.
The fix works for me wth your example. I'll attach getnmranges.m for you
below, also replace it with the one in <io>/private/

[1]
https://sourceforge.net/p/octave/package-releases/279/

(release -> other)

(file #38910)
    _______________________________________________________

Additional Item Attachment:

File name: getnmranges.m                  Size:1 KB


    _______________________________________________________

Reply to this item at:

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

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