Update smart art text and evaluate large numbers validation with Aspose.Cells for Java 18.11

Share on FacebookTweet about this on TwitterShare on LinkedIn

We are pleased to announce the release of new updated version Aspose.Cells for Java v18.11. It contains enhancements and bugs resolution for many of the issues. Whenever some enhancement or new feature is requested, effort is made to provide more and more additional features to help the common users. New properties, methods and classes are added to support these features along with special focus on achieving maximum possible performance. Comparisons are done with other products and features are added to keep our product in leading role. Complete attention is paid to each and every requirement of the user and future requests are also perceived based on existing requests or issues faced by user. Daily use features are introduced like getting date/time when a pivot table report was updated last time or the user name who updated this report for audit purpose or generic use. 

Detailed overview of all the enhancements, bugs and changes in the APIs are documented and shared with the user as Release notes. This document can be used as reference to keep track of all the changes which are made in the current and previous versions. 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. Last section on this page contains more details and links about this product. Aspose for Java APIs can be directly installed from Maven repository for which check document.

Pivot table refresh date/time and Refreshed by who

Pivot tables are very common reports which are present in the workbooks. These reports are updated time by 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 now as now smart art text can be updated. For this purpose shape.setText() function is introduced 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 large numbers are supported by Aspose.Cells.

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

Rendering Active Worksheet in a Workbook to SVG

Aspose.Cells has introduced rendering active worksheet in a workbook to SVG. For this purpose load an Excel file into workbook object and set the active sheet index like for Sheet2, set index to 1. Then save the Workbook as SVG which will render active worksheet to SVG:

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:

  • Wrong count of validation values is read from XLSX
  • Issue while treating consecutive delimiters as distinct
  • Date format is incorrect for Japanese locale
  • Aspose.Cells.GridWeb (Java) crashes when using it concurrently in a multi user environment
  • Resolving issues in getting actual chart size

In Aspose.Cells 18.11, we fixed several important bugs and other issues. For example, not copying the smart art while copying the workbook, detecting the circular reference in a workbook and treating consecutive delimiters as one similar to Excel.

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 Java:

  • 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 Java Resources

The resources, you may need to accomplish your tasks: