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

Trim Spaces on save

Jan 5, 2011 at 10:18 AM

Hi, i try to find a discussion about this subject but i cant find a solution and i hope people on forum can help me.

I have a trouble when i save the excel file generated, i have some cells that contains text that begins with some spaces like "   Hi excel."., when i debug the application and "see" the cell value, it seems correct but after save the cell contains only the text without start spaces ie. "Hi excel.".

Could anybody help me with that?.

Thanks in advance.


P.D.:Please excuse my poor english level ;)               .

Jan 9, 2011 at 7:11 PM


No, that should be fixed. Heading and Trailing spaces are truncated in the xml (if you don't add the preserve whitespaces attribute to the shared string internally, something like this...<t xml:space="preserve"></t> ).

I'll try to add fix for it.


Mar 8, 2011 at 4:09 PM


you have to add a secured space with ALT+0160 instead of your normal spaces.

It worked for me :).