[Octave-bug-tracker] [bug #43353] xlswrite in io-2.2.4 cannot add worksheet NAME to file with worksheet NAMExyz

[Malte Hinrichs]

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

                 Summary: xlswrite in io-2.2.4 cannot add worksheet NAME to
file with worksheet NAMExyz
                 Project: GNU Octave
            Submitted by: maldje
            Submitted on: Sa 04 Okt 2014 00:07:20 GMT
                Category: Octave Forge Package
                Severity: 3 - Normal
                Priority: 5 - Normal
              Item Group: Inaccurate Result
                  Status: None
             Assigned to: None
         Originator Name: Malte Hinrichs
        Originator Email: 
             Open/Closed: Open
         Discussion Lock: Any
                 Release: 3.8.0
        Operating System: Mac OS

    _______________________________________________________

Details:

The following gives the expected result:


xlswrite("file.xlsx",ones(3),"sheet","A1:C3","OCT")
xlswrite("file.xlsx",ones(3),"sheet0","A1:C3","OCT")


Reversing the order does not:


xlswrite("file2.xlsx",ones(3),"sheet0","A1:C3","OCT")
xlswrite("file2.xlsx",ones(3),"sheet","A1:C3","OCT")


This can be corrected by changing line 84 in private/__OCT_oct2xls__.m from


    wsh_number = strmatch (wsh, xls.sheets.sh_names);


to


    wsh_number = strmatch (wsh, xls.sheets.sh_names,'exact');







    _______________________________________________________

Reply to this item at:

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

_______________________________________________
  Nachricht gesendet von/durch Savannah
  http://savannah.gnu.org/