Group Complex Data with Smart Markers & Access Encrypted Files Properties

G

What’s new in this release?

The long awaited version of Aspose.Cells for .NET 7.0.2 has been released. It includes several enhancements and fixed number of user issues/bugs. Moreover, some unnecessary older obsolete methods for Sheet-to-Image feature are removed now. It includes support for getting the document properties for an encrypted XLS file without even knowing its password. We have made enhancements for Smart Markers feature, now you may group data in some complex scenarios where you also need to place dynamic rows for Sub-Totals, Totals and Grand Totals in between the sections of data. The GridDesktop control provided by Aspose.Cells for .NET now supports shapes while loading Excel files. This release includes few new and plenty of enhanced features as listed below

  • Access document properties of an encrypted XLS file
  • The Worksheet’s TabColor property for Chart type worksheets
  • Export data without XLS limitation to SpreadsheetML file
  • Smart Markers – How to group Rows (Calculate Totals, Sub-Totals and Grand Totals)
  • Problems resolved Excel-to-PDF conversion
  • Issues resolved  with Chart Image regarding Data labels and Error bars
  • Wrap Issue resolved when converting XLS-to-PDF
  • Now can change line style of a ChartPoint
  • Formulas using intersected ranges now properly working
  • Image problems solved when saving to XLS format
  • Successful Loading and Updating XLSM then Saving
  • Problems resolved for Excel 2010 and XLSM
  • Issue resolved with AutoFitRow and the AutoFitMergedCells
  • Refresh Pivot table   now sort properly
  • AutoFitRows  work fine
  • SheetRender exports inconsistent spacing is fixed
  • There are too much formats in the worksheet
  • Copying range with validation
  • GridDesktop issues resolved while loading an Excel document
  • Rendering of document via GridDesktop.ImportExcelFile method is corrected 

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.

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

Contact Information

Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Aspose – Your File Format Experts
[email protected]

Phone: 888.277.6734
Fax: 866.810.9465

About the author

By sherazam