It gives us immense pleasure to announce the release of version 17.7 of Aspose.Cells Cloud API. Aspose.Cells Cloud is a platform independent REST API that allows developers to process their Excel files on Cloud. This new release comes up with a couple of new features. Developers can calculate cell’s formula using Calculate API, apply rich text formatting to a cell using characters API, sort table’s data using ListObjects API and update chart properties using charts API. Please check Release Notes for summarized information about all the changes in this release.
New Features and Enhancements
Update Chart PropertiesWe can customize the appearance of charts by setting their properties e.g. Setting the chart area, Setting chart lines, Applying themes, Setting titles to charts and axes and Working with gridlines. Please check this help topic it explains how to update properties of a chart.
Sort Table’s DataTo manage and analyze a group of related data, it is possible to turn a range of cells into a list object (also known as an Excel table). A table is a series of rows and columns that contain related data managed independently from the data in other rows and columns. By default, every column in the table has filtering enabled in the header row so that you can filter or sort your list object data quickly. Please check this help topic it shows how to sort table’s data.
Calculate Cell’s FormulaAspose.Cells has an embedded formula calculation engine. It can not only recalculate formulas imported from designer templates but also supports calculating the results of formulas added at runtime. Aspose.Cells supports most of the formulas or functions that are the part of Microsoft Excel. They can be used through the API or using designer spreadsheets. Aspose.Cells supports a huge set of mathematical, string, Boolean, date/time, statistical, database, lookup, and reference formulas. Please check this help topic it shows how to calculate cells’s formula.
Apply Rich Text Formatting to a CellApply different kinds of formatting styles on cells to set background or foreground colors, fonts, horizontal and vertical alignments, indentation level, text direction, rotation angle and much more. This help topic shows how rich text formatting can be applied to a cell.
Aspose.Cells Cloud ResourcesFollowing are the links to some useful resources you may need to accomplish your tasks.
- Aspose.Cells Cloud
- Aspose.Cells Cloud Online Documentation
- Aspose Cloud UI Help Topics
- Aspose.Cells Forum
- Live Examples
- Aspose.Cells Cloud SDKs
- Aspose Cloud Plugins
- Work with Aspose Cloud Storage using Web GUI or Aspose Cloud Service
- Work with Third Party Storages
- Work with API Usage and Logs using Web GUI or Aspose Cloud Service