[Octave-bug-tracker] [bug #53298] xlswrite fails when merge cells exist in worksheet(s)

[anonymous]

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

                 Summary: xlswrite fails when merge cells exist in
worksheet(s)
                 Project: GNU Octave
            Submitted by: None
            Submitted on: Tue 06 Mar 2018 09:05:32 PM UTC
                Category: Octave Forge Package
                Severity: 3 - Normal
                Priority: 5 - Normal
              Item Group: Incorrect Result
                  Status: None
             Assigned to: None
         Originator Name: grg
        Originator Email: address@hidden
             Open/Closed: Open
         Discussion Lock: Any
                 Release: 4.2.1
        Operating System: GNU/Linux

    _______________________________________________________

Details:

File tmp.xlsx contains two worksheets ("Irradiance" and "low radiance_222").

Both worksheets contain merged cells and pre-existing information in several
cells (merged and not).

When I try to write data from octave in range B5:H5 of worksheet "Irradiance",
xlswrite wipes out all the information contained in the cells where I am not
writing. 

Interestingly, xlswrite also wipes out all pre-existing data from worksheet
"low radiance_222", but keeps the existing info in range B5:H5.

I use the following commands:


OUT_olci = [4.541      8.5416      14.437      24.884      40.084       51.27 
    55.424];
input_parameters.sheet = "Irradiance";
fnout = "tmp.xlsx";
status = xlswrite(fnout, OUT_olci, input_parameters.sheet, 'B5:H5')


I'm attaching the following files:
1) tmp.xlsx
2) tmp_result.xlsx (what I get)
3) tmp_expected.xlsx (what I'm expecting).

Thanks for any help you may provide.
grg
 




    _______________________________________________________

File Attachments:


-------------------------------------------------------
Date: Tue 06 Mar 2018 09:05:32 PM UTC  Name: tmp.xlsx  Size: 12KiB   By: None

<http://savannah.gnu.org/bugs/download.php?file_id=43478>
-------------------------------------------------------
Date: Tue 06 Mar 2018 09:05:32 PM UTC  Name: tmp_expected.xlsx  Size: 12KiB  
By: None

<http://savannah.gnu.org/bugs/download.php?file_id=43479>
-------------------------------------------------------
Date: Tue 06 Mar 2018 09:05:32 PM UTC  Name: tmp_result.xlsx  Size: 10KiB  
By: None

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

    _______________________________________________________

Reply to this item at:

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

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