borderAndreaVB free resources for Visual Basic developersborder
AndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2017 Andrea Tincani

AndreaVB Home | News Home | Forum Home | Downloads | Register | Search | PM | Profile

Next Topic (3D Rotation Effects in Visio Drawing & Enhanced Retrieval of SolutionXML from Visio Drawings) New Topic Post Reply
AndreaVB OnLine : News : Remove Existing Printer Settings in Excel File & PDF/A-1a Compliance Support using Java
Poster Resource
sherazam
Level: Wizard

Registered: 11-03-2010
Posts: 1213
icon Remove Existing Printer Settings in Excel File & PDF/A-1a Compliance Support using Java

What is new in this release?

The long awaited version of Aspose.Cells for Java 17.5.0 has been released. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the API. It is also recommend for clients to use the powerful Aspose for Java APIs directly in their Maven Projects with simple configurations. 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. Following code snippet 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 the desired worksheets when rendering Excel file to PDF file format. The documentation article explains how to set custom paper size of a worksheet using Aspose.Cells APIs. Earlier, Aspose.Cells does not shift first row down when inserting rows. But for some users’ requirements, it has supported this feature now. When users 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. Below are some important new features, enhancement and bug fixes part of this release.

- Change the language of the predefined words for Pivot Table
- Options to embed the hyperlink in an Excel cell
- NullPointerException occurs when the filter exists outside of the named range
- Copying a worksheet unhides filtered rows in the output HTML file
- Contents are shown differently (some text is missing) in non IE browsers (e.g Google chrome) - Excel to HTML rendering
- Conditional formatting is lost when refreshing PivotTable in the spreadsheet
- Conditional formatting style is broken
- Excel formula is not working properly - it is shown as 6 instead of 0
- Saving XLS file with graphs uses 100% CPU
- Title is obscured by the trend labels in the output PDF
- Workbook.getFonts() shows additional fonts after reload the same spreadsheet
- Merging/Copying to Excel sheets - Spaces in the beginning of the cells are not getting retained
- Invalid string in the file - error occurs on opening an Excel file
- Names of some public methods parameters changed in the newer version
- Worksheet.autoFitColumns() does not work well with the cells having line breaks
- Sorting the Excel file containing comments corrupts the output Excel file
- Sorting comments causes "Excel found unreadable content...." error when opening the output file into MS Excel
- Subscript and superscript issues in OpenOffice ODS file when converting to HTML or PDF

Other most recent bug fixes are also included in this releas

Overview: Aspose.Cells for Java

Aspose.Cells is a Java component for spreadsheet reporting without using Microsoft Excel. Other features include creating spreadsheets, opening encrypted excel files, macros, VBA, unicode, formula settings, pivot tables, importing data from JDBC ResultSet and support of CSV, SpreadsheetML, PDF, ODS and all file formats from Excel 97 to Excel 2007. It is compatible with Windows, Linux & Unix and supports all advanced features of data management, formatting, worksheet, charting and graphics.

More about Aspose.Cells for Java

- Homepage of Aspose.Cells for Java
- Download Aspose.Cells for Java
- Online documentation of Aspose.Cells for Java

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Aspose - The .NET and Java component publisher
[email]sales@aspose.com[/email]
Phone: 888.277.6734
Fax: 866.810.9465

____________________________
Sher Azam
www.aspose.com

16-06-2017 at 03:28 PM
View Profile Send Email to User Show All Posts Visit Homepage | Add Comment
AndreaVB OnLine : News : Remove Existing Printer Settings in Excel File & PDF/A-1a Compliance Support using Java
Next Topic (3D Rotation Effects in Visio Drawing & Enhanced Retrieval of SolutionXML from Visio Drawings)New Topic Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
borderAndreaVB free resources for Visual Basic developersborder
borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2017 Andrea Tincaniborder