Remove Unused Styles from Workbook Style Pool & Directly Render Chart to PDF using .NET

2024-10-29 10:35:43 Computer

747

We are pleased to announce the new release of Aspose.Cells for .NET 8.6.2. This release contains many useful features and other enhancements along with critical bug fixes. Smart Markers are one of the advanced features offered by Aspose.Cells APIs to dynamically merge data with the help of specialized markers defined in a designer spreadsheet. Such spreadsheets can be considered as templates as they contain the formatting as well as the formulas along with the markers but no contents, where the data gets populated at runtime based on the marker definition and associated data source. Aspose.Cells APIs have provided the specialized WorkbookDesigner class that is used to load the designer spreadsheets and process them against the particular source to populate the data. Recently we received requests in Aspose.Cells support forum to provide call back facility for the WorkbookDesigner class so that the process could emit notifications about the cell and/or smart marker being processed. With the release, the API has exposed the ISmartMarkerCallBack interface along with the WorkbookDesigner.CallBack property to fulfill this requirement. The current implementation of the interface allows capturing the references of worksheet, cell & smart marker being processed. It has introduced the Chart.ToPdf method in order to simplify the task of rendering charts in PDF format. Previous solution was to copy the required chart onto a new Worksheet then render the worksheet to PDF while specifying the area containing the chart shape. This solution was prone to error due to the number of statements to accomplish the same goal that can now be achieved in a single statement. The Chart.ToPdf method currently accepts a parameter of type string as file path location to store the resultant PDF directly onto the disk. It is fairly possible that a spreadsheet may contain styles that are not in use. Such scenario may easily occur when user copies cells from another workbook because in this case some styles are copied too. Due to the reason that styles are shared for many objects such as cells, rows, columns and so on, when one cell?s content (including style) is replaced by the copied one, the Aspose.Cells APIs do not remove the old style from the style pool. Imagine if the user does the copy operation repeatedly, there will be more and more styles in the style pool. Such unused styles can now be removed from the object of the Workbook while using the newly exposed RemoveUnusedStyles method. However, the aforementioned method could impose performance plenty because it has to check all objects to make sure that one style is not being used by any object, so we recommend to use this method with great caution. The most notable enhancements in this release includes, exposed Cells.Style property that can be used to get/set the default style for a particular Worksheet, exposed two new events for the Aspose.Cells.GridWeb component, namely, AjaxCallFinished & CellModifiedOnAjax and provided support for generic List as nested objects in Smart Markers. In this release, several important issues have been addressed. For example, issues around reading/ writing Microsoft Excel file formats, manipulating Pivot Tables, applying conditional formatting, rendering to HTML file format, formatting rows and columns, manipulating OLE Objects in the template files, setting data validation, manipulating and rendering shapes, applying Page Setup options, rendering images from Excel worksheets, manipulating charts, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. We have further improved the Aspose.Cells formula calculation engine and fixed some issues in this regard. This release includes several enhanced features and bug fixes as listed below

? Assign macro to form controls
? Worksheet.Shapes.UpdateSelectedValue throwing CellsException sometimes
? Including a Font Directory with CellsHelper, doesn't seem to work
? Hyperlink.TextToDisplay is not updated
? XLSX document size increases with every save
? Aspose.Cells is not able to run in the Medium Trust
? Wingdings symbols do not render correctly while converting certain spreadsheet to HTML
? Excel always repairs the resultant spreadsheet after adding the PivotTable
? HTML to Excel - CSS Styling Ignored
? Chart changes in resultant spreadsheet after refreshing the Chart
? Workbook.CalculateFormula never returns
? Aspose.Cells Row Insertion Error
? characters overlapped and converted to ######## in Excel to PDF rendering
? Superscript and subscript shifted up too much when generating image
? Chart Axis labels are rendered in jagged text
? WordArt Boxes are balcked out when XLSX is converted to PDF
? SmartArt boxes are coming as black.
? SmartArt layout heading is overlapping with underline under Picture heading.
? Text is being truncated/wrapped in the generated PDF
? Spreadsheet document produces multiple documents when converted
? OLE link ObjectSourceFullName could not be updated
? PageSetup.Zoom has changed after opening and saving the workbook
? Some cell formulas are lost when row is copied
? Double read of Carriage Return Line Feeds
? Combining two XLSM workbooks produces a corrupted workbook
? Images in the spreadsheet do not render while converting to PDF
? Linked Picture is not inside the chart after instantiating the Workbook object and saving it
? Range.CopyData works but Range.Copy is not working
? Adding more than 2084 characters in hyperlink corrupts the output xlsx file
? Excel function renders with #NAME? error on Sheet 1
? Gridweb Print on Chrome does not work 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.

- Converting Chart to PDF: http://www.aspose.com/docs/display/cellsnet/Converting+Chart+to+PDF

- Remove Unused Styles inside the Workbook: http://www.aspose.com/docs/display/cellsnet/Remove+Unused+Styles+inside+the+Workbook

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, XLS, SpreadsheetML, OOXML, XLSB, CSV, HTML, ODS, PDF, XPS and all file formats from Excel 97 to Excel 2007. You 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/community/files/51/.net-components/aspose.cells-for-.net/default.aspx

- Online documentation of Aspose.Cells for .NET: http://docs.aspose.com/display/cellsnet/Home

- Demos of Aspose.Cells for .NET: http://www.aspose.com/demos/.net-components/aspose.cells/default.aspx

- Post your technical questions/queries to Aspose.Cells for .NET Forum:
http://www.aspose.com/community/forums/aspose.cells-product-family/19/showforum.aspx

- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for .NET blog: http://www.aspose.com/community/blogs/aspose.cells-product-family/default.aspx

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