Filter Data in Worksheet using AutoFilter API & Calculate All Formula in Cloud Apps

What’s new in this release?

Aspose team is pleased to announce the new release of Aspose.Cells for Cloud 17.6.0. This new release comes up with a couple of new features and enhancements. Developers can filter data in a worksheet by using an AutoFilter API and calculate all formulas in a workbook using CalculateFormula API. By filtering information in a worksheet, users can find values quickly. Users can filter on one or more columns of data. AutoFilter API allows users to filter data by Cell Value, Cell Color or by Icon. Experiment with filters on text and numeric data by trying the many built-in test conditions, such as Equals, Does Not Equal, Contains, Greater Than, and Less Than or create a custom filter that uses multiple criteria. CalculateFormula API allows users to calculate all formulas in a workbook. Formula calculation engine is embedded in Aspose.Cells. It can not only re-calculate the formula imported from the designer file but also supports to calculate the results of formulas added at runtime. The list of new and enhanced features added in this release are given below

• Filter data by using an AutoFilter API.
• New resource parameters are added in Calculate Formula API.
• Support Microsoft Excel 2007 themes and colors.
• An enhancement is made for Convert feature.
• Import Data API now supports both Cloud file and Request file.

Start a free trial today – all users need is to sign up with the Aspose for Cloud service. Once users have signed up, users are ready to try the powerful file processing features offered by Aspose for Cloud.

Overview: Aspose for Cloud

Aspose for Cloud is a cloud-based document generation, conversion and automation platform for developers that offer a unique suite of APIs to work with Word documents, Excel spreadsheets, PowerPoint presentations, PDFs, and email formats and protocols. It supports all features for file processing, document scanning, barcodes creation and recognition, and allows extracting text or images too. Users can also work with SaaSpose APIs using REST SDKs that can be called from .NET, Java, PHP and Ruby etc.

More about Aspose for Cloud

- Learn More about Aspose.Cells for Cloud: http://www.aspose.com/products/cells/cloud

- Download Aspose.Cells for Cloud: http://www.aspose.com/downloads/cells/cloud

- Aspose.Cells for Cloud Documentation: http://www.aspose.com/docs/display/cellscloud/Home

Aspose Pty Ltd was founded in March 2002 in Sydney, Australia. The corporate portal was firstly launched in October 2002. Aspose strives to provide the richest component choices for global .NET programmers. Thousands of organizations from tens of countries have acquired Aspose products, including Microsoft, IBM, PricewaterhouseCoopers, Ernst & Young, DuPont, Hilton Hotels, Reader's Digest, Bank of America, Boeing, Siemens, etc.

Aspose Pty Ltd, Suite 163,
79 Longueville Road
Lane Cove, NSW, 2066
Australia
Phone: 888.277.6734
Fax: 866.810.9465

This release was published on openPR.