Protect Excel VBA Project & Apply DBNum Custom Pattern Formatting inside .NET Apps

LANE COVE, Australia - May 9, 2017 - PRLog -- What is new in this release?

We are pleased to announce the new release of Aspose.Cells for .NET 17.4.0. Protect VBA Project of Excel Workbook and Lock it for Viewing, Specify Sort Warning While Sorting Data and Apply DBNum Custom Pattern Formatting in .NET.  The new release includes some valuable features and other enhancements with critical bug fixes. We have added certain features regarding VBA project's protection for the users. There is also an enhancement for data sorting and custom pattern formatting. Aspose.Cells now supports the feature of protecting the VBA (Visual Basic for Applications) Project of Excel Workbook and locking it for viewing. Besides, users can also find if an existing VBA project is already protected and locked for viewing. The code snippet demonstrates how to protect an Excel Workbook VBA Project dynamically using Aspose.Cells and lock it for viewing. Aspose.Cells already supports Data Sorting, however earlier users could not sort a textual data as numerical data. For this purpose, Aspose.Cells implemented the DataSorter.SortAsNumber property. Whenever users sort textual data that looks like a number, MS-Excel shows this warning. DataSorter.SortAsNumber property implements this MS-Excel warning. It supports the DBNum custom pattern formatting. For example, if a cell value is 123 and users specify its custom formatting as [DBNum2][$-804]General then it will be displayed like 壹佰贰拾叁. Developers can specify custom formatting of a cell using Cell.GetStyle() method and Style.Custom attribute. Aspose.Cells for .NET 17.4.0 has enhanced its core for more stability as well as fixed many critical bugs. Moreover, there are numerous minor enhancements in order to improve the overall usage of the API.A few of the worth mentioning enhancements includes, such as Set Column Header ToolTip, sparklines disappear after re-saving and rendering to PDF, Formatting error inside shapes texts when Excel is converted to PDF, VbaProject.Sign causes an exception and Re-adding a picture to the same XLS throws a Null Reference error. Furthermore, in this release, we have fixed several other issues, such as issues around reading/writing MS Excel file formats, manipulating Pivot Tables, applying formatting to cells, manipulating Ole Objects and shapes, rendering and manipulating charts, rendering HTML to Excel and vice versa, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. The formula calculation engine is enhanced too in the new release. This release includes several enhanced features and bug fixes as listed below

·         Support "Lock project for viewing" Protection option in VbaProject Properties

·         Password protect the VBA project

·         Implement Sort Warning feature - Sort anything that looks like a number

·         Function SetColumnHeaderToolTip(int colIndex, string toolTip) missing in newer APIs set - Aspose.Cells.GridWeb

·         Change filter list to multiple checkbox selection list for GridWeb

·         PivotTable Grouping and Pivot Report Filter selection disappear when loading in GridWeb

·         Sparklines disappear after rendering to PDF

·         Sparklines disappear after re-saving the file

·         OutOfMemoryException while saving CSV to PDF

·         Format tag in the SpreadsheetML content keeps hanging on loading

·         Remove some calls to string.ToUpper() method (if possible) in the source code

·         Some shapes are separated/distorted and dim in the rendered PDF file

·         Removing worksheet causes to save a corrupt XLSM

·         Saving worksheet as HTML with overflowed text in cells

·         Some text is overlapping or invisible and vertical alignment is not right in Excel to HTML rendering

·         When HTML is saved as XLSX, text layout is different

·         When HTML is saved as XLSX, text format is changed

·         When HTML is saved as XLSX, part of content is missing

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.

 -  Password Protect the VBA Project of Excel Workbook: https://docs.aspose.com/display/cellsnet/Password+Protect+the+VBA+Project+of+Excel+Workbook

 - Specifying Sort Warning While Sorting Data: https://docs.aspose.com/display/cellsnet/Specifying+Sort+Warning+While+Sorting+Data

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

- 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