Custom Page Size Options for Worksheet & GridWeb Working with SQL Server ASP.NET Session State

2024-10-31 07:21:15 Computer

1109

Aspose development team is pleased to announce the new release of Aspose.Cells for .NET 17.5.0. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the API. Aspose.Cells now allows users to create PDF with PDF/A-1a ? Level A (accessible) conformance. It already supports PDF/A-1b ? Level B (basic) conformance. The code snippet on blog announcement page demonstrates how to convert an Excel file to PDF compatible with PDFA-1a. Sometimes developers want to remove existing Printer Settings in Excel file. These settings are found inside the ?[file ?root?]xlprinterSettings? folder in the form of .bin files. Aspose.Cells can remove existing printer settings in the Excel workbook. There is no direct option available to create custom paper sizes in MS Excel, however users can set custom paper size of a desired worksheets when rendering Excel file to PDF file format. Using Aspose.Cells APIs, developers can fill a DataTable with corresponding HTML strings (based on cells values) while exporting worksheet data. A documention page is provided that explains how to export HTML strings for the formatted cells data to fill a DataTable using Aspose.Cells APIs. If you want to use SQL Server or StateServer to hold sessions, use GridWeb Session Mode. The GridWeb control now supports serializing its data to SQL Server or StateServer. Earlier, Aspose.Cells does not shift first row down when inserting rows. But for some users? requirements, it has supported this feature now. When developers copy worksheet into another worksheet, then page setup settings of the source worksheet are not copied to destination worksheet. Please use PageSetup.Copy() method to copy the setting of the page setup from source to destination worksheet. This release includes several enhanced features and bug fixes as listed below

? Support PDF/A-1a compliance in PdfSaveOptions
? Remove existing PrinterSettings in Excel file
? Implement Custom Page Size options for the worksheet
? Support exporting HTML cells' data to DataTable
? Support the working of GridWeb when ASP.NET Session state mode is SQL Server
? OutOfMemory error during image rendering
? Converting XLS to SpreadsheetML having filters corrupts the output file
? Saving Excel to PDF rotates the image
? Wrong styles when save to HTML with css prefix
? Text alignment of the vertically rotated text is wrong in the output HTML
? Text does not fit into cell when saving as HTML
? Exception occurred on loading an HTML file
? Pivot table data is not refreshed correctly
? Workbook calculation method is unable to calculate XIRR formula - II
? Values in cell M114 and N114 are not correct after Workbook formula calculation
? Workbook calculation method is unable to calculate XIRR formula
? Multiple users face problem in GridWeb when Session state is out of process
? Characters' position is not center aligned when rendering an Excel file to PDF
? Converted from ODS to XML (SpreadsheetML) file is not opened by MS Excel
? Cell.HtmlString does not highlight the nested font color properly
? Data validations end up strange after inserting new rows
? Cells.ImportDataTable method has changed
? CopyOptions.ExtendToAdjacentRange property is not working
? Final Excel file is different than the original Excel file
? Shapes (rectangles, lines, etc.) are not bonded anymore when re-saving from XLSX to XLS file format
? Opening and saving the Excel file makes the alignment wrong
? Opening and saving the XLSM file with newer version corrupts it
? Removing all comments from a workbook causes errors upon opening in Excel
? Translate "Other" of Pie chart
? Legend entries are not hidden correctly in the combined chart

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.

- Convert Excel file to PDF format compatible with PDFA-1a: https://docs.aspose.com/display/cellsnet/Convert+Excel+file+to+PDF+format+compatible+with+PDFA-1a

- Implement Custom Paper Size of Worksheet for Rendering: https://docs.aspose.com/display/cellsnet/Implement+Custom+Paper+Size+of+Worksheet+for+Rendering

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