Empty cells in Excell ->  

Aspose.Cells Product Family
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

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

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 the 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

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

12

Works great ! And quick.

Thanks, Nico