Clearing a whole range


#1

I have a need of clearing a whole range of values and sometimes of their formatting. In excel I am able to do it using the range class, and applying the clearcontents. Is there an equivalent way of doing this in aspose.excel? Range object does not have any methods I could see that can do this, nor does cells object.


#2

Hi,

Thanks for your consideration.

Now you can use Cell.PutValue(null) to clear content of a cell. I will add two methods to clear contents and formatting of a range of cells.

Cells.Clear(…) //Clear contents and formatting of a range
Cells.ClearContents(…) //Clear contents of a range

This feature will be available before the end of next week. Thanks for your waiting.


#3

Hi,

Please download hotfix 1.8.7. This feature is available. You can refer to http://www.aspose.com/forums/ShowPost.aspx?PostID=3404 for the usage.