Resize Chart’s Data Label Shape to Fit Text & Detect Password Protected Worksheet using Java

2024-10-31 06:52:08 Computer

743

We are pleased to announce the new release of Aspose.Cells for Java 8.7.0. Aspose.Cells APIs have provided an enhancement for the PDF rendering engine in order to reduce the resultant PDF file size. It has exposed a new property along with an enumeration by the name PdfOptimizationType in order to facilitate the application developers to control the resultant PDF file size to some extent. The piece of code on the blog announcement demonstrates the usage of PdfSaveOptions.OptimizationType property to minimize the resultant PDF file size while exporting spreadsheets to PDF format. It has also exposed the boolean type property in order to mimic the Excel?s feature of re-sizing data label shapes to fit the text. Please note, Excel application provides the Resize shape to fit text option for chart?s data labels to increase the size of the shape so that the text fits inside of it. This option can be accessed on Excel interface by selecting any of the data labels on the chart. Right click and select Format DataLabels menu. Aspose.Cells APIs have enhanced the Protection class by introducing some useful properties & methods. Two of the most worth mentioning enhancements are as follow. It is possible to protect the workbooks and worksheets separately. For instance, a spreadsheet may contain one or more worksheets that are password protected, however, the spreadsheet itself may or may not be protected. Aspose.Cells API for Java has provided a field to detect if a worksheet is password protected. Boolean type field returns true if Worksheet is password protected and false if not. It has exposed the Protection.verifyPassword method which allows to specify a password as an instance of String and verifies if same password has been used to protect the worksheet. The Protection.verifyPassword method returns true if the specified password matches with the password used to protect the given Worksheet, false if specified password does not match. Aspose.Cells for Java has provided support to identify & parse the formulas while loading CSV/TXT files having delimited plain data. Newly exposed TxtLoadOptions.HasFormula property when set to true directs the API to parse the formulas from the input delimited file and set them to relevant cells without requiring any additional processing. This release of the API has has exposed the ColorScale.Is3ColorScale property that can be used to create 2-Color Scale conditional format. The said property is of type boolean with default value of true which means that the conditional format will be of 3-Color Scale by default. However, switching the ColorScale.Is3ColorScale property to false will generate a 2-Color Scale conditional format. This release includes several enhanced features and bug fixes as listed below

? Expose API for "Resize Shape To Fit Text" property for Chart's DataLabels
? Cells.importCSV() method not recognizing formulas
? API renders the Russian month name differently before & after calling calculateFormula method
? Aspose.Cells is not reading anything from the Excel sheet in the template file
? Chart images are of 0 KB in size while converting spreadsheet to HTML
? Chart image is missing in HTML
? HTML Output Produces Unpredictable Results
? Image in spreadsheet is not getting exported to HTML
? Date alignment issue when converting from EXCEL to HTML and back to EXCEL
? Wrong background-color for cells appears when exporting a range of cells to html
? Conversion to HTML generates a very huge HTML file
? Text Color is not rendered Properly in HTML of Excel Tables
? Hyperlink in a ListObject pointing to a range becomes broken when spreadsheet is converted to HTML
? Applying named style on a cell does not reflect in Styles section of Excel interface
? Cell.calculate() method does not work properly for a specific cell
? ListObject's header font color is lost while copying ranges
? Text Color is not rendered Properly in image of Excel Tables
? Issue with hebrew chaaracter in heading
? DataBar's Border is not same as of Excel when rendering to Image
? Missing border while rendering DataBar to image
? DataBar to Image: DataBar size in image does not correspond to Excel
? Sheet not rendering correctly using SheetRender.toImage()
? Plot Area height & Plot Area Y values are different after reloading the chart from spreadsheet
? Chart to Image Conversion - Chart image is not correctly rendered as Bar sizes showing differently
? Anti-Aliasing does not seem to take effect for the chart's series fill while exporting to HTML
? RenderingHints.VALUE_TEXT_ANTIALIAS_GASP isn't taking effect while converting spreadsheet to HTML
? Incorrect Colors are rendered in Chart's PDF
? All bars appear below 0 value rule in Chart's PDF
? Clustered Bar graphs are not getting displayed in the output PDF file format
? Thickness of X-axis and Y-axis is increased in Chart's PDF
? Bubble chart is not displaying properly while converting it to image
? Chart Series Value Gets Displayed at an Angle
? lower section of the X-axis in Chart's PDF is getting trimmed
? Axis labels are shown tilted while rendering chart to PDF
? Alignment of header not accurate in Chart to PDF
? A few data series bars are missing in Chart's PDF using Chart.toPdf
? Chart's quality issue - Anti-aliasing is not taken effect without shadow
? Bubble chart has no anti-aliasing effect in the rendered HTML file format
? Excel to PDF conversion issue - right side cut off
? Wrong font color appears for tables and ranges in the generated HTML/Image/PDF format
? Worksheet.getProtection().getPasswordHash() returns 0 after re-protection by macro code
? Image is not transparent in the output pdf
? Incorrect Rendering of Conditionally Formatted Cell Colors in Resultant PDF
? Saving Conditional Formatting's Icon Image Data to File Results in Blank Image
? Process gets stuck while loading and converting to xlsx file from xml
? Unreadable content in Excel 2007 after re-saving XLSB

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 you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Save Excel into PDF with Standard or Minimum Size: http://www.aspose.com/docs/display/cellsjava/Save+Excel+into+PDF+with+Standard+or+Minimum+Size

- Resize Chart's Data Label Shape To Fit Text: http://www.aspose.com/docs/display/cellsjava/Resize+Chart's+Data+Label+Shape+To+Fit+Text

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/java/excel-component.aspx

- Download Aspose.Cells for Java: http://www.aspose.com/community/files/72/java-components/aspose.cells-for-java/default.aspx

- Online documentation of Aspose.Cells for Java: http://www.aspose.com/docs/display/cellsjava/Home

- Demos of Aspose.Cells for Java: http://www.aspose.com/demos/java-components/aspose.cells/default.aspx

- Post your technical questions/queries to Aspose.Cells for Java Forum:
http://www.aspose.com/community/forums/aspose.cells-product-family/19/showforum.aspx

- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for Java blog: http://www.aspose.com/community/blogs/aspose.cells-product-family/default.aspx

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