Add Bookmarks with Named Destination & Copying VBA Project from One Excel File to Other using .NET

2024-04-22 01:58:10 Computer

842

Aspose development team is pleased to announce the new release of Aspose.Cells for .NET 17.9.0. This release includes some valuable features and other enhancements along with critical bug fixes that further improve the overall stability of the APIs. Aspose.Cells supports to specify Named Destinations in the output PDF file that do not depend on PDF pages. It means, if pages are added or deleted from PDF, bookmarks may become invalid but named destinations will remain intact. Please see the document/article (with attachments) that explains on how to add PDF Bookmarks with Named Destinations for users complete reference. If an Excel file contains external resources (linked images or objects), so, when users convert an Excel file to Pdf, Aspose.Cells retrieves these external resources and renders them to Pdf file format. Now, if users do not want to load these external resources rather you want to manipulate them, users can do this using PdfSaveOptions.StreamProvider API which implements the IStreamProvider interface. Aspose.Cells allows developers to copy VBA project from one Excel file into other. VBA project consists of various types of modules i.e. Document, Procedural, Designer etc. All modules can be copied with simple code but for Designer module, there is some extra data called Designer Storage needs to be accessed or copied. Aspose.Cells provides Shape.ToFrontOrBack()method which changes the z-order position of the shape. If users want to send shape to back you will use negative number like -1, -2, -3 etc. and if users want to send shape to front, will use positive number like 1, 2, 3 etc. Developers can sort data in the column using custom list. GridWeb displays comments as Tooltips like MS-Excel does when users hover mouse over the respective cell. The web based grid control provided by Aspose.Cells for .NET allows creating, removing and getting cell comments inside the worksheet. There are some other enhancements included in this release, such as Determining which stack size is needed for a certain Workbook, Exception: ?Too many entries. Consider setting ZipOutputStream.Enable Zip64? on merging the file(s), When RecommendReadOnly is true, IsWriteProtected is also true, Handled NullReferenceException when reading XLSX using LoadFilter containing Pivot Table, Handled ?Input string was not in a correct format? exception on opening MS Excel file. In this release, Aspose team has fixed several other issues. For example, issues around reading/writing MS Excel file formats, Smart Markers, manipulating ranges, inserting rows and columns, rendering shapes and drawing objects, manipulating OLE Objects, rendering and manipulating charts, manipulating PivotTables, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. This release includes several enhanced features and bug fixes as listed below

? Determine which Stack Size is needed for a certain Workbook
? Format the custom Label's font and its cell with Smart Markers
? Control loading of external resources in MS Excel workbook
? Lose Track Changes after conversion (XLS --> XLSM)
? Show Cell comment as Excel Tooltip - Aspose.Cells.GridWeb
? Share Price Series Label is not positioning properly
? Exception: "Too many entries. Consider setting ZipOutputStream.Enable Zip64" on merging the file(s)
? Why FitToPagesWide 1 needs to set FitToPagesTall 0 for Fit All Columns on One Page
? When RecommendReadOnly is true, IsWriteProtected is also true
? GridDesktop should not scroll past last column
? GridDesktop should not scroll past last row
? GetRanges performance issue when using customfunction with lots of functions to be calculated
? Some drawing elements' position is wrong in Excel to PDF rendering
? Grey background on the box is missing in the output PDF
? Shape text dispersed/scattered in Excel to PDF rendering
? Sheet to Image rendering ignores Asian fonts in TextBox with cell reference
? Some text (labels) missing of the shape in Sheet to Image rendering
? Providing one option to control whether keeping number precision format
? HTML output of "222.xlsx" is not right
? Two image resources created instead of one when saving as HTML file format
? "Number stored as Text" for the numeric columns
? When MHtml file is saved with XLS extension, MS Excel shows errors when opening the XLS file
? Formatting lost after saving the file as XLS
? Images lost after saving the file as XLS
? Images lost and formattings are removed when saving an MHtml file to XLS or MHT
? Infinite loop when use PageSetup.GetCommands()
? Three hyphens "---" are rendered as empty space in the output PDF
? Issue with floating lines (single, double underlines) in Excel to PDF conversion
? When ImageOrPrintOptions.OnlyArea = true, the data gets corrupted
? Partially missing characters when converting to image
? Default grey cell borders converted into dotted lines
? The word is renamed when converting to image
? Issue with Chart.Calculate() method
? Issue with trend equations in the chart
? Scale is increased in the output PDF for the Radar chart
? Chart image is not having three-digit numbers
? Unable to render image from chart via Aspose.Cells
? Incorrect Chart PDF when line plotting is compared to source Excel
? Image generated from Sample.xlsm worksheet SampleCharts is not correct
? Chart legend is rendered in wrong position when converted to image
? OLE object changes size after opening and editing OLE object file
? SpreadsheetML - Hidden attribute on column does not work
? Inserting column in worksheet causes the corrupt output Excel file
? SpreadsheetML - Hidden attribute on row is not working properly
? Saving a custom date property results in wrong time written
? Column width is changed after loading and saving an XLS file
? Circle graph and Column graph are changed dramatically after re-load and re-save
? Smart Markers: Multiple groups with skip overlaps grand total row
? Excel has to repair the macro file - Removed Part: /xl/vbaProject.bin part

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.

- Add PDF Bookmarks with Named Destinations: https://docs.aspose.com/display/cellsnet/Add+PDF+Bookmarks+with+Named+Destinations

- Copy VBA Macro UserForm DesignerStorage from Template to Target Workbook: https://docs.aspose.com/display/cellsnet/Copy+VBA+Macro+UserForm+DesignerStorage+from+Template+to+Target+Workbook

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

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