Detect circular references for formulas and update smart art text using Aspose.Cells for .NET v18.11

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

Aspose.Cells for .NET logoWe are pleased to announce the release of Aspose.Cells for .NET v18.11, the MS Excel file formats API that provides the ability to create, manipulate, convert or render MS Excel spreadsheets, and more importantly – is fully documented. Please check the document on how to install Aspose for .NET APIs directly from NuGet repository. We have added a few important features while keeping the product more stable and feature rich API. In this release, we have also added some useful enhancements and resolved a number of issues. Detailed overview of all the enhancements, bugs and changes in the APIs are documented and shared with the user. Smart art is addressed in this release such that text can be updated in the shapes. This feature will enable users to modify these objects at runtime rather than fixed text in the shapes. Moreover, using the new version, circular references for formulas can be detected. Last section on this page contains more details and links about this product.

Please check the release notes which cover all the new features, enhancements and list of bugs which are resolved in this new version. New features are always introduced for enhancing this product which helps us to compete the ever growing software industry. Exceptions handling empowers the developers to keep control of the applications and assist users in a better way to continue using the application without any interruption. You will get an idea about what is new and what has been enhanced or fixed with this revision of Aspose.Cells for .NET
.

 

Get Pivot Table refresh date and refresh by who information

Pivot tables are very common reports which are present in the workbooks. These reports are updated time to time and it is important to know the last time when report was updated for better decision making. Aspose.Cells has provided this feature by introducing property RefreshDate. Similarly name of the person who updated the pivot table is also provided as property RefreshedByWho

For a working example refer to the following article:

Update smart art text

Smart art is used for better representation of information however earlier the text in the smart art shapes was fixed. This limitation is gone as now smart art text can be updated. For this purpose Shape.Text can be used which sets new text in the smart art shape.

For a working example refer to the following article:

Data validation for huge numbers

Data validation is done in variety of ways to control the input in the Excel file. Like limit can be defined for a cell within which some number can be entered, otherwise error message is raised. Issues were faced for validation of large numbers like 12345678901 etc. in the past but now this much larger numbers are supported by Aspose.Cells.

For a working example along with a template file refer to the following article:

Detect circular references for formulas

Using Aspose.Cells, circular references can be detected when the formula is calculated because the references of one formula commonly depend on the calculated results of other parts or other formulas. So we provide new APIs for this requirement (to gather cells with circular references) in the process of formula calculations. AbstractCalculationMonitor.OnCircular(IEnumerator circularCellsData) will be invoked by formula calculation engine when encounter circular references, the element in the enumerator is CalculationCell objects which represent all cells in one circle. The returned value denotes whether the formula engine needs to calculate those cells in circular after this call.

For a working example along with a template file refer to the following article:

Convert worksheets to SVG

SVG stands for Scalable Vector Graphics. SVG is a specification based on XML standards for two-dimensional vector graphics. It is an open standard that has been under development by the World Wide Web Consortium (W3C) since 1999. Aspose.Cells for .NET supports to convert worksheets to SVG image since version 7.1.0. The conversion is enhanced in a way that now it renders the workbook to SVG with an active sheet in tact.

For a working example, refer to the following article:

Other Enhancements and Fixes

There are some other enhancements included and a few exceptions handled in the new release for the users. A few of the worth mentioning features and other improvements are as follows:

  • Text position changes a bit on ungrouping the shape
  • Handled ArgumentException while working with generated HTML file
  • Handled an exception while calling AutoFitColumns operation
  • Handled CellsException during save when ParsingFormulaOnOpen is set to false

In Aspose.Cells 18.11, we fixed several important bugs and other issues. For example, issues around reading/writing MS Excel file formats, reading/writing HTML files, applying data validation, applying auto-fit rows/columns, formatting cells, manipulating smart art shapes, manipulating named ranges, refreshing and calculating pivot tables, rendering and manipulating charts and shapes, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved in the release. The Aspose.Cells formula calculation engine is further enhanced too.

Changes to the Public API

The following is a list of any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for .NET:

  • Adds PivotTable.RefreshedByWho property, gets the name of the user who refreshed the PivotTable last time.
  • Adds PivotTable.RefreshDate property, gets the date when the PivotTable was refreshed last time.
  • Adds CalculationData.CellRow/CellColumn properties, provides efficient way for user to get cell’s row and column indices instead of fetching the Cell object.
  • Adds CalculationCell class, represents the calculation data about one cell being calculated.
  • Adds AbstractCalculationMonitor.OnCircular(IEnumerator circularCellsData) method, provides method for user to gather and process circular references.
  • Adds TxtLoadOptions.TreatConsecutiveDelimitersAsOne property, allows user to choose whether consecutive delimiters should be taken as one when importing CSV file.
  • Adds FormatCondition.SetFormulas(string formula1, string formula2, bool isR1C1, bool isLocal) method, provides efficient and convenient way for user to set formulas for FormatCondition.
  • Adds Validation.GetListValue(int row, int column) method, allows user to get the value to produce the list for the Validation of specific cell.
  • Obsoletes ValidationCollection.Add(Validation validation) method, use ValidationCollection.Add(CellArea) method instead.
  • Adds Validation.Copy(Aspose.Cells.Validation,Aspose.Cells.CopyOptions ) method, copies validation.

Aspose.Cells for .NET Resources

The resources, you may need to accomplish your tasks: