This week's book giveaway is in the Spring forum.
We're giving away four copies of Modern frontends with htmx and have Wim Deblauwe on-line!
See this thread for details.
Win a copy of Modern frontends with htmx this week in the Spring forum!
  • 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
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
  • Mikalai Zaikin

Restrict API Font Location & Export Hidden Worksheet Contents to HTML

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.1.0 has been released. Our team has been hard at work bringing many useful improvements with the latest edition of Aspose.Cells library. You can immediately start exploring the newly added features & enhancements. Before you head to the download section, here is a look at just a few of the biggest features in this month’s release. This release allows developers to restrict the API to Use only One font location. This newly added feature allows developers to restrict the API to use only one font location while rendering spreadsheets. Users may now set the JVM arguments to tell the API where to look for the required fonts or use the System.setProperty method in application code to achieve the same. Aspose.Cells for Java API now provides get/set methods for the ExportHiddenWorksheet property exposed by the HtmlSaveOptions class. The aforesaid Boolean property allows the users to choose whether to render the hidden worksheets or not. The default value is true, meaning the hidden worksheet will be rendered as HTML; switching to false excludes hidden worksheets from the rendering process. More details on this topic can be found on the Prevent Exporting Hidden Worksheet Contents while Saving to HTML in the documentation section. Aspose.Cells has been trying to provide all features that Microsoft Excel offers. One step further, Aspose.Cells has exposed the getter/setters for the DisplayNullString & NullString properties for PivotTable class to handle the Pivot Table option “For empty cells show” offered by the Microsoft Excel. These properties allow the users to set display option for the empty cells inside the Pivot Table to any specified string. Please check the detailed article on Setting Pivot Table Option – For empty cells show. Aspose.Cells for Java 8.1.0 has provided fix for several important issues, such as a couple of problems related to rendering spreadsheets as PDF on Linux platform, exporting spreadsheets to HTML, print quality & page setup. A few of the most important settings are listed below. This release includes plenty of improved features and bug fixes as listed below

- Restrict the API to use the fonts directory specified using CellsHelper.setFontDir method
- lines of diagram are now crisp/sharp
- Get display color defined in custom number format
- Some colors are shown just before column in one table is now fixed
- Images missing is fixed in resultant PDF when spreadsheet is converted on Ubuntu
- Gridlines and Font settings missing is resolved in the output HTML
- Setting print quality of worksheets is now fixed
- PrintCopies are preserved for XLS format but not for XLSX format is now fixed
- Saving Pivottable as mht: exception is resolved
- CellsException is resolved: Map size (0) must be >= 1

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.

- How to Specify TrueType Fonts Location
- Prevent Exporting Hidden Worksheet Contents on Saving to HTML

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

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
    Bookmark Topic Watch Topic
  • New Topic