• 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

Auto-Fit Columns, Rows While Importing HTML & Get List of Fonts Used in Spreadsheet using Java

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 17.2.0 has been released. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the API. The release notes also list any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for Java. This release offers the metered licensing mechanism in parallel to its traditional licensing. In order to provide the usage based licensing, Aspose.Cells for Java has exposed the Metered class that allows the developers to set public and private keys by calling its setMeteredKey method. The metered licensing system monitors the regular usage of Aspose.Cells API and keep track of the Aspose API licenses. It has exposed the getFonts method for the Workbook class. The Workbook.getFonts method returns the list of individual fonts used to format the cell contents for a given spreadsheet. The list returned by the Workbook.getFonts method is in the form of an array of type com.aspose.cells.Font. The newly exposed method is useful in scenarios where the developers require to extract the list of the fonts used in a particular spreadsheet. The extracted list can further be used to match the available fonts on the machine before rendering the spreadsheet. This is because, if Aspose.Cells APIs are not able to find the required fonts, they try to replace the required font with some other suitable font which is present on the system. By comparing the system’s font list against the fonts used in the spreadsheet, the developers can devise some mechanism to either pick the required fonts from a custom location or substitute a particular font with a list of available fonts. Aspose.Cells for Java has now added the HTMLLoadOptions.AutoFitColsAndRows property which indicates if the API should auto-fit columns and rows while importing the HTML in its object mode. The Boolean type property has the default value as false which means that the cell heights & widths will be imported as they are, however, when the aforementioned property is set to true, the API tries to adjust the column widths and row heights according to the contents. Latest revision of Aspose.Cells for Java has exposed the Cells.textToColumns method in order to mimic the Excel’s Text to Columns feature. Excel provides this feature from the command group Data Tools under the Data tab as highlighted in the snapshot on blog announcement page.This release has exposed the WarningCallback property for the LoadOptions class in order to get or set the warning callbacks. Developers have to implement the IWarningCallback interface in order to get custom warnings in their applications. This revision of Aspose.Cells for Java has exposed Boolean type TrimLeadingBlankRowAndColumn property for the TxtSaveOptions class that indicates whether leading blank rows and columns should be trimmed like Excel does while exporting data to CSV or Tab-delimited formats. The default value of aforementioned property is false. In case the data on the worksheet does not start from the first cell, that is: A1, the Excel application removes the leading blank rows and columns while exporting the data to CSV or Tab-delimited formats, however, Aspose.Cells APIs by default, retain the blank rows & columns for the same sample in order to keep the data location retained if the exported CSV or Tab-delimited files have to be imported back using Aspose.Cells APIs. It has enhanced its core for more stability as well as fixed a few critical bugs. Moreover, there are numerous minor enhancements in order to improve the overall usage of the API.  It enhanced Support to load Excel 2016 chart types, Enhanced HTML rendering engine for shapes & Handled a few exceptions. Below are some important new features, enhancement and bug fixes part of this release.

- Support MS Excel 2016 TreeMap Chart
- Support MS Excel 2016 Waterfall Chart
- Support Converting Text to Columns MS Excel feature
- Data loss while copying range with hidden rows & columns to new workbook and converting it to HTML
- Data loss while copying range with hidden rows & columns to new workbook and converting it to HTML - II
- Data loss while copying range with hidden rows & columns to new workbook and converting it to HTML - III
- Save as PDF does not preserve formatting
- Excel formula is not working and shown as "#DIV/0!"
- Concurrent save issue
- Top and bottom borders of cells are gone while converting to HTML
- Excel formula is not working properly
- Recalculating a number of formulas using Aspose Cells APIs results in "#NUM!" error
- Demo page of math does not load correctly in GridWeb (Java) demo project
- List data validation drop down does not close when reloading data
- PageSetup.BlackAndWhite does not seem to work
- Bug in try catch and re-throw exception where ExceptionType is changed
- Waterfall chart, when calculate() is called, chart series colors are reverted.
- Logarithmic scale bug in Excel causes Aspose Cells to hang
- Vertical Axis bound values changed while rendering spreadsheet to PDF
- Horizontal & vertical axis bound values changed while rendering Chart to EMF
- Hebrew - Space character is missing in PDF
- Chart is vertically suppressed while rendering to image
- DataTable series are missing while exporting chart to image
- Missing underline in title when chart is converted into image
- Background image in chart is wrong
- The space b/w chart's axis (hebrew) labels/legend is missing in the output PDF file
- Contents of the rectangle shape do not render while converting spreadsheet to HTML
- Chart has been changed while converting spreadsheet to HTML
- Formula in chart has changed position while converting spreadsheet to HTML
- Excel to PDF conversion - Arabic text is reversed
- Sheet name gets Upper-cased on inserting formula
- Call to updateSelectedValue changes activeSheetIndex
- Protected view after re-saving an XLS file
- Copying a workbook changes the standardHeight
- Formula in custom validation gets missing when workbook is saved in XLS format
- Excel needs to recover file after simple save through Aspose.Cells
- Spreadsheet becomes corrupted after changing the font for the shapes
- Not able to change the font for a few shapes in the collection
- Password protected Excel file is throwing exception on loading
- The size of the destination workbook is almost double the size of the source workbook
- Copying sheets across workbooks changes the formula
- Unable to read the CheckBox's text value
- GetNames() method is not returning all the names
- The pages of the PDF generated by Aspose.Cells are all black

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.

- Convert Text to Columns using Aspose.Cells
- AutoFit Columns and Rows while loading HTML in Workbook

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
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
    Bookmark Topic Watch Topic
  • New Topic