Ahsan Iqbal September 4, 20180 Comments

Paste text with paste options and disable pivot table ribbon using Aspose.Cells for Java 18.8

Paste text with paste options and disable pivot table ribbon using Aspose.Cells for Java 18.8

September 4, 2018
Share on FacebookTweet about this on TwitterShare on LinkedIn

We are pleased to announce the release of Aspose.Cells for Java v18.8 having new features, enhancements and bug fixes to supplement the usability of the product and support the developers community. New features are always part of our every release to enrich the product. 
Special effort is made to address all the known issues and fulfill enhancement requests for a rapid development of feature rich market oriented products. Detailed release notes are published as usual for a detailed information about the enhancements, bugs fixing and handling of variety of exceptions in this new release. For an easy access and utilization, Aspose for Java APIs can be directly installed from Maven repository for which check document.

Applying text alignment to partial text inside the TextBox

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.   

For a working example refer to the following article:

Content Copying for accessibility

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. 

For a working example refer to the following article:

Disable Pivot Table Ribbon 

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.

For a working example along with a template file refer to the following article:

Improvements in process interruption 

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.  

For a working example refer to the following article:

Pasting rows/columns with paste option 

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.   

For a working example refer to the following article:

Other Enhancements and Fixes

There are some other enhancements included and a few exceptions handled in the new release for the users. A few of the worth mentioning features and other improvements are as follows.

  • 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
  • Wrong border style for merged cells

In Aspose.Cells 18.8, we fixed several important bugs and other issues. For example, issues of not drawing the vertical line at the center of the chart, reading water mark from file, unnecessary text in property comment, retaining the macros in ODS files and rendering exception while converting worksheet to image. 

Changes to the Public API

The following is a list of any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for Java:

  • Adds PdfSecurityOptions.AccessibilityExtractContent, Permission to copy or extract content (in support of accessibility to disabled users or for other purposes)
  • Adds SubtotalSetting class, Represents the setting of subtotal.
  • Adds Cells.RetrieveSubtotalSetting(CellArea) method, Retrieves the setting of subtotal
  • Adds overload Range.ExportDataTable (Aspose.Cells.ExportTableOptions) method, Supports options of exporting range
  • Adds WebQueryConnection.IsSameSetting property and deletes WebQueryConnection.IsFirstRow property, Use WebQueryConnection.IsSameSetting property instead
  • Adds WebQueryConnection.IsXmlSourceData property and deletes WebQueryConnection.IsSourceData property, Use WebQueryConnection.IsXmlSourceData property instead
  • Adds Shape.IsEquation property, Indicates whether the shape contains equation
  • Adds overload Cells.CopyColumns(Int32,Int32,PasteOptions) and Cells.CopyRows(Int32,Int32,PasteOptions) method, Supports paste options when copying rows and columns
  • Adds Axis.IsAutoTickLabelSpacing property, Indicates whether tick label spacing is automatic

Aspose.Cells for Java Resources

The resources, you may need to accomplish your tasks:

Leave a comment

Posted inAspose.Cells Product Family
 

Related Articles