Free Support Forum - aspose.com

Methods/Functions/Properties either no longer existing or obsolete when upgrading to newest Aspose.Cells version

Hi,


I recently updated my version of Aspose.Cells from version 4.9 to the latest version. I had a lot of existing code which referenced the older version. I have some errors in which I cannot resolve (cannot find the proper new method/function to replace the old one with) -

currentSheet.GetPageCount(PrintingPageType.Default)
* GetPageCount is longer a method? I cannot find a current method similar

Dim fcs As Aspose.Cells.FormatConditions = sheet.ConditionalFormattings(index)
* I cannot figure out how to change this line of code to conform with the new version
* Apparantly FormatConditions is no longer available

Any suggestions/help would be appreciated thanks

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

For page count, I think, the similar function is Worksheet.GetPrintingPageBreaks(). If you let us know what the function does for you in the old code, then, we will be able to find the right function.

For conditional formatting, please see this article for your more help. You can use its code as per your needs.

Hi,

bsheriff:
Dim fcs As Aspose.Cells.FormatConditions = sheet.ConditionalFormattings(index)
* I cannot figure out how to change this line of code to conform with the new version
* Apparantly FormatConditions is no longer available


Please change your line of code to:

Dim fcs As Aspose.Cells.FormatConditionCollection = sheet.ConditionalFormattings(index)


In the new versions we have renamed certain classes as XXXXCollection, e.g
Worksheets (older) --> WorksheetCollection (new)
ConditionalFormattings (old) --> ConditionalFormattingCollection
PivotTables (old) --> PivotTableCollection
Charts --> ChartCollection

etc.


Thank you.