If I have leading spaces in a cell value the spaces appear to get dropped when viewing in excel.
For example,
The following code will show no spaces in the excel cell.
oWorksheetCell:VALUE = " TEST".
I finally received the SR and it did solve my issue. Thank You.
I have requested the SR from where I purchased the controls. We buy through Progress Software and have forwarded your post to them.
I should have everything I need...Thank You.
Hello,
I am just checking about the progress of this issue. Let me know if you need my further assistance on it.
Thank you for using Infragistics Components.
Hello Roger,
Thank you for contacting Infragistics Support.
The issue you are experiencing is known issue and it was fixed in Infragistics WinForms 2014 Volume 1 Service Release 14.1.20141.2059. For more information you may follow the next link and look for “Initial cell spacing is not applied when exporting to ".xlsx" files.” In description column http://dl.infragistics.com/community/winforms/ReleaseNotes/WindowsForms_14_1_ServiceReleaseNotes_July_2014.pdf
To fix this issue please update to the latest service release of Infragistics WinForms following the steps in this forum thread http://ko.infragistics.com/community/forums/t/29398.aspx
Please let me know if you need any further assistance.
I just checked my old app that used 11.2.20112.2135 and the problem did not exist.