Excel Advanced Conditional Formatting Types, Data Filter in Pivot Table


Well-known member
Mar 10, 2010
Programming Experience
What is new in this release?

The long awaited version of Aspose.Cells for .NET 7.3.1 has been released. In this release, we have made some valuable enhancements to the advanced conditional formatting types of Microsoft Excel 2007/2010 file formats that were not supported in the product. Moreover, Microsoft Excel 2010′s advanced data validation is now supported. We have also supported data filters in Pivot Tables. We have made several enhancements regarding data series and markers for charts. The auto-shapes rendering in output HTML has also been enhanced. As well as all this, we have fixed a number of bugs and handled exceptions regarding Excel to PDF feature in the latest release. The formula calculation engine is further improved and we enhanced it to make it more robust and efficient. We have also fixed a few issues regarding certain formulas. A few issues in the web based grid control provided by Aspose.Cells for .NET that affected grouping data and formatting are now fixed. We also fixed an issue regarding other browsers, for example Firefox. This release includes few enhanced features and plenty of bug fixes as listed below

- Conditional formatting - Include DataBar type’s missing fields
- Conditional formatting - Include IconSet type’s missing values
- Conditional formatting - Support - FormatConditionValueType.AutomaticMin/AutomaticMax
- Read conditional formatting rules with cross-sheet formulas
- Support Cells.MinDataColumn and Cells.MinDataRow properties
- Support Cell Background Colors with Conditional Formatting (MS Excel 2010)
- Data Filters of the PivotTable are supported
Advanced data validation of MS Excel 2010 is supported
- Throws CellsException when changing the part of the array formula
- Marker types and styles in the charts of Excel 2007/2010
- Custom Marker shapes in the chart
- How to create custom Markers
- Sub-Charts are not accessible
- AutoShapes in HTML Output
- DataBars - Conditional formatting in PivotTable
- Losing web queries in MS Excel 2007 formats
- Manage external data ranges and their properties
- MS Excel’s XLSB file size Issue is resolved.
- Image’s color mode formatting is now kept when saving an Excel file
- MS Excel 2003 Worksheet’s Custom Properties corrupted is fixed
- BUG is fixed in calculating Formulas
- Opening and saving a file with conditional formatting
- Bold style is can be seen on ListObject’s header cell
- Series markers issue is resolved
- Quotes in the saved Tab Delimited file is fixed
- CSV read/write does not 'round trip' for some inputs is now fixed
- StringValue returns a wrong value is now fixed
- Issues with CELL function is fixed
- COUNTIFS formula does not evaluate correct value is now fixed
- OFFSET function calculation issues is fixed
- MODE function calculation issues are resolved
- VLOOKUP function’s bug is fixed
- TRIM function calculation issues are resolved
- Save as HTML shows hidden column in the output is fixed
- Saving clears formatting is resolved
- Graphics in HTML output is now fixed
- HTML formatting issues (regarding extra borders) is fixed
- SheetRender’s XPS and custom number format issue is resolved
- Save as PDF does not preserve formatting is now fixed
- Problems are resolved with XLSX formatting in Excel and PDF outputs
- Excel’s pivot table rendered to PDF is corrected
- Custom fonts in PDF
- Cell’s Vertical Alignment rendering issue is fixed
- Text missing in the right-most end is now resolved
- Some conditional formatting is now rendered correctly
- Problem with formatting in the Total Row in the PivotTable
- Problem is resolved with formatting in the Total Row in the PivotTable
- Office for Mac-Os 2k11 crashes after opening an Excel file is now fixed
- PivotTable’s calculated field getting changed is now fixed
- Problem is fixed for saving Workbook with Calculated Members
- Compact Layout for pivot table is fixed
- File Corruption is fixed when Refreshing Pivot Tables
- SheetRender draws textbox contents bold
- Excel text box is now resized correctly when rendering to image
- SheetRender exports shape correctly

Other most recent bug fixes are also included in this release.

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for .NET documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Conditional Formatting
- Supported Formula Functions

Overview: Aspose.Cells for .NET

Aspose.Cells is a .NET component for spreadsheet reporting without using Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, spreadsheet formatting, drawing objects like images, OLE objects and importing or creating charts. You can also create Excel file using designer spreadsheet, smart marker or API and apply formulae and functions. It supports CSV, SpreadsheetML, PDF and all file formats from Excel 97 to Excel 2007.

More about Aspose.Cells for .NET

- Homepage of Aspose.Cells for .NET
- Product Overview of Aspose.Cells for .NET
- Download Aspose.Cells for .NET
- Online documentation of Aspose.Cells for .NET
- Demos of Aspose.Cells for .NET
- Post your technical questions/queries to Aspose.Cells for .NET Forum
- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for .NET blog

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Aspose - Your File Format Experts
Phone: 888.277.6734
Fax: 866.810.9465
Top Bottom