• 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 ...
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

Limit the Number of Pages Generated in Excel to PDF & Chart Image Mapping

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 7.7.0 has been released. In this release, we have added a feature that lets you retrieve external data source details. Sometimes, you may want to retrieve details from external data sources, for example if you want to read the SQL connection data. This may include any or all type of data that is required to establish a connection with an SQL Server, such as the server URL, user name, underlying table name, SQL query, query type, the location of the table, etc. In the new version, you can limit the number of pages generated in Excel to PDF conversion. You can print a range of pages to the output PDF file using this new feature. Aspose.Cells allows you to set a limit on how many pages are generated when converting a Microsoft Excel spreadsheet to PDF file format. We have also added a number of enhancements in the new release. We have improved the chart to image and sheet to image modules. This release is also a maintenance release that contains fixes for issues reported in earlier versions. In this release, we have fixed the issues with manipulating charts and shapes. Several other important issues have also been addressed. For example, issues to do with rendering Microsoft Excel file formats, rendering images from Excel worksheets, rendering shapes and controls and exporting Excel workbooks to PDF format have been resolved. A few improvements have also been made to Aspose.Cells for Jav’s formula calculation engine. This release includes plenty of improved features and bug fixes as listed below

- Retrieving SQL Connection Data
- Aspose.Cells saving as TIFF - missing resolution tag
- Chart Image Mapping for all Chart Types
- Conversion to TIFF: setting PhotometricInterpretation tag
- Limiting the number of pages generated when converting to PDF
- Value read after calculation is corrected
- Incorrect output of Style.getCultureCustom() is fixed
- Value read after calculation corrected
- IF Calculation Error is resolved
- Column formattings were now re-saved correctly
- Column formattings were now re-saved correctly
- Shape object in Excel form now getting word-wrapped
AreaChart transparency is fixed and working
- Active-X objects are changed to images
- Cells.MaxDataRow gave corrected value
- While converting XLSX to PDF, one Japanese character gets missing is fixed
- Greater than calculation calcullation
- setPrintGridlines now working in Sheet-to-Image feature
- Charts by page margin now rendered when converting to image/PDF format
- DisplayRightToLeft problem for SheetRender is fixed
- Wrong calculated value of Yield function is fixed
- Cells RTL problem fixed - Sheet to Image

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.

- Retrieving External Data Sources Details
- Limit the Number of Pages Generated - Excel to PDF Conversion

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
Aspose - The .NET and Java component publisher
Phone: 888.277.6734
Fax: 866.810.9465
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
    Bookmark Topic Watch Topic
  • New Topic