character '&' not supported in excel 2003

Topics: Developer Forum
Jun 9, 2009 at 12:09 PM

I have encountered an issue about saving file into excel 2003 if there is character '&' in formula. 
'=REPT(" ",$B$93-LEN(B9))&B9'
the red one not appear if i save it to excel2003.

is there any suggestion, please.

 

Developer
Jun 10, 2009 at 6:33 AM

You are correct. There are unfortunately some bugs with formulas in Excel5 writer. Please vote for this issue:

http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=7895