Create Custom Subtotal Labels in Excel Spreadsheet & Access Hyperlink from a GridWeb using .NET

2024-11-01 09:19:09 Computer

1197

Aspose team is pleased to announce the new release of Aspose.Cells for .NET 16.11.0. The new release includes some features and other important enhancements with some critical bug fixes. This release has added the support for the creation of custom subtotal labels allowing the application developers to customize the labels according to the region or personal preferences. In order to provide this feature, the latest version of the Aspose.Cells for .NET has exposed the GlobalizationSettings class offering the following 2 methods which can be overridden in a custom class to get desired labels for the Subtotals. The GlobalizationSettings class also offers the GetOtherName method which is useful to give the ?Other? label of Pie charts a custom value. The snippet on blog announcement page defines a custom class and overrides the GetOtherName method to get a custom label based on the system?s regional (culture) settings. It has exposed the CellsFactory class which currently has one method, that is; CreateStyle. The CellsFactory.CreateStyle method can be used to create an instance of Style class without adding it to the pool of workbook styles. It has exposed GetHyperlink method to the GridHyperlinkCollection class that allows to get the instance of GridHyperlink by either passing an instance GridCell or a pair of integers corresponding to the row column indices. Some important enhancements are also part of this release, such as support for MINIFS & MAXIFS functions, ability to manipulate Workbook?s Absolute Path, ability to implement Subtotal or Grand Total labels in other languages, aspose.Cells for .NET formula calculation engine is enhanced, handled and fixed a few exceptions, such as, Stack overflow, NullPointerException, IndexOutOfRangeException and many more. Furthermore, in this release, It has fixed several other issues. For example, issues around reading/writing MS Excel Excel file formats, manipulating and rendering shapes, manipulating PivotTables, copying ranges in the worksheet, rendering to HTML file format, 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

? Support MINIF and MAXIF functions
? Web links on spreadsheet are opened on the same page where GridWeb is loaded
? UpdateLinkedDataSource() doesn't work when Workbook is loaded from stream
? Deprecated .size() function used in acwmain.js
? Mimic MS Excel behavior when "Enter" key is pressed
? Set focus on the formula back when inserting a formula with wrong parameters (invalid formula)
? Performance issue with GetPivotData function
? Issue with SheetRender.PageCount that takes a long time to calculate worksheet pages
? Range.Copy() method freezes for big Excel ranges
? Spreadsheet becomes corrupted when Workbook names is appended to the Named Range
? RTL direction is changed to LTR while converting HTML to Excel
? PivotTable is losing filters after RefreshData call
? Pivot Table fails to refresh after changing data source to a Named Range
? Calling PivotTable.CalculateData() causes a crash when there is 1 data column
? Excel file is corrupt after opening and resaving it
? CSS style ignored for column widths, row heights and word wrap, etc. (HTML to Excel)
? Issue with font-weight and text-align in TD and TH cells
? PivotTable contents are not showing correctly in the output PDF
? Culture settings for Workbook does not take effect for Chart DataLabels using Chart.ToImage
? SUMPRODUCT function with external ranges results in '#REF!' error
? Long values in cell renders as '#' string while converting worksheet to image
? Issue with the size of the converted file (Excel to PDF Conversion)
? Considerable increase in the output PDF file size from a relatively smaller Excel file
? Label is missing when a chart is converted into image
? Trendline in the chart is not rendering fine in the output PDF
? SheetRender.ToImage: Chart overlaps the row below it
? Formula gets _xlfn prefix after the calculation of workbook
? Resave operation corrupts the spreadsheet when worksheet name is " or "
? Corrupted output file generated by Aspose.Cells APIs
? The shapes are not in the same order (as per the original shapes' z order position)
? Removing image from header/footer corrupts the document
? Changing background image of a shape corrupts output XLS file
? Line spacing from TextBox is lost with simple re-save
? ThreeDFormat.TopBevelWidth and TopBevelHeight are not getting applied
? Open and Save document creates corrupted file
? Issue with updating External Link's data source and AbsPath
? Font of Chart Data labels and Legend is changed on opening and re-saving source Excel file
? Unable to update address of a GridHyperlink
? Set alternative text for hyperlink if image URL is not correct
? Accessing hyperlink via cell reference is not possible with GridHyperlinkCollection class
? Obsoleted APIs are not identified in Visual Studio
? Width of Auto-Filter's Dropdown is too small to make a selection
? Trendline in the chart is not rendering fine - Aspose.Cells.GridDesktop
? Auto filters are applied to all the columns instead of specific range/columns only
? RowFilteredEvent of GridDesktop never occurs
? Hidden rows due to filter remain hidden after removing the filter
? Certain formatting elements in the template XLSM file are not imported correctly
? GridDesktop.Button click event never fires on 200% zoom
? Aspose.Cells.GridDesktop: Paste is Always inactive in context menu
? GridWeb control, column disappear if drag to left

Other most recent bug fixes are also included in this release

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