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 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
• 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.