Garbage text in cells

Aspose.Cells Product Family
1

Garbage text in cells.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

I recently installed the latest version of Aspose.Excel v3.2.4.0 to fix this problem and others but garbage text is still inserted in each worksheet.

This morning I found the article

and proceeded to download my license again but the problem persist.<o:p></o:p>

<o:p> </o:p>

The original version of Aspose.Excel I was using when we purchased this component last April did not have this problem.<o:p></o:p>

<o:p> </o:p>

Is this a license issue or else?<o:p></o:p>

<o:p> </o:p>

Garbage text gets inserted in worksheets after simply opening a workbook and saving it back to disk.<o:p></o:p>

2

Hi Christian,

Yes. I think this is a license issue. Is there an extra license sheet in your generated file?

Please check Licensing for how to license the component.

3

Laurence,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

There is no extras license sheet created such as the one I had when using the demo.

I just realized my mistake by wanting to create a simple procedure to demonstrate the problem.

The code below will reproduce the problem and insert garbage text

Sub TestAsposeExcel()

Dim Excel1 As Excel = New Excel

Excel1.Open("New Microsoft Excel Worksheet.xls")

Dim license As License = New License

license.SetLicense("Aspose.Excel.lic")

Excel1.Save("New Microsoft Excel Worksheet.xls", FileFormatType.Excel2003)

End Sub

While writing this procedure I realized my error.

Calling the Open method after the SetLicense fixed the problem.

Sub TestAsposeExcel()

Dim Excel1 As Excel = New Excel

Dim license As License = New License

license.SetLicense("Aspose.Excel.lic")

Excel1.Open("New Microsoft Excel Worksheet.xls")

Excel1.Save("New Microsoft Excel Worksheet.xls", FileFormatType.Excel2003)

End Sub


Thank you for your quick response.

4

Yes. The SetLicense method should be called at the start of program.