Create/Protect Shared Workbook, Determine Smart Art Shape & Convert It to Group Shape using .NET

What is new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for .NET 17.11.0. Smart Art shapes are special shapes that allow users create complex diagrams automatically. Aspose.Cells allows users to detect Smart Art shapes and convert them to Group shape. Users can find if the shape is smart art shape or normal shape using Shape.IsSmartArt property. Users can also convert Smart Art Shape into Group Shape using the Shape.GetResultOfSmartArt() method. It will enable users to handle smart art shape like a group shape. Consequently, users will have access to the individual parts or shapes of the group shape. The sample code on blog announcement page loads a template file containing a smart art shape. It then converts the determine the smart art shape and convert into group shape. Microsoft Excel allows users to create a shared workbook. When users share the workbook, then more than one user can edit the workbook. Aspose.Cells enables users to create a shared workbook with Workbook.Settings.Shared property. Users can protect or unprotect a shared workbook.Aspose.Cells allows users to find the root element name of XML map using XmlMap.RootElementName property. Users can ignore all errors during the conversion process using the PdfSaveOptions.IgnoreError property. This way, conversion process will be completed smoothly without throwing any error or exception but data loss may occur.Users can query cell areas mapped to xml map path with Aspose.Cells using the Worksheet.XmlMapQuery() method. If the path exists, it will return the list of cell areas related to that path inside xml map. Aspose.Cells allows users to render sequence of pages of an Excel file to images using ImageOrPrintOptions.PageIndex and ImageOrPrintOptions.PageCount properties. These properties are useful when there are so many pages in a worksheet but users need to render a few pages only. This will not only save the processing time but also saves the memory consumption of the rendering process. There are some other enhancements included and other exception handled in the new release for the users, such as Copy Paste Behavior Of EnableClipboardCopyPaste and PasteType GridDesktop Properties, Handled exception when using PivotTable.RefreshData, Handled System.ArgumentOutOfRangeException when XLSB is converted to PDF and Handled exception while loading the output XLS file (with OLE Objects, images, etc. excluded). This release includes several enhanced features and bug fixes as listed below

• XmlMapQuery like functionality needed as available in MS Excel
• Associated property needed for XMLMaps to get the RootElementName for the map
• Scale becomes smaller - Fonts issue
• Protect shared workbook - Set or change password
• Support PasteType for Aspose.Cells.GridDesktop during Copy/Paste actions
• Unable to get Text of Smart Art shapes
• Pivot table is taking too long to refresh data
• Direction of shape is wrong when converted to image format
• Star shapes are not shown correctly in the output PDF
• Characters overlap when converting to image
• Some drawing elements are inverted while others are shifted to the right
• Position of the line objects changed while rendering the spreadsheet to PDF
• PivotTable options - Show the values row - gets enabled on re-saving
• Missing total values for the calculated fields when refreshing/calculating PivotTable data
• Error of expanding data to proper columns when saving an MHTML file format to Excel file
• LightCellsDataProvider is removing leading and trailing spaces
• Formula calculation resolves formula unexpectedly to error
• Saving Excel as PDF decreases column width
• Legend of the chart is missing in the output PDF
• Number formatting in chart is lost after saving an Excel file as PDF
• PDF file created by Aspose.Cells causes error in Adobe Acrobat Reader
• Chart to image or PDF - 3D Line Chart is not correct or rotated
• Validation is not correctly copied from one worksheet to another
• Style.QuotePrefix property does not work for XLSB file format
• Specific Excel workbook becomes hidden after opening and saving
• Columns were expanded unexpectedly in the merged workbook
• HTML string having multiple fonts corrupts the output Excel file
• SpreadsheetML file when re-saved via Aspose.Cells contains additional protection settings applied
• AutoFitColumns breaks HTML formatting in the output Excel file
• MS Excel prompts an error message when opening the output file
• Textbox font is changed after ungrouping shape(s)
• The row height becomes too big after autofitting rows
• Issue with CellColor when using the context menu to change

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. 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/products/cells/net

- 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

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.