content with vertical tab fails to export right

Issue #230 resolved
anil_srik created an issue
import openpyxl
from openpyxl import Workbook
wb = Workbook()
ws = wb.create_sheet(0)
ws.cell(row=1,column=1).value = 'test \v test''C:\Temp\1.xlsx')

On save and opening the file on Win XP SP3 and Excel 2007 there is an error. And the xml that the error points to (see attached image) has no relevant information.

I'm running on Python 2.7.5

Comments (7)

  1. Eric Gazoni

    thanks for reporting, I don't really know if this is caused by Excel not being able to recongnize the \v construct (first time I encounter it) or if it's linked to the version of openpyxl you're using (2.0.0 is the upcoming release, the current stable version is 1.6.2). Did it use to work in previous versions ?

  2. anil_srik reporter

    I had noticed it on version 1.5.8 and I tried it on 1.6.2 as well. Both of these seem to have the same issue. Excel as such recognizes the '\v' (vertical tab - ASCII-11) Tried this as well.

  3. CharlieC

    Using \v will now result in an exception as an invalid character. This means that if \v is supported it must probably be escaped as XML beforehand.

  4. Log in to comment