Aspose.Cells for Android via Java 23.12 Release Notes

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 Android via Java. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.

Adds GlobalizationSettings.GetDefaultSheetName() method

Supports custom sheet name for automatically added worksheets.

Adds MsoFormatPicture.TopCropInch/BottomCropInch/LeftCropInch/RightCropInch properties.

Gets and sets the crop size of picture in unit of inches.

Adds Range.IsBlank() method.

Indicates whether the range does not contain any value.

Adds Range.AddHyperlink(String,String,String) method

Adds a hyperlink to a range.

Adds VbaModuleCollection.AddUserForm() method

Adds user form for VBA project.

Adds WorksheetCollection.AddCopy(Worksheet[], string[]) method

Supports adding and copying some worksheets together.

Changes the constant values for FormatConditionType

Constants defined for FormatConditionType have been changed. User’s applications need to be re-compiled with the new version of Aspose.Cells.

Adds HtmlSaveOptions.CalculateFormula property

If formulas in workbook need to be re-calculated to get correct result for generated html files, user may call Workbook.CalculateFormula() manually before Workbook.Save(), or specify this property as true to force formulas to be re-calculated automatically while saving HTML files.

Adds HtmlSaveOptions.FormatDataIgnoreColumnWidth property

Indicating whether show the whole formatted data of cell when overflowing the column.

Adds CellsHelper.NeedQuoteInFormula() method

Check whether the name of the sheet should be enclosed in single quotes when adding reference to the sheet.

Adds and obsoletes some ErrorCheckType enum

Use new enums instead.

Adds methods: GetShortTextOf12Months(),GetTextOf4Quaters(),GetTextOfYears(),GetTextOfQuarters(),GetTextOfMonths(), GetTextOfDays(),GetTextOfHours(),GetTextOfMinutes(),GetTextOfSeconds() and GetTextOfRange() of PivotGlobalizationSettings

Gets the local text of date time for pivot table.

Adds PivotFieldGroupSettings class and PivotField.GroupSettings property; obsoletes SxRng class and PivotField.SxRng property

Used PivotField.GroupSettings property instead.

Obsoletes PivotTable.SetUngroup() method and adds PivotField.Ungroup() method

Please use PivotField.Ungroup() method instead to ungroup the pivot field.

Obsoletes PivotTable.SetAutoGroupField() and SetManualGroupField() methods

Please use PivotField.GroupBy() method.

Adds PivotField.GroupBy() methods

Group the pivot field.

Adds Range.AddHyperlink() method

Add a hyperlink for the range.

Adds PivotFieldGroupType enum

Represents the group type of pivot field.

Adds CustomPiovtFieldGroupItem and PivotDiscreteGroupSettings classes

Represents the discrete group of the pivot field.

Adds PivotGroupByType.Numbers and obsoletes PivotGroupByType.RangeOfValues enum

Use PivotGroupByType.Numbers enum instead to group the pivot field by numberic values.

Adds PivotNumbericRangeGroupSettings class

Represents the settings of numberic groups for the pivot field.

Adds PivotDateTimeRangeGroupSettings class

Represents the settings of date time groups for the pivot field.

Adds ImageOrPrintOptions.EmfRenderSetting property

Setting for rendering Emf metafile while rendering to image.

Adds XpsSaveOptions.EmfRenderSetting property

Setting for rendering Emf metafile while rendering to XPS.

Adds PdfCompliance.Pdf14, Pdf15, Pdf16, Pdf17 enum

Supports to render to Pdf format compatible with PDF 1.4, 1.5, 1.6, 1.7.

Obsoletes PdfCompliance.None enum

Please use PdfCompliance.Pdf14 instead.

Obsoletes Legend.LegendEntriesLabels property and adds Legend.GetLegendLabels() method

Please use Legend.GetLegendLabels() method instead.

Adds PdfCompliance.Pdf2b, Pdf2u, Pdf2a, Pdf3b, Pdf3u, Pdf3a enum

Supports to render to Pdf format compatible with PDF/A-2b,2u,2a(ISO 19005-2) and PDF/A-3b,3u,3a(ISO 19005-2).

Obsoletes Axis.AxisLabels property and adds Axis.GetAxisTexts() method

Please use Axis.GetAxisTexts() method instead.

Obsoletes Cells.MergedCells property and adds Cells.GetMergedAreas() method

Use Cells.GetMergedAreas() method instead.

Obsoletes Comment.GetCharacters() method and adds Comment.GetRichFormattings() method

Use Comment.GetRichFormattings() method instead.

Obsoletes Shape.GetCharacters() method and adds Shape.GetRichFormattings() method

Use Shape.GetRichFormattings() method instead.

Obsoletes PivotField.GetPivotFilters() method and adds PivotField.GetFilters() method

Use PivotField.GetFilters() method instead.

Obsoletes Range.Union() method and adds Range.UnionRange() method

Use Range.UnionRange() method instead.

Adds WorkbookDesigner.SetJsonDataSource() method

Sets json string as data source of smart markers.

Adds Style.IsNumberFormatApplied property

Indicates whether number format is applied.

Adds Style.IsFontApplied property

Indicates whether font format is applied.

Adds Style.IsAlignmentApplied property

Indicates whether alignment format is applied.

Adds Style.IsBorderApplied property

Indicates whether border format is applied.

Adds Style.IsFillApplied property

Indicates whether fill format is applied.

Adds Style.IsProtectionApplied property

Indicates whether protection format is applied.

Adds PptxSaveOptions.IgnoreHiddenRows property

Indicates whether ignore hidden rows when converting Excel to PowerPoint

Adds PptxSaveOptions.AdjustFontSizeForRowType property

Represents what type of line needs to be adjusted size of font if height of row is small.

Adds HtmlSaveOptions.IsJsBrowserCompatible property

Indicates whether JavaScript is compatible with browsers that do not support JavaScript.

Adds HtmlSaveOptions.IsMobileCompatible property

Indicates whether the output HTML is compatible with mobile devices.