Free Support Forum - aspose.com

Overloaded Formats of Cells.PutValue DO NOT UPDATE CHARTS

myworkbook.worksheets("MySheet").Cells(3,3).PutValue(94) will not update a chart using that cell.

However:

myworkbook.worksheets("MySheet").Cells("D3").PutValue(94) will update the chart.

?????????????????


This message was posted using Aspose.Live 2 Forum

Hi,

Well, Aspose.Cells uses zero-based indexes for rows and columns in a worksheet. I think you are wrong Cells(3,3) is not equal to Cells("D3"). Actually Cells(3,3) = Cells("D4").

so you should change your line of code to:

myworkbook.worksheets("MySheet").Cells(2,3).PutValue(94)

Thank you.