Disable Pivot Table Ribbon & Apply Text Alignment to Partial Text inside TextBox

What is new in this release?

The long awaited version of Aspose.Cells for Java 18.8 has been released. It includes new features, enhancements and bug fixes to supplement the usability of the product and support the developers community. New features are always part of every release to enrich the product. It is very common to apply different alignments to the partial texts in the text box. This feature was having some issues but now it is reviewed and bugs are removed to incorporate proper alignment. This option allows screen reader software to utilize the text within the PDF file for reading. You can disable it by applying a change permissions password and deselecting few options in Adobe Acrobat. Same functionality can be achieved using Aspose.Cells for Java now. Pivot table based reports are useful but prone to error if target users do not have detailed knowledge of Excel to configure these reports. In these circumstances organizations will want to restrict users from being able to change a pivot table based report. Common pivot table features like adding additional filters, slicers, fields, or changing the order of certain things in the report are mostly not recommended for every user. On the other hand, these users shall also be able to refresh the report and use existing filters or slicers. Aspose.Cells has provided this ability to developers for restricting users from changing these reports while creating them. For this purpose Excel provides feature to disable pivot table ribbon and same is provided by Aspose.Cells i.e. developer can disable the ribbon which contain controls to modify these reports. Reliability and efficiency is basic requirement by the users for any software product. If some conversion takes too long, sometimes it is required to interrupt this process to return control to the user. This feature is already present but got some performance issues, however we have further improved it and now can be used without any trouble. While working with Excel, pasting rows and columns is very common and this feature was introduced in the earliest versions of Aspose.Cells. However limited paste option was available in contrast to Excel where variety of options are available when we paste data somewhere in Excel. Now Aspose.Cells has provided this feature and you can paste data with multiple options. There are some other enhancements and exceptions part of this new release, such as Hyperlinks not working when referenced from other sheets, Incorrect alignment issue while rendering to PDF, Wrong placement of table data from HTML to Excel file, Depiction of slicer control while spreadsheet to HTML conversion, Improper gradient color rendering to PDF, Improper chart category title display in PDF and Wrong border style for merged cells. Below are some important new features, enhancement and bug fixes part of this release.

- Disable Pivot Table Ribbon
- Protect workbook and worksheet in ODS file
- Interruption issue with saving XLSX file process
- Hyperlink not working when referenced from other sheet
- Incorrect alignment while rendering spreadsheet to PDF format
- Table data shifted to wrong row and column while converting from HTML to MS Excel file format
- Chart's image position is wrong in Chrome & FireFox while converting to HTML
- Slicer control is not rendered when converting Excel file to HTML file format
- Vertical line at the center of the chart is not drawn properly in the rendered image
- Gradient color for negative bubbles is not applying in the PDF output
- Chart category title not shown properly in the image
- Wrong border style returned for merged cell
- Read watermark from Excel file
- Property comment contains unnecessary text
- Property "revision number" not checked correctly
- Macros in the ODS file are not retained in the generated ODS file format
- NegativeArraySizeException while converting XLSX to HTML
- NumberFormatException raised while loading the HTML file into workbook
- NullPointerException exception raised while calling the CalculateFormula
- Exception when rendering worksheet to PNG file format
- Error in Cell: E22-Invalid formula - exception on opening MS 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.

- Applying text alignment to partial text inside the TextBox
- Pasting Rows/Columns with Paste Options

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
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465