This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes Blatant Advertising and the fly likes Add Picture in Worksheet Based on Cell Reference & Excel to PDF Rendering Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Other » Blatant Advertising
Bookmark "Add Picture in Worksheet Based on Cell Reference & Excel to PDF Rendering" Watch "Add Picture in Worksheet Based on Cell Reference & Excel to PDF Rendering" New topic
Author

Add Picture in Worksheet Based on Cell Reference & Excel to PDF Rendering

sherazam khan
Ranch Hand

Joined: Mar 10, 2010
Posts: 295
What is new in this release?

The long awaited version of Aspose.Cells for Java 7.5.1 has been released. In this release, we supported inserting pictures based on cell references in a worksheet. The data in the picture is reflected accordingly when you update the source cells range. You can now also detect a category number’s formatting type via the Cell.getNumberCategoryType() method. We have fixed an issue regarding JDK1.7 versions for chart to image, sheet to image and Excel to PDF rendering. Several other important issues and exceptions have been addressed. For example, issues around Microsoft Excel file formats (reading/writing), rendering PivotTables, rendering charts, manipulating worksheets and rendering to PDF format have been resolved. This release includes plenty of improved features and bug fixes as listed below

- Insert a picture based on cell reference
- Detect category type of cell's number formatting
- Cell type returns numeric even if it's a String
- Chart legend text overlapping is fixed
- Pivot table’s refresh problem is resolved when Excel has special characters (other language)
- Excel has unreadable content after refreshing PivotTable and re-saved file is fixed
- URLs in the Excel file are altered in the generated PDF
- Issue with passing in empty value into a Chart Series is resolved
- Chart to Image Quality is now improved
- Refreshing the PivotTable issue is resolved

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.

- Converting Excel to PDF Files
- Insert a Picture based on Cell Reference

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
- Post your technical questions/queries to Aspose.Cells for Java Forum
- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for Java blog

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
 
GeeCON Prague 2014
 
subject: Add Picture in Worksheet Based on Cell Reference & Excel to PDF Rendering