Record updated Create Data Validation for GridCell & Set Shadow as Text Effect for Shapes using Java | Dekut


1
Create Data Validation for GridCell & Set Shadow as Text Effect for Shapes using Java
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.

Comments

Who Upvoted this Story

Submit story/link

Login

Search



    • Buy 4000 Karma points
    Click here to buy Karma Points


    How your Dekut app enhances user functionality : Dekut.com will enhance user to like Youtube videos posted on the network. All the likes done by users will be with his own interest. We are not forcing any user to rate any videos. Though they will earn certain karma points based on their user activity.

    Note: All Featured posts will be displayed randomly on top for 30 days only.



    What is Dekut?

    Dekut is all about user powered content .Everything is submitted and voted on by the Dekut community. Share, discover, bookmark, and promote stuff that's important to you. Earn Money from your Dekut account update your Google Adsense Publisher ID under profile.

    Published News