We upgraded from aspose.excel to aspose.cells 4.4.1 recently. i am in the process of modifying existing applications to use to aspose.cells. I am using the xls templates files(that has charts) to populate the report and charts. i am using simple search and replace function to populate the cells looping through each sheet . I never had any problem in aspose.excel . The datalables in the charts are not showing the value properly as soon as i changed to use aspose.cells..The numbers are wrapped in the charts especially if it is large numbers. do i have to change any code if i convert any application from aspose.excel to aspose.cells. I am not using any specific code to populate charts. Its just search and replace . I need help . following is my replace function .
Private Sub ReplaceXltCellForNumValue(ByRef CurrentSheet As Worksheet, ByVal SearchFor As String, ByVal ReplaceNumValue As Double)
'Put a string into a cell
Dim currentCells As Cells = CurrentSheet.Cells()
Dim currentcell As Cell
For Each currentcell In currentCells
If currentcell.StringValue = SearchFor Then