Empty cells in Excell ->  


#1

I search and found a thread about this, but the latest version has that problem. When I save a grid to excel I get   in empty cells, but this only occurs when in the column there is a non-empty cell. When all the cells are empty, we don’t get  


#2

Please download and try v3.0.0.1 at http://www.aspose.com/Products/Aspose.Excel/Downloads.html


#3

the &nsbp; are gone, but this version got a performance issue. It is very slow.
The worksheet has about 500 rows and it takes about 1 minute to generate the spreadsheet.


#4

Please download and try the latest version at http://www.aspose.com/Products/Aspose.Excel/Downloads.html. We had optimized this method.


#5

I get an exception:
Index and length must refer to a location within the string.
Parameter name: length

Source is mscorlib.

at System.String.Substring(Int32 startIndex, Int32 length)
at Aspose.Excel.Cells.ImportDataGrid(DataGrid dataGrid, Int32 firstRow, Byte firstColumn, Boolean insertRows)
at FloraHolland.Naaldwijk.UIL.WebForm.BaseCollectionForm.SendDataAsExcel(String fileName, DataSet downloadData, DataGrid definitieGrid)


#6

Please try this fix.


#7

New exception:
“Index was outside the bounds of the array.”

StackTrace
at System.String.get_Chars(Int32 index)
at Aspose.Excel.Cells.ImportDataGrid(DataGrid dataGrid, Int32 firstRow, Byte firstColumn, Boolean insertRows)
at FloraHolland.Naaldwijk.UIL.WebForm.BaseCollectionForm.SendDataAsExcel(String fileName, DataSet downloadData, DataGrid definitieGrid)

Greetings, Nico


#8

Please re-download the new fix at http://www.aspose.com/Products/Aspose.Excel/Fixes/Aspose.Excel.zip.


#9

Still got the same exception.


#10

I think I know what the problem is. In one of the fields is the name of our customer. If in the name the character ‘&’ is used I get the exception, if not I don’t. I haven’t checked if other characters create this problems.

Greetings, Nico


#11

Hi Nico,

Thanks for your report. Please try v3.0.1.4 at http://www.aspose.com/Products/Aspose.Excel/Fixes/Aspose.Excel.zip.


#12

Works great ! And quick.

Thanks, Nico