Create Chart’s PDF with Desired Page Size & Rotate Text with Shape inside Worksheet

What is new in this release?

The long awaited version of Aspose.Cells for Java 18.3.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 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. Users can change the Language of MS Excel file by right clicking the file and then selecting Properties > Details and then editing the Language field. Please use BuiltInDocumentPropertyCollection.Language property to change it programmatically using Aspose.Cells APIs. 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
- Aspose.Cells returns wrong value of cell A2
- XML map does not create table properly
- Get/extract values (0 for 0 and blank for blank) using DataPoint.getYValue() method for a given chart
- Inversion of subtitles (legend entries) in MS Excel chart
- Arrows are missing in PNG output of Excel Chart
- Java method 'Shape.toImage' works differently with the same method in .NET
- Aspose.Cells 18.3 rotation for a TextBox is not working for EXCEL_97_TO_2003 save format
- Blank new line appears inside the TextBox after processing and saving the Excel file

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 Java documentation that may guide users briefly how to use Aspose.Cells for performing different tasks like the followings.

- Create Chart PDF with Desired Page Size
- Rotate Text with Shape inside the Worksheet

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 protected]
Phone: 888.277.6734
Fax: 866.810.9465