#Specifying DBNum Custom Pattern Formatting

[file-formats-programming]

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

What’s new in this release?

Aspose team is 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 users briefly how to use Aspose.Cells for performing different tasks like the followings.

Password Protect the VBA Project of Excel Workbook

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, SpreadsheetML, PDF and all file formats from Excel 97 to Excel 2007.

More about Aspose.Cells for .NET

Homepage of Aspose.Cells for .NET C#

Download Aspose.Cells for .NET

Online documentation of Aspose.Cells for .NET

[file-formats-programming]

Aspose.Newsletter June 2017: Process Huge Sized PowerPoint Files Accurately & Other News

Aspose Newsletter for June 2017 has now been published that highlights all the newly supported features offered in the recent releases.  It also includes information about Manipulating PowerPoint presentations and templates without Microsoft PowerPoint installed, Render DWF Files to PDF and aster Images, password protect Excel workbook VBA project in .NET & Java applications, adding checksum validation on codabar coded barcode in Java, Support for 64-bit Versions of Windows Included in Aspose.Cells for C++, how to render PDF to Image, PDF/A and DOCX formats in Java and many more.

Process Huge Monster Sized PowerPoint Files Quickly and Accurately With Just a Few Lines of Code

Manipulate PowerPoint Presentations and Templates WITHOUT Microsoft PowerPoint installed. Aspose.Slides offers standalone PowerPoint APIs to Create, Edit or Convert PowerPoint Presentation files to PDF, PDF/A, XPS, Images, HTML, ODP and other PowerPoint formats. Try out fully featured Demos, Examples, Plugins, Showcase projects and a comprehensive Documentation to take a start from. Download Free Trial

Password Protect Excel Workbook VBA Project in .NET and Java Applications

Programmatically protect VBA (Visual Basic for Applications) project of Excel Workbook with password and lock it for viewing. Also specify sort warning while sorting data and apply DBNum custom pattern formatting using Aspose.Cells for .NET and Java.

Render DWF Files to PDF and aster Images in .NET and Java Applications

Aspose.CAD for Java supports MLeader entity. You can easily work with DWF and DWG file formats that include improved conversion support for DWG file format as well in terms of exporting to PDF and images within .NET and Java Applications.

Adding Checksum Validation on Codabar Coded Barcode in Java

Aspose.BarCode for Java API now exposes the CodabarChecksumMode enumeration to specify the checksum mode. EnableChecksum property of the BarCodeBuilder class is needed to be set to TRUE before setting the checksum mode. Read more details here

Support for 64-bit Versions of Windows Included in Aspose.Cells for C++

Aspose.Cells for C++ now supports both 32-bit and 64-bit versions of Windows for desktop (e.g XP, Vista, 7, 8, 10) and server operating systems (e.g 2003, 2008, 2012). You may use Aspose.Cells for C++ APIs to build any type of 32-bit and 64-bit C++ application. Continue reading here

How to: Modify or Delete an Occurrence from a Recurrence Pattern in .NET and Java?

Aspose.Email APIs allows working with recurrence patterns for Outlook Calendar items.  It allows you to modify or delete a specific occurrence from a recurrence pattern. This is achieved by adding an exception to the occurrences of a recurrence pattern as shown in .NET and Java code samples

How to: Render PDF to Image, PDF/A and DOCX formats in Java?

The improved Aspose.PDF for Java 17.3.0 API is more stable and capable of handling more complex documents similar structures. It allows you to convert PDF to Images, PDF/A and to various Microsoft Office formats including DOC, DOCX, XLS and PPTX format. Read more here

How to: Specify Horizontal and Vertical Resolution while Saving Word Document to Image Format in Cloud?

Aspose.Words for Cloud allows you to work with MS Word Documents using the language and platform of your choice. It comes with SDKs written in 9 different languages complete with running examples to get you started in no time. Now you can set the Horizontal and Vertical Resolution while converting a word document to an Image format. Read more

How to: Extract SWF Data from PowerPoint Presentations in Java?

Aspose.Slides for Java provides a facility for extracting flash objects from presentation. You can access embedded SWF file data inside presentation and can even extract it. Read more

Updates about new Product Releases

Aspose.Total for .NET – a compilation of our latest .NET products.

Aspose.Total for Java – a compilation of our latest Java products.

Aspose.Total for Cloud – RTF compression implemented, and other enhancements.

Aspose.Total for Android – all the latest versions of our Android APIs.

Aspose.Total for SharePoint – a compilation of our latest SharePoint products.

Aspose.Total for Reporting Services– a compilation of our latest Reporting Services products

Aspose.Total for JasperReports – The latest versions of our JasperReports products.

Aspose.Words for .NET 17.5 – Improved MailMerge and Metafile rendering performance.

Aspose.Cells for Cloud 17.5 – Delete comments in a Worksheet. Apply MS Excel 2007 themes and colors.

Aspose.Slides for .NET 17.4 – Improved print options including margins, print copies and print preview.

Aspose.BarCode for .NET and SSRS 17.4 – Improved GS1 Barcode generation and recognition.

Aspose.Tasks for Java 17.3 – Improved project recalculation as well as reading and writing MPP files.

Aspose.Diagram for .NET 17.4 – Detect format and read shape data of macro enabled Visio drawings.

Aspose.Diagram for Java 17.4 – Enhanced import of graphics in the Visio drawing.

Aspose.Words for JasperReports 17.4 – Improved bullet and number lists support in output Word document.

Supporting User Groups and Conferences

Aspose is sponsoring a number of user groups and upcoming events, including:

    June 08-09: GeekOut 2017 – Tallinn, Estonia

    June 12-15: Visual Studio Live! Washington – DC, USA

June 20-21: DeveloperWeek Conference 2017 NYC – New York, USA  

      Sponsor a user group? Get in contact: user.groups@aspose.com

Collect your copy of Aspose Newsletter, November 2013 edition

Collect the English version of this newsletter

Collect the Chinese version of this newsletter