Posted 8 September 2017, 12:58 pm EST
1) I'm exporting to excel a spread control filled of RTF cells; when I open the excel file I get some cells (not all) full filled with the "#" character however they still contain the right text. Excel is using "text" format for the right and wrong cells.
In the code I'm using:
grid.SaveExcel(<FONT color=#800000>"c:\temp.xls"</FONT>, Spread.Model.IncludeHeaders.BothCustomOnly)
Is the RTF cell type the cause of this? I really need to keep it for display the data in the spread control.
2) I'm using row headers spans in the spread control, and at the bottom of the same excel file the last row header span envelops closely 40 (sometimes 20) empty rows after my data, Am I missing something to avoid the extra rows?
How can I send you images of these issues?