bugGNU Octave - Bugs: bug #47197, octave-forge io package: xlswrite...

 
 

bug #47197: octave-forge io package: xlswrite has problems if string has &,<,>,"

Submitted by:  Andreas Weber <andy1978>
Submitted on:  Fri 19 Feb 2016 08:26:06 AM UTC  
 
Category: Octave Forge PackageSeverity: 3 - Normal
Priority: 5 - NormalItem Group: Incorrect Result
Status: FixedAssigned to: None
Originator Name: Open/Closed: Closed
Release: otherOperating System: GNU/Linux

Add a New Comment(Rich Markup)
   

You are not logged in

Please log in, so followups can be emailed to you.

 

Fri 19 Feb 2016 05:21:54 PM UTC, comment #3:

BTW the fix is here:
http://hg.code.sf.net/p/octave/io/rev/6d8a647d1b8c

Philip Nienhuis <philipnienhuis>
Project Member
Fri 19 Feb 2016 01:08:28 PM UTC, comment #2:

This has been fixed a while ago in io-2.4.1 which is scrutinized right now (by the current 1-person test panel). I expect (hope) it to be out soon.
Along the way I've fixed some related issues as well, notably filtering out unicode stuff from XML-based spreadsheet formats that Octave doesn't understand currently.

If you want you can grab the relevant code from the repo.

Closing as already fixed (can always be reopened if you find the new code not working properly)

Philip Nienhuis <philipnienhuis>
Project Member
Fri 19 Feb 2016 08:57:40 AM UTC, comment #1:

I guess there are some chars which should be replaced. There is some code which does this if xlsx is read, for example _OCT_xlsx2oct_.m:126

But I can't find code for the other way (writing to xlsx).

Andreas Weber <andy1978>
Project Member
Fri 19 Feb 2016 08:26:06 AM UTC, original submission:

GNU Octave Version: 4.0.0, io 2.4.0

In the generated file the last cell is "foo%bar", the strings afterwards are not written.

Andreas Weber <andy1978>
Project Member

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach File(s):
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -unavailable- added by andy1978 (Submitted the item)
  •  

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only project members can vote.

     

    Please enter the title of George Orwell's famous dystopian book (it's a date):

     

     

    Follow 4 latest changes.

    Date Changed By Updated Field Previous Value => Replaced By
    Fri 19 Feb 2016 01:08:28 PM UTCphilipnienhuisStatusNone=>Fixed
      Open/ClosedOpen=>Closed
      Release4.0.0=>other
    Fri 19 Feb 2016 08:55:39 AM UTCandy1978Summaryoctave-forge io package: xlswrite has problems if string has "&"=>octave-forge io package: xlswrite has problems if string has &,<,>,"

    Back to the top


    Powered by Savane 3.1-cleanup1