openPR Logo
Press release

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

12-13-2017 05:44 PM CET | IT, New Media & Software

Press release from: Aspose

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.

Permanent link to this press release:

Copy
Please set a link in the press area of your homepage to this press release on openPR. openPR disclaims liability for any content contained in this release.

You can edit or delete your press release Create/Protect Shared Workbook, Determine Smart Art Shape & Convert It to Group Shape using .NET here

News-ID: 855749 • Views:

More Releases from Aspose

Read/Write Projects Created using MS Office 365 Project Online Service using .NE …
What's New in this Release? Aspose team is pleased to announce the new release of Aspose.Tasks for .NET 19.2. This release includes support for Microsoft Project Online, MPP files saved with Microsoft Office 365 cloud are supported now. Also fixes few issues reported with the API that further enhance the stability of the API. Aspose.Tasks for .NET API now supports Microsoft Office 365 Project Online Services. Now the users shall
aspose.cloud Newsletter February 2019: Work with Cloud File Format REST APIs & S …
Aspose.Cloud Newsletter for February 2019 has now been published that highlights all the newly supported features offered in the recent releases. It also includes information about Cloud REST API and SDKs for working with Microsoft Visio Diagrams, Reordering multiple PowerPoint slides in one Cloud REST API call, Convert HTML to Markdown and MHTML formats in cloud applications and much more. Cloud REST API and SDKs for working with Microsoft Visio Diagrams Manipulate
Aspose.Newsletter February 2019: Enhance Productivity using JDK 11 Compatible PD …
Aspose Newsletter for February 2019 has now been published that highlights all the newly supported features offered in the recent releases. It includes information about Enhancing productivity & performance using JDK 11 compatible PDF API, Loading Excel workbook efficiently without loading VBA project, Use latest version of Aspose.PDF for C++ with new codebase changes, Create PST folder hierarchy with string notation, Detect archive-based file format and work with AMF files
Load any HTML with Self-Closing Tags & Convert It to Excel File inside Android A …
What’s new in this release? Aspose development team is pleased to announce the new release of Aspose.Cells for Android via Java 18.12. Depiction of data through HTML page is very common, however this page can be opened in variety of devices including mobiles, tabs and other hand held devices which contain small screens. The size of the columns is defined in “pt” which works in many cases. However there can be

All 4 Releases


More Releases for Cells

Stem Cells Market: Development of Infrastructure to Drive Global Stem Cells Mark …
In the global stem cells market a sizeable proportion of companies are trying to garner investments from organizations based overseas. This is one of the strategies leveraged by them to grow their market share. Further, they are also forging partnerships with pharmaceutical organizations to up revenues. Read Report Overview - https://www.transparencymarketresearch.com/stem-cells-market.html In addition, companies in the global stem cells market are pouring money into expansion through multidisciplinary and multi-sector collaboration for large
Competent Cells Market Report 2018: Segmentation by Type (Cloned Competent Cells …
Global Competent Cells market research report provides company profile for Thermo Fisher Scientific, Inc., Agilent Technologies, Inc., Bio-Rad Laboratories, Inc., Merck & Company, Inc., Illumina, Inc., Promega Corporation, New England Biolabs, OriGene Technologies, Inc., Zymo Research Corporation, Scarab Genomics, LLC, Meridian Bioscience, Inc. and Others. This market study includes data about consumer perspective, comprehensive analysis, statistics, market share, company performances (Stocks), historical analysis 2012 to 2017, market forecast 2018 to
Fuel Cell Interconnectors Market By Product Type Ceramic based, Metal based; By …
Global Fuel Cell Interconnectors Market Introduction A fuel cell is a battery that generates electricity through an electrochemical reaction where the fuel cell interconnector is a layer made up of either ceramic or metallic material, which combines the electricity generated by each individual cell. Fuel cell interconnectors are placed between each individual cell to connect the cells in the series. Ceramic fuel cell interconnectors are more suitable for high-temperature working conditions
Circulating Tumor Cells and Cancer Stem Cells Market Current Overview by 2025
The tumor cells which have shed into lymphatic system and circulated over the body through blood circulation are called as circulating tumor cells. Circulating tumor cells may comprise seeds for metastasis. Stem cells are the type of cells that can differentiate into specialized cells and have the capacity of self-renewal. Cancer stem cells are the cancer cells that possess the characteristics of normal stem cells. Cancer stem cells are said
Fuel Cells Sales In Global Market: By Product Type - Proton Exchange Membrane Fu …
Researchmoz added Most up-to-date research on "Fuel Cells Sales In Global Market: By Product Type - Proton Exchange Membrane Fuel Cells (PEMFC), Direct Methanol Fuel Cells (DMFC) & Solid Oxide Fuel Cells (SOFC)" to its huge collection of research reports. In this report, the global Fuel Cells market is valued at USD XX million in 2016 and is expected to reach USD XX million by the end of 2022, growing at
Circulating Tumor Cells and Cancer Stem Cells Market to Develop Rapidly by 2025
The tumor cells which have shed into lymphatic system and circulated over the body through blood circulation are called as circulating tumor cells. Circulating tumor cells may comprise seeds for metastasis. Stem cells are the type of cells that can differentiate into specialized cells and have the capacity of self-renewal. Cancer stem cells are the cancer cells that possess the characteristics of normal stem cells. Cancer stem cells are said