• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Junilu Lacar
  • Liutauras Vilda
Sheriffs:
  • Paul Clapham
  • Jeanne Boyarsky
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
Bartenders:
  • Jesse Duncan
  • Frits Walraven
  • Mikalai Zaikin

Wrap/Unwrap Data Label Text of Excel Chart & Cell Data Validation in Java Apps

 
Ranch Hand
Posts: 714
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What is new in this release?

The long awaited version of Aspose.Cells for Java 8.2.1 has been released. Microsoft Excel 2013 allows users to wrap or un-wrap data label text in a chart. The default is the wrapped state. Aspose.Cells provides the setTextWrapped method for the DataLabels class, which can be set to true or false in order to enable or disable the data label text wrapping feature. Moreover, you can use the isTextWrapped method to find out if a data label’s text is already wrapped. Before the release of Aspose.Cells for Java 8.2.1, finding the absolute position of a shape in the worksheet required a lot of mathematical calculation. Even after writing dozens lines of source code developers had to use the “hit & try” mechanism to find out the exact position of a shape. With this release, developers can simply call the Shape.getLeftToCorner and Shape.getTopToCorner methods to get the absolute position in the unit of pixels for a shape. Aspose.Cells for .NET is an easy to use spreadsheet creation, manipulation and conversion API that provides all the features that Microsoft Excel provides. Cell validation is one of the features that spreadsheet designers widely use to stop users from inserting invalid values into a cell. With this release, the API has exposed a simple means to identify if data validation has been applied on a particular cell. Developers can use the Cell.getValidation method to acquire applied validation. Moreover, developers can use the Validations.getValidationInCell method to acquire the validation applied on any cell by providing its row and column indices. In addition to the feature discussed above, it can verify if a given value satisfies the data validation rules for a cell. This feature is useful when developers want to verify if the value entered into a cell satisfies the data validation rule on the fly. Aspose.Cells API has exposed the getValidationValue method for Cell class. If the value in a cell does not satisfy the data validation rules, the Cell.getValidationValue method returns false. It sees the base code tweaked and the core functionality closer to Aspose.Cells for .NET 8.2.1, from which Aspose.Cells for Java is ported. The latest release has fixed numerous problems, and the most notable of these enhancements are the PDF rendering engine to handle shapes more appropriately, tweaked the HTML rendering engine for better layout and improved Chart2Image feature to handle text boxes present in charts. This release includes plenty of improved features and bug fixes as listed below

- Shape absolute positioning
- Add an option to PasteOptions to paste only visible cells from the range
- Conditional formatting is not working when Excel file is converted to HTML
- Extra align attribute in HTML output is improved
- Columns mismatch in HTML output is fixed
- Some borders of cells were extended a bit when converting excel to html
- Linked cell value is improved & now updated from the external workbook
- Protecting Worksheet in Licensed mode causes the MS Excel to crash on preview is now fixed
- Chart.getName() were returning wrong chart name and now are fixed
- Series.hasLeaderLines() issue is fixed and now return correct value
- Embedded PDF was corrupted after merging Workbooks is now fixed
- Some squares are attached to data labels' in the Pie chart in the rendered PDF
- XLSX to Jpeg conversion – Performance is enhanced
- Fixed: Cells run into each other in the PDF
- Aspose.Cells renders the #N/A value differently than MS Excel is now fixed
- Table border is normal instead of bold at 100% zoom
- Fixed: Image quality of the Chart is low - Chart to Image conversion
- Horizontal axis issue is resolved and now showing in chart image
- Fixed: Custom image in data points are not showing in chart image
- Fixed: Chinese characters are not showing in the chart image
- Data labels are in wrong position inside the chart image is now fixed
- Text Box Missing is fixed when the Chart is saved as EMF using ToImage
- Wrong Axis Values is resolved when Chart is saved as EMF using ToImage
- Missing Axis Title is fixed when Chart is saved as EMF using the ToImage
- Inverted z-index in Stacked Area and Bar Chart when exporting to PDF

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.

- Disable Text Wrapping for Data Labels of the Chart
- Verify that Cell Value Satisfies Data Validation Rules

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
- Demos 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
[email]sales@aspose.com[/email]
Phone: 888.277.6734
Fax: 866.810.9465
 
pie. tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic