Create Data Validation for GridCell & Set Shadow as Text Effect for Shapes using Java

What’s new in this release?

We are pleased to announce the new release of Aspose.Cells for Java 8.8.1. This month’s release includes new features, enhancements and bug fixes that further improve the overall stability and usability of the API. As per default behaviour, Aspose.Cells APIs load everything from the template file into its own object model, providing access to every aspect of the spreadsheet. There could be scenarios where the user does not want to load everything but specific objects, such as charts or shapes. This can be achieved using the newly exposed enumeration and a property. Aspose.Cells APIs have added the enumeration LoadDataFilterOptions which can be used to make the selection of data type to be loaded from the template file. Filtering data at the time of loading can improve the performance tremendously, especially when used with LightCells APIs. There are several selections that a user can make in order to customize the loading process by specifying the appropriate value from LoadDataFilterOptions. Aspose.Cells APIs have already provided the facility to render charts to PDF while using the Chart.toPdf method. With this release, the API has exposed another overloaded version of the said method that could accept an instance of OutputStream, allowing the users to save the chart’s PDF in an instance of ByteArrayOutputStream. It provides the ability to set the shadow as text effects for any shape such as TextBox. The said feature has been provided by exposing the Shape.TextBody property. This property presents the settings of the shape’s text and returns FontSetting objects which in turn can be used to set the shadow via ShadowEffect.PresetType property. It has exposed the GridCell.createValidation & GridCell.removeValidation methods to add and remove the data validation from the GridCell. Please note, the Aspose.Cells.GridWeb also provides the facility to add data validation rules while using the ValidationCollection.add method, however, this approach requires to specify the cell range on which data validation rule has to be applied. If the requirement is to specify the data validation rule for just one cell then the GridCell.createValidation method can be used without specifying the cell range. The most notable enhancements in this release includes, Ability to create custom command buttons for Aspose.Cells.GridWeb for Java, Ability to directly calculate the custom functions without inserting the function in worksheet and ability to export DataBar, ColorScale and IconSet of conditional formatting to HTML format. This release includes several enhanced features and bug fixes as listed below

• Exporting DataBars based on Conditional Formatting to HTML
• Support ColorScale, DataBar, IconSet while exporting XLSX to HTML
• Worksheet has no method calcualteFormula(String formula, CalculationOptions options)
• Performance bottleneck on Workbook.calculateFormula
• Setting ShowAllItems for PivotField does not seem to take effect
• Text is getting congested and overlapping in the EMF image
• Text labels are overlapping in the EMF image
• Exception is thrown on copying workbook
• Spreadsheet to HTML: Alignment of Text in a Shape is wrong after copying theme from source spreadsheet
• Graph is not rendered in the output PDF
• X-axis labels missing in Chart's PDF
• Incorrect number-format of X-axis labels in Chart's PDF
• Long hyphens don't display appropriately in the output PDF/Image for the chart
• Horizontal Grid-Lines of chart are not appearing properly in the output PDF
• Few chart bars are missing while rendering Worksheet-to-Image
• Add Chart.toPDF(java.io.OutputStream, com.aspose.cells.PdfSaveOptions)
• A named range is created when Cells.copyRow() method is used within a named range
• When applying autoSizeColumns on the sheet, the column is not widened properly
• CellsException while saving spreadsheet to PDF
• How to create custom command buttons in GridWeb (JAVA)
• GridCell.createValidation() method is missing in the GridWeb
• Scroll does not stop sometimes - Aspose.Cells.GridWeb for JAVA

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

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


Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
http://www.aspose.com/
[email protected]
Phone: 888.277.6734
Fax: 866.810.9465