Create Chart's PDF with Desired Page Size & Rotate Text with Shape inside the Worksheet using Java

LANE COVE, Australia - May 11, 2018 - PRLog -- What's new in this release?

Aspose team is pleased to announce the new release of Aspose.Cells for Java 18.4. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the APIs. It also recommends Aspose clients to use the powerful Aspose for Java APIs directly in their Maven Projects with simple configurations. Developers can create chart's PDF file with desired page size using Aspose.Cells and specify how users want to align the chart inside the page as top, bottom, center, left, right etc. Besides this, the output chart can be created in stream or on disk. Please see the article on blog announcement page for more detail on this topic. Users can add text inside any shape using Microsoft Excel. If users add shape using the older Microsoft Excel 2003, then text will not rotate with shape. But if adds shape using newer versions of Microsoft Excel e.g. 2007, 2010, 2013 or 2016 etc. then text will be rotated with shape. Users can control if the text should rotate with shape or not using the ShapeTextAlignment.RotateTextWithShape property. When users apply auto filter on worksheet cells, then some of the rows get hidden automatically. But it might be the case that some of the rows are already hidden manually by MS Excel end user and they are not hidden by auto filter feature. It therefore makes difficult to know which of the rows are hidden by auto filter and which rows are hidden manually by MS Excel end user. Aspose.Cells deals with this problem using the int[] AutoFilter.refresh(boolean hideRows) method. This method returns the row indices of all the rows that are hidden by auto filter and not by manual way in MS Excel. When users apply auto filter on worksheet cells, then some of the rows get hidden automatically. But it might be the case that some of the rows are already hidden manually by MS Excel end user and they are not hidden by auto filter feature. It therefore makes difficult to know which of the rows are hidden by auto filter and which rows are hidden manually by MS Excel end user. Aspose.Cells deals with this problem using the int[] AutoFilter.refresh(boolean hideRows) method. This method returns the row indices of all the rows that are hidden by auto filter and not by manual way in MS Excel. Sometime, users want to know the type of X and Y values of chart points in a series. Aspose.Cells provides ChartPoint.XValueType and ChartPoint.YValueType properties that can be used for this purpose. Please note, users will have to call Chart.calculate() method before users could use these properties effectively. Aspose.Cells returns the HTML string of the cell using the string Cell.getHtmlString (boolean html5) method. If users pass "false" as parameter, it will return users Normal HTML but if users pass "true" as parameter, it will return Html5 string. When users save your MS Excel file to HTML, users can specify different cross types for cell strings. By default, Aspose.Cells generates HTML as per Microsoft Excel but when users change cross type to CrossHideRight then it hides all the strings from the right side of the cell which are overlaid or overlapping with cell string.  Below are some important new features, enhancement and bug fixes part of this release.

·         Use FIPS compliant version of Bouncy Castle in Aspose.Cells APIs

·         Formula should not contain more than 8192 characters

·         Unable to access horizontal category axis labels items of Chart in XLS

·         Get/set Language document property

·         Foreground color vs Background color vs Fill color - Use a single method that takes two arguments

·         "<Font>" is not a valid HTML5 and self-closing tag and web browsers misrepresent its contents

·         Insert SVG image type into worksheet cells by Aspose.Cells

·         Some shapes are not correct in the output PDF

·         Conditional formatting is lost while saving Excel to HTML

·         Output HTML does not match with MS-Excel

·         Links to named area are wrong after export to HTML

·         Pivot Tables and corresponding Charts do not have correct Date format

·         Chart has many values in x-axis and values are overlapping over each othe

Other most recent bug fixes are also included in this release


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: http://www.aspose.com/products/cells/java

-  Download Aspose.Cells for Java: http://www.aspose.com/downloads/cells/java

-  Online documentation of Aspose.Cells for Java: http://www.aspose.com/docs/display/cellsjava/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