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

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

Added: (Tue May 09 2017)

Pressbox (Press Release) - 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 projects 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
When loading HTML and save it as XLSX, paragraphs are missing and changed
Issue with Pivot Filters Text
Number format does not work correctly in the Pivot Table
Some text is overlapping with other cells and vertical alignment is not right
Problem while importing dates around 1900 from CSV file
Font is bolder in the output PDF file when setting the PDF optimization type to "MinimumSize"
Font changed in the output image/PDF
Slight Vertical Alignment Difference between Excel and Aspose.Cells Pdfs
Font is different and percentage sign is missing in the output PDF file
Charts have "Axis Title"
3D Column charts are not rendered fine in the output PDF file
Category axis labels are not showing of chart in the output PDF
Deleting worksheet in XLSM leaves behind a remnant sheet in vba project
When specific file is saved, the output is corrupted
Excel documents gets corrupted after Save
Formula 'DAYS' in Excel tables gets replaced with a NamedRange
Setting LightAngle value corrupts Excel file
Inserting rows breaking formulas linking to external workbook
The table style was changed (The table lines are missing) after re-save in a specific XLS
Aspose.Cells sorts fine but formulas are converted to values
Cells range deletion with shift up option does not style on cells
Workbook gets corrupt after open and save
Datatable is not being shifted down properly in an XLSX
Cannot read worksheets of a password protected XLSX file
Cells.DeleteRange() is not working properly
Cannot update OleObject.ObjectSourceFullName property
Cells range deletion with shift up option does not decrease hyperlink count
Incorrect hyperlinks count when duplicating the single row data in an XLS
Moving the array in Input2.xlsx results in an unopenable file that crashes Excel on startup
Reference in the array does not update when the referenced cells are moved in Input.xlsx
Replace background for shape doesn't work
The "Locked" attribute of ActiveX control (ComboBox) is not changed while protecting worksheet
Horizontal scrollbar lost (in Google chrome) in GridWeb
Big lags (in scrolling, selecting a cell, etc.) when using long list of merged cells
The alignment of the cells lost when inserting/pasting values into the cells
Percentage value changes to NaN

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

- 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

- Demos of Aspose.Cells for .NET: http://www.aspose.com/demos/.net-components/aspose.cells/default.aspx

- Post your technical questions/queries to Aspose.Cells for .NET Forum:

- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for .NET blog: http://www.aspose.com/community/blogs/aspose.cells-product-family/default.aspx

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Phone: 888.277.6734
Fax: 866.810.9465

Submitted by:Aspose
Disclaimer: Pressbox disclaims any inaccuracies in the content contained in these releases. If you would like a release removed please send an email to remove@pressbox.co.uk together with the url of the release.