Unable to create a spreadsheet if non printable characters are included in a cell

May 3, 2010 at 4:00 PM

I am trying to create a spreadsheet that contains non printable ascii characters.  I am able to create the spreadsheet if I exclude this data, but as soon as a I add the cell that contains the Record Separator(decimal 29) and group Separator(decimal 30), the spreadsheet will not save the data. When I try to open it, I get a message that says:  Excel has found unreadable content.   It will then open but the data is not there.   Is there a way to format the cell so that it will save the data correctly?



Denny Moore


Jul 1, 2010 at 10:50 AM

There maybe a problem with not correctly (or no at all) handled entity/custom chars encoding. I think EP doesnt do anything about that. Some "xml encode" might help. Just find a routine that inserts a string into cell or sahred string table and try to encode it.