What’s 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
Newly added documentation pages and articles
Some new tips and articles have now been added into Aspose.Cells for .NET documentation that may guide users 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
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
Newly added documentation pages and articles
Some new tips and articles have now been added into Aspose.Cells for .NET documentation that may guide users 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
- Homepage of Aspose.Cells for .NET C#
- Download Aspose.Cells for .NET
- Online documentation of Aspose.Cells for .NET
No comments:
Post a Comment