Filter Data Type While Loading Template File & Set Shadow as Text Effect for Shapes Using Aspose.Cells for .NET 8.8.1
It supports filtering the data type while loading spreadsheet. Filtering data at the time of loading can improve the performance tremendously, especially when used with LightCells APIs. It also provides the ability to set the shadow as text effects for any shape such as TextBox. Issues around reading, writing and manipulating Microsoft Excel file formats, converting spreadsheets to HTML files and vice versa, manipulating and rendering charts and shapes are also addressed in this release.
Lane Cove, Australia, June 09, 2016 --(PR.com)-- What is new in this release?
Aspose team is pleased to announce the new release of Aspose.Cells for .NET 8.8.1. The release contains some valuable features along with critical bug fixes and other enhancements. As per default behaviour, Aspose.Cells APIs load everything from the template file into its document object model, providing access to every aspect of the spreadsheet. There could be a scenario where the user does not want to load everything but specific objects, such as charts or shapes. This can be achieved using the newly exposed enumeration and property. Aspose.Cells APIs have added the enumeration which can be used to make the selection of data type to be loaded from the template file. Filtering data at the time of loading can improve the performance tremendously, especially when used with LightCells APIs. There are several selections that a user can make in order to customize the loading process by specifying the appropriate value from LoadDataFilterOptions. Aspose.Cells APIs have already provided the facility to render charts to PDF while using the Chart.ToPdf method. With this release, the API has exposed another overloaded version of the said method that could accept an instance of Stream, allowing the users to save the chart’s PDF into streams. Aspose.Cells for .NET 8.8.1 provides the ability to set the shadow as text effects for any shape such as TextBox. The said feature has been provided by exposing the Shape.TextBody property. This property presents the settings of the shape’s text and returns FontSetting objects which in turn can be used to set the shadow via ShadowEffect.PresetType property. Aspose.Cells.GridWeb 8.8.1 has exposed the new methods to add and remove data validation from the GridCell. Please note, the Aspose.Cells.GridWeb also provides the facility to add data validation rules while using the ValidationCollection.Add method, however, this approach requires to specify the cell range on which data validation rule has to be applied. If the requirement is to specify the data validation rule for just one cell then the GridCell.CreateValidation method can be used without specifying the cell range. The most notable enhancements in this release includes, the ability to read data validations from Excel files, ability to directly calculate the custom functions without inserting the function in worksheet and ability to export DataBar, ColorScale and IconSet of conditional formatting to HTML format. It has also handled a few exceptions regarding reading/writing MS Excel files. In this release, several important issues have been addressed. For example, issues around reading, writing and manipulating Microsoft Excel file formats, converting spreadsheets to HTML files and vice versa, manipulating and rendering charts and shapes, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. This release includes several enhanced features and bug fixes as listed below:
• Setting text effect to Offset in Rectangle Shape
• Border thickness is reduced while rendering when Print Area passes through the cells sharing the border
• Make the default value of WorkbookSettings.IsDefaultEncrypted as false
• Aspose.Cells.xml is missing in the ".Binnet4.0" folder
• Optimize the code to make hidden empty columns and rows more efficient
• API hangs while converting a corrupted & infected spreadsheet to PDF
• Icons for the conditional formatting rules do not render to HTML
• Formatting is lost while importing HTML as XLSX
• ISO 8601 format dates are being treated as strings instead of dates
• Problem with large images during conversion from Excel to PDF
• Wrong row heights using AutoFitRows with AutoFitMergedCells option on for Chinese and English words in the cells
• Parenthesis not shown rotated in the output PDF (Excel to PDF conversion)
• SheetRender.ToImage not rendering cells border
• Vertical Symbols are not rendered correctly when converting spreadsheets to PDF
• Some of vertical text still cannot be shown properly in the converted PDF file
Other most recent bug fixes are also included in this release
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. Users can also create Excel file using designer spreadsheet, smart marker or API and apply formulae and functions. It supports CSV, XLS, SpreadsheetML, OOXML, XLSB, CSV, HTML, ODS, PDF, XPS and all file formats from Excel 97 to Excel 2007. Users can also view, generate, modify, convert, render and print workbooks all without using Microsoft Excel.
More about Aspose.Cells for .NET
- Homepage of Aspose.Cells for .NET: http://www.aspose.com/.net/excel-component.aspx
- Download Aspose.Cells for .NET: http://www.aspose.com/downloads/diagram/net
- Online documentation of Aspose.Cells for .NET: http://docs.aspose.com/display/cellsnet/Home
Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
http://www.aspose.com/
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465
Aspose team is pleased to announce the new release of Aspose.Cells for .NET 8.8.1. The release contains some valuable features along with critical bug fixes and other enhancements. As per default behaviour, Aspose.Cells APIs load everything from the template file into its document object model, providing access to every aspect of the spreadsheet. There could be a scenario where the user does not want to load everything but specific objects, such as charts or shapes. This can be achieved using the newly exposed enumeration and property. Aspose.Cells APIs have added the enumeration which can be used to make the selection of data type to be loaded from the template file. Filtering data at the time of loading can improve the performance tremendously, especially when used with LightCells APIs. There are several selections that a user can make in order to customize the loading process by specifying the appropriate value from LoadDataFilterOptions. Aspose.Cells APIs have already provided the facility to render charts to PDF while using the Chart.ToPdf method. With this release, the API has exposed another overloaded version of the said method that could accept an instance of Stream, allowing the users to save the chart’s PDF into streams. Aspose.Cells for .NET 8.8.1 provides the ability to set the shadow as text effects for any shape such as TextBox. The said feature has been provided by exposing the Shape.TextBody property. This property presents the settings of the shape’s text and returns FontSetting objects which in turn can be used to set the shadow via ShadowEffect.PresetType property. Aspose.Cells.GridWeb 8.8.1 has exposed the new methods to add and remove data validation from the GridCell. Please note, the Aspose.Cells.GridWeb also provides the facility to add data validation rules while using the ValidationCollection.Add method, however, this approach requires to specify the cell range on which data validation rule has to be applied. If the requirement is to specify the data validation rule for just one cell then the GridCell.CreateValidation method can be used without specifying the cell range. The most notable enhancements in this release includes, the ability to read data validations from Excel files, ability to directly calculate the custom functions without inserting the function in worksheet and ability to export DataBar, ColorScale and IconSet of conditional formatting to HTML format. It has also handled a few exceptions regarding reading/writing MS Excel files. In this release, several important issues have been addressed. For example, issues around reading, writing and manipulating Microsoft Excel file formats, converting spreadsheets to HTML files and vice versa, manipulating and rendering charts and shapes, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. This release includes several enhanced features and bug fixes as listed below:
• Setting text effect to Offset in Rectangle Shape
• Border thickness is reduced while rendering when Print Area passes through the cells sharing the border
• Make the default value of WorkbookSettings.IsDefaultEncrypted as false
• Aspose.Cells.xml is missing in the ".Binnet4.0" folder
• Optimize the code to make hidden empty columns and rows more efficient
• API hangs while converting a corrupted & infected spreadsheet to PDF
• Icons for the conditional formatting rules do not render to HTML
• Formatting is lost while importing HTML as XLSX
• ISO 8601 format dates are being treated as strings instead of dates
• Problem with large images during conversion from Excel to PDF
• Wrong row heights using AutoFitRows with AutoFitMergedCells option on for Chinese and English words in the cells
• Parenthesis not shown rotated in the output PDF (Excel to PDF conversion)
• SheetRender.ToImage not rendering cells border
• Vertical Symbols are not rendered correctly when converting spreadsheets to PDF
• Some of vertical text still cannot be shown properly in the converted PDF file
Other most recent bug fixes are also included in this release
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. Users can also create Excel file using designer spreadsheet, smart marker or API and apply formulae and functions. It supports CSV, XLS, SpreadsheetML, OOXML, XLSB, CSV, HTML, ODS, PDF, XPS and all file formats from Excel 97 to Excel 2007. Users can also view, generate, modify, convert, render and print workbooks all without using Microsoft Excel.
More about Aspose.Cells for .NET
- Homepage of Aspose.Cells for .NET: http://www.aspose.com/.net/excel-component.aspx
- Download Aspose.Cells for .NET: http://www.aspose.com/downloads/diagram/net
- Online documentation of Aspose.Cells for .NET: http://docs.aspose.com/display/cellsnet/Home
Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
http://www.aspose.com/
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465
Contact
Aspose
Sher Azam
888.277.6734
http://www.aspose.com/
Sher Azam
888.277.6734
http://www.aspose.com/
Contact
Categories