This project has moved and is read-only. For the latest updates, please go here.

Bug? Strange character after line break for merged cells content

Jan 11, 2012 at 4:40 AM

 

Two cases:

  1. If I read a XLSX file with merged cells and content has line break text, when I save a new XLSX a strange character is showed together (_x00D_).
  2. For new XLSX file, same case, merged cells and content has line break, using \r\n ou Environment.Newline, the same _x00D_ is showed.

Ps: <br> not work for line break.

Sample code: string.Format("{1}{0}{2}{0}{3}{0}{4}{0}{5}", "\r\n", "LINHA 1", "LINHA 2", "LINHA 3", "LINHA 4", "LINHA 5");

Result:

XXX_x00D_
XXX_x00D_
XXX_x00D_
XXX_x00D_
XXX