Aspose.Cells for Java 17.12 Release Notes

CELLSJAVA-42479Improved LoadDataFilterOptions enumeration and ambiguity removedEnhancement 
CELLSJAVA-42460CSV Format - D2 and D6 are IsString but Aspose.Cells treats them as IsNumericEnhancement 
CELLSJAVA-42457When XLSX is converted to PDF, some lines in charts are different Bug 
CELLSJAVA-42465Some CSS class declarations are not prefixed in the output HTMLBug 
CELLSJAVA-42456HTML output inconsistent with source - Excel to HTML conversionBug 
CELLSJAVA-42478Importing long value from HSQL DB throws an exceptionBug 
CELLSJAVA-42466Equation is not rendered fine in the output PDFBug 
CELLSJAVA-42475Chart is missing in the output PDF Bug 
CELLSJAVA-42459Datalabels for the chart are missing in the output PDF/imageBug 
CELLSJAVA-42453Chart image is not alike Microsoft ExcelBug 
CELLSJAVA-42447Datalabels display wrong in the output HTML file formatBug 
CELLSJAVA-42481Set combo box name does not work for the source Excel file but if re-saved by Microsoft Excel it works ok Bug 
CELLSJAVA-42476Microsoft Excel Macro-Enabled Worksheet (.xlsm) gets corrupted after opening and saving via Aspose.Cells APIsBug 
CELLSJAVA-42470Setting a Checkbox linked cell causes MS Excel to prompts an error message when opening the output file into itBug 
CELLSJAVA-42462Reading the XLSB file throws the NullPointerExceptionException 

Public API and Backwards Incompatible Changes

The following is a list of 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. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.

Adds HtmlSaveOptions.TableCssId property

Gets and sets the prefix of the type css name such as tr,col,td and so on, they are contained in the table element which has the specific TableCssId attribute. The default value is “”.

Adds Cell.FormulaLocal property

Gets the local formatted formula which may vary according to different locale settings for separators, built in Names, function names, …etc. Those locales are dependent.

Adds GlobalizationSettings.GetLocalFunctionName(string standardName) method

Gets the locale dependent function name according to given standard function name.

Adds GlobalizationSettings.GetLocalBuiltInName(string standardName) method

Gets the locale dependent text for built-in Name according to given standard text.

Adds GlobalizationSettings.ListSeparator property

Gets the separator for list, parameters of function, …etc.

Adds GlobalizationSettings.RowSeparatorOfFormulaArray property

Gets the separator for rows in array data in formula.

Adds GlobalizationSettings.ColumnSeparatorOfFormulaArray property

Gets the separator for the items in array’s row data in formula.

Adds HtmlSaveOptions.ExportWorksheetCSSSeparately property

Indicates whether exporting the worksheet css separately. The default value is false.

Adds LoadDataFilterOptions.Structure to replace LoadDataFilterOptions.None

LoadDataFilterOptions.None gave ambiguous directions and caused confusion. It was designed to denote that load nothing for worksheet data. Now we provide new one (member), i.e., Structure to replace it.

Adds DataLabelShapeType enum

Specifies the preset shape geometry that is to be used for a chart.

Adds DataLabels.ShapeType property

Gets or sets shape type of data label.

Deletes some obsoleted FileFormatType

Deletes obsoleted file format types.

Added WorksheetCollection.RevisionLogs property, RevisionLogCollection class and Revisions.RevisionLog class

Gets setting of revision log.

Adds enum MsoDrawingType.WebExtension

Represents the web extension shape.

Usage Examples

Please check the list of help topics added in the Aspose.Cells Wiki docs: