Various improvements and bug fixes are in focus in version 23.11 of the Python Excel API. It introduces support for generating PDFs compliant with versions 1.5 and 1.6, addressing a common developer need. Additionally, we’ve added enhancements to formula calculations, pivot tables, and HTML conversion, ensuring a more robust spreadsheet processing experience.

Key Highlights

• Enhanced PDF Compatibility: Programatically generate PDFs compatible with PDF versions 1.5 and 1.6 within your Python Excel to PDF conversion apps.
• Default Font Color: Developers can apply the default font color by choosing a final static color.
• Control Over Formula Calculation: A CalculateFormula property is added for controlling formula recalculation during HTML saving.
• HTML Conversion Upgrades: Different issues related to the content display, data display errors, and date format inconsistencies have been addressed.

Other Highlights

• PivotGlobalizationSettings: We have added new methods to retrieve localized date/time text for pivot tables.
• PivotFieldGroupSettings: A new class and related properties for managing pivot field groups is introduced.
• Optimized Ranges: AddHyperlink() method for is added for creating hyperlinks within ranges.
• Bug Fixes: We have implemented numerous fixes and improvements in formula calculation, LOOKUP function behavior, sheet-to-image rendering, and more.

Public API and Backwards Incompatible Changes

Added API Members

We have added several classes, methods and properties in this version. Some of these are:

• CustomPiovtFieldGroupItem and PivotDiscreteGroupSettings classes
• PivotNumbericRangeGroupSettings class
• ImageOrPrintOptions.EmfRenderSetting property
• PdfCompliance.Pdf14, Pdf15, Pdf16, Pdf17 enum
• Range.AddHyperlink() method
• CellsHelper.NeedQuoteInFormula() method
• HtmlSaveOptions.CalculateFormula property

Obsolete API Members

We have made several methods and properties obsolete in this version. Some of these are:

• PivotTable.SetUngroup() method is obsolete, use PivotField.Ungroup() method instead
• PivotTable.SetAutoGroupField() and SetManualGroupField() methods
• Legend.LegendEntriesLabels property is obsolete, use Legend.GetLegendLabels() method instead
• PdfCompliance.None enum

You can view the list of all new features, enhancements, and bug fixes introduced in this release by visiting Aspose.Cells for Python via Java 23.11 Release Notes.