Control Characters in Excel 2007

Oct 21, 2007 at 10:14 PM
Edited Oct 21, 2007 at 10:44 PM
I know it's uncommon, but i happened to have an xlsx file with control char in cell.
excel supports control char all the way. but xml 1.0 doesn't support most of control char.
so when there is a control char in cell, MS use some escape rule to transform them.
I didn't check Open XML documents, so i'm not sure if there is a rule in the doc.
I read some PHPExcel code. seems that PHPExcel just use simplexmlloadstring to load the strings in SharedStrings.xml
The following is what I tried in excel 2007
control char 1A => _x001A_
_x001A_ => _x005F_001A_
_ => _

i will send you a sample xlsx file to your email box:
m a a r t e n AT p h p e x c e l DOT n e t

please check it out
Nov 19, 2007 at 11:01 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.