[Octave-bug-tracker] [bug #51203] xlswrite(...'com') output in a corrupted .xlsx. 'oct' output Russian in a non-readable xlsx. 'oct' need to execute twice

[Philip Nienhuis]

Update of bug #51203 (project octave):

                  Status:                    None => Need Info              
             Assigned to:                    None => philipnienhuis         
                 Release:                   4.2.1 => dev                    

    _______________________________________________________

Follow-up Comment #1:

The issue is that you're being hit by double-byte character issues; I'm sorry
for that.  Octave isn't very good at handling double-byte characters esp. on
Windows.
Luckily there's a way out for you.

First, be sure to upgrade the io package to 2.4.7 (latest version).
Then in your script change the line:

xlswrite(filename,cell1,[],[],'oct');

into:

xls = xlsopen ("o076xls.xlsx", 1, "oct");
xls = oct2xls (cell1, xls, 1, "", struct ("convert_utf", 1));
xls = xlsclose (xls);

and try again.

If I do that I get the attached file that is read perfectly fine by Excel and
LibreOffice.

FYI: the option "convert_utf" is what you need. Try:
help oct2xls
_or_
help oct2ods
_and_ 
help xls2oct
_or_
help ods2oct
for more info.

Please report back!

Release => other (as it is an OF package issue and not core Octave)


(file #40885)
    _______________________________________________________

Additional Item Attachment:

File name: o076xls-2.7z                   Size:5 KB


    _______________________________________________________

Reply to this item at:

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

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