[Octave-bug-tracker] [bug #49510] after an xlswrite the spreadsheet is corrupted

[Steven Weinberg]

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

                 Summary: after an xlswrite the spreadsheet is corrupted
                 Project: GNU Octave
            Submitted by: wstevena
            Submitted on: Tue 01 Nov 2016 08:47:05 PM GMT
                Category: Octave Forge Package
                Severity: 3 - Normal
                Priority: 5 - Normal
              Item Group: Matlab Compatibility
                  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:

I am using the IO package version 2.4.3 with the patched chknmrange.m file, as
provided by Philip.  This program works fine in Matlab.

Here is the test script;

++
intfname='test.xlsx';
[status,sheets] = xlsfinfo(intfname); 
poswmat=find(strncmp(sheets, 'wmat', 4));
wnames=sheets(poswmat)';
xlswrite(intfname,wnames,'MAIN','A55');
--

++
>> test

warning: xlswrite - array truncated to 1 by 1 to fit in range A55
warning: called from
    xlswrite at line 184 column 5
    test at line 12 column 1
--


When I open the corrupted spreadsheet I get:

++verbatim
-<recoveryLog
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main";>

<logFileName>error040480_05.xml</logFileName>

<summary>Errors were detected in file
'D:\GVAR_Toolbox2.0_octave\GVAR_Toolbox2.0\test.xlsx'</summary>


-<removedParts summary="Following is a list of removed parts:">

<removedPart>Removed Part: /xl/sharedStrings.xml part with XML error.
(Strings) The name in the end tag of the element must match the element type
in the start tag. Line 2, column 1071.</removedPart>

</removedParts>


-<removedRecords summary="Following is a list of removed records:">

<removedRecord>Removed Records: Cell information from
/xl/worksheets/sheet1.xml part</removedRecord>

<removedRecord>Removed Records: Cell information from
/xl/worksheets/sheet3.xml part</removedRecord>

<removedRecord>Removed Records: Cell information from
/xl/worksheets/sheet4.xml part</removedRecord>

</removedRecords>

</recoveryLog>
--verbatim






    _______________________________________________________

File Attachments:


-------------------------------------------------------
Date: Tue 01 Nov 2016 08:47:05 PM GMT  Name: test.xlsx  Size: 503kB   By:
wstevena
The first file is before running the program.  The second is after.
<http://savannah.gnu.org/bugs/download.php?file_id=38858>
-------------------------------------------------------
Date: Tue 01 Nov 2016 08:47:05 PM GMT  Name: test(corrupt).xlsx  Size: 399kB  
By: wstevena
The first file is before running the program.  The second is after.
<http://savannah.gnu.org/bugs/download.php?file_id=38859>

    _______________________________________________________

Reply to this item at:

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

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