Work With XML Maps, Enhanced Protection Module & Digital Signatures for VBA Projects Using .NET

It enhanced PDF rendering engine in order to reduce the resultant PDF file size and adds support for exporting VBA certificate to file or stream. It Detect if Worksheet is Password Protected and Verify Password Used to Protect the Worksheet. It has provided support to identify & parse the formulas while loading CSV/TXT files having delimited plain data. This release has added support for importing XML map inside an instance of Workbook and Enhanced the PDF rending engine.

This article explains the new and enhanced features along with important bug fixes included in Aspose.Cells for .NET 8.7.0. It contains some useful features and other enhancements along with critical bug fixes. Aspose.Cells APIs have provided an enhancement for the PDF rendering engine in order to reduce the resultant PDF file size. It has exposed the PdfSaveOptions.OptimizationType property along with an enumeration by the name PdfOptimizationType in order to facilitate the application developers to control the resultant PDF file size to certain extent.  It has also exposed the Boolean type property in order to mimic the Excel’s feature of re-sizing data label shapes to fit the text. Please note, Excel application provides the Resize shape to fit text option for chart’s data labels to increase the size of the shape so that the text fits inside of it. This option can be accessed on Excel interface by selecting any of the data labels on the chart. Right click and select Format DataLabels menu. On Size & Properties tab, expand Alignment node to reveal the related properties including the Resize shape to fix text option as highlighted below. Aspose.Cells APIs have enhanced the Protection class by introducing some useful properties & methods. Two of the most worth mentioning enhancements includes Detect if Worksheet is Password Protected and Verify Password Used to Protect the Worksheet.  Aspose.Cells for .NET has provided support to identify & parse the formulas while loading CSV/TXT files having delimited plain data. Newly exposed property when set to true directs the API to parse the formulas from the input delimited file and set them to relevant cells without requiring any additional processing. This release of the API has exposed the ColorScale.Is3ColorScale property that can be used to create 2-Color Scale conditional format. The said property is of type boolean with default value of true which means that the conditional format will be of 3-Color Scale by default. However, switching the ColorScale.Is3ColorScale property to false will generate a 2-Color Scale conditional format. The most notable enhancements in this includes, Newly exposed field VbaProject.IsSigned allows to detect if a given VbaProject is digitally signed or not, newly exposed attribute VbaProject.CertRawData allows to export VBA Digital Certificate to streams, newly exposed attribute VbaProject.IsValidSigned allows to determine if the signature is valid, newly exposed method VbaProject.Sign() allows to digitally sign VBA code project and added support for importing XML map inside an instance of Workbook. This release includes several enhanced features and bug fixes as listed below

•    Support exporting VBA certificate to file or stream
•    Support an API to check if VBAcode is signed
•    Digitally sign VBA projects/macros
•    Ability to work with XML Maps
•    Support XML Mapping Import functionality as it is done from Excel Developer tab
•    VBA digital sign is lost during conversion (XLSM to XLS)
•    VBA Project loses digital signature when saving xls as xlsm file format
•    Validation.Value1 array order is different to what is shown in Excel
•     Unable to create 2-Color Scale conditional formatting
•    Support ISOWEEKNUM MS Excel 2013 function
•    VBA digital sign is lost during conversion (XLSB to XLSM)
•    Incomplete HTML structure when saving to a stream
•    Refreshing pivot table generates corrupt excel file
•    Workbook.Copy does not preserve formatting for pivot tables
•    Different values for the same cell before and after calling CalculateFormula() method
•    Excel file is not properly (fully) calculated (regarding Charts) prior to PDF generation
•    (Cell shading overlaps the border causing the border thinning
•    Excel shows one page in print preview where Aspose.Cells render to PDF pages
•    Images in the sheets are not rendered the same as per the original template Excel file
•    Cell Area is overlapping the Cell Border while converting spreadsheet to PDF
•    CopyData between ranges does not work horizontally but it works fine vertically
•    XLSB to XLSM does not work properly and produces corrupted file
•    OleObjects get removed after conversion from XLSB to XLSM
•    Conditional Formatting results are not rendering properly in PDF
•    Adding custom properties removes the worksheet contents
•    Chart primary category axis gets wrong on resaving the source excel file
•    Horizontal axis was changed to different labels than the initial file
•    Custom chart's primary x-axis changed after opening and resaving the template XLSX file
•    Extracting the image from Worksheet and inserting it in Document file renders it incomplete
•    JavaScript is not being triggered while deleting contents from GridWeb cell
•    (Header row text also appears inside the Filter values

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/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

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


Categories: Computer Software, Programming, Computer

Tags: .NET Excel Component, Digital Signatures for VBA Projects, Digitally sign VBA macros, exporting VBA certificate, load Delimited File Containing Formulas, Optimize PDF File Size, work with XML Maps


About Aspose Pty Ltd

View Website

Sher Azam
Aspose Pty Ltd

888.277.6734
Aspose Pty Ltd
Suite 119, 272 Victoria Avenue Chatswood,
NSW, 2067 Australia
2067
Australia