Render HTML with Scalable Column Width & Get Connection Points from Shapes using .NET

2024-04-24 07:12:15 Computer

746

Aspose development team is pleased to announce the new release of Aspose.Cells for .NET 18.10. MS Excel file formats API that provides the ability to create, manipulate, convert or render MS Excel spreadsheets, and more importantly ? is fully documented. Please check the document on how to install Aspose for .NET APIs directly from NuGet repository. It has added a few important features while keeping the product more stable and feature rich API. In this release, it has also added some useful enhancements and resolved a number of issues. Sometimes when some bug or issue is reported, that guides us to provide some new feature or enhancement thus makes this product more users friendly and capable of solving complex problems in an easier way. Simple features which become quite handy while working with a complex product are added like providing last saved time property for keeping track of changes etc. Depiction of data through HTML page is very common, however this page can be opened in a variety of devices including mobiles, tabs and other hand held devices which contain small screens. The size of the columns is defined in ?pt? which works in many cases. However there can be case where this fixed size may not be required. For example, if container panel width is 600px where this HTML page is being displayed. In this case users may get horizontal scrollbar if the generated table width is bigger. This requirement is addressed by providing scalable units like em or percent for a better presentation. Empty tags are very common while working with HTML like we can face or simply . Earlier self-closing tags were not supported however now this support is provided. Now you can load any HTML with self-closing tags and convert it to Excel file. Named regions can have English formulae and this file can be used in environments where systems are configured to German locale. There is need to translate these English formulae completely to German language for correct usage in MS Excel configured for German language. This feature is fully functional and can be used without any extra coding. MS Excel provides custom filters like filter rows which begins with and ends with some specific string. This feature is available in Aspose.Cells and demonstrated by providing working examples. Aspose.Cells provides rich features to manage shapes in the spreadsheet. Sometimes there is needed to get the connection points of a shape for aligning or placing the shapes at appropriate place. For this purpose all the connection points are required. Following code can be used to get the list of connection points of a shape where Shape.GetConnectionPoints() function is used. There are some other enhancements included and a few exceptions handled in the new release for the users. A few of the worth mentioning features and other improvements , such as Using preferred parser and Handled an exception which occurred when loading an Excel file. In Aspose.Cells 18.10, we fixed several important bugs and other issues. For example, issues around reading/writing MS Excel file formats, applying data filtering, manipulating OLE Objects, reading/writing HTML files, manipulating List Objects/Tables, applying auto-fit rows/columns, formatting cells, Smart Markers, manipulating document properties, rendering and manipulating charts and shapes, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved in the release. This release includes several enhanced features and bug fixes as listed below

? Get connection points from shapes
? Change columns' fixed size width (i.e., pt/px) into scalable unit like "em" or "percent"
? Issue with the image source when rendering Excel to HTML file format
? Font size changed from 6.5 to 6 while converting XLSX to HTML
? Recognize empty tags like while converting HTML to MS Excel file format
? Sub-Total missing when rows collapsed after refresh
? Issue in number fields while calling the Worksheet.AutoFitColumns()
? XLSB file gets corrupt on opening and saving
? CSV import creates incorrect formatting using PreferredParsers
? "_xll" attached in front of formula name
? Named range formula ("=GET.CELL") not properly created in German locale
? Escape character is displayed as it is in PDF
? PDF output page size(and margins) doesn't match MS Excel output
? Height of image in header truncated along with broken layout during XLSM->PDF conversion
? Image not repeating properly when print titles are set for rows and columns
? Rendering image from a simple chart takes all resources and then raises exception
? Accessing visibility properties changed the visibility of the chart in the re-saved output
? SourceFullName property of OLE Object is empty while accessing in XLSB
? Header picture/shape is not rendered correctly when re-saving an XLSX file
? Difference in OLE Objects before and after saving the XLSB file
? Phonetic guide missing after copy and save
? Resizing tables changes format of cells
? Wrong detection of cell foreground and background color
? Autofit happens automatically to the hidden rows when rows are auto filtered
? Custom scheme 'm-files://...' is converted in document save-operation
? XLSB files cannot be opened using LoadDataFilterOption other than LoadDataFilterOption.All
? Formula missing single quote
? LoadDataFilterOptions.SheetSettings not working for XLSB files
? View is changed to protected while converting XLS -> XLSM -> XLS
? XLSX file is corrupt after converting from an XML (SpreadsheetML) file
? Smart Marker does not evaluate ISBLANK properly
? FilterOperatorType.Contains missing from API

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.

- Recognize self-closing tags: https://docs.aspose.com/display/cellsnet/Recognise+self+closing+tags

- Support for German Locale in Named Range Formulae: https://docs.aspose.com/display/cellsnet/Support+for+German+Locale+in+Named+Range+Formulae

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: https://products.aspose.com/cells/net

- Download Aspose.Cells for .NET: https://downloads.aspose.com/cells/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