Great news for Linux developers! Aspose.Cells for C++ 24.7 is here, and it enables impeccable Excel spreadsheet manipulation on the Linux platform. It delivers powerful functionalities like DROP function support, charged-up performance for complex calculations, enhanced chart customizations, and more.

Major Features

• Calculate Spreadsheets Conveniently: Elevate your C++ spreadsheet applications using the newly added DROP function for sophisticated data manipulation.
• Create Aesthetic Charts on Linux: This version empowers complex calculations, including those with LET and MAKEARRAY functions for speedy chart creation.
• Manage Objects Professionally: Incorporate decorative objects into XLSX files and easily place pictures over cells on Linux-powered systems.
• Handle Data Efficiently: Perform accurate data management in C++ spreadsheet manipulation applications with DateOnly while importing custom objects.
• Effective Pivot Table Calculations: Get greater control during pivot table calculation with the newly added PivotTableCalculateOption class.
• Customize Charts with Ease: Manage chart elements with features like swapping series order, optimizing TreeMap chart display, and more with this C++ Excel API version.

Bug Fixes

• Fixed various bugs related to Olap slicer cache, hyperlink handling, XML tag formatting, range visibility, and conditional formatting.
• Resolved exceptions related to pivot table refresh, SORT function calculation, chart rendering, and older Excel file opening.
• Fixed issues related to Excel to PDF conversion, shape text rendering, and text paragraph formatting.
• Refined performance and stability for Workbook.Save, sheet copying with slicers, and data conversion.
• Corrected issues with HTML table creation, right-to-left formatting, and border rendering.
• Addressed formula calculation errors, including RATE, MAKEARRAY, and shared formula issues.
• Enhanced chart rendering accuracy and data preservation during conversions.

Public API and Backwards Incompatible Changes

Added API Members

• AbstractCalculationEngine::ForceRecalculate(const U16String& functionName) method
• Picture::PlaceInCell() method
• Shape::IsDecorative()/Shape::SetIsDecorative(bool value) methods
• JsonLoadOptions::GetKeptSchema()/JsonLoadOptions::SetKeptSchema(bool value) methods
• PivotTableCalculateOption class
• PivotTable::CalculateData(const PivotTableCalculateOption& option) method
• SlicerCacheItemSortType::Natural enum
• SaveFormat::Azw3 enum
• ChartDataTable::GetHasHorizontalBorder()/ChartDataTable::SetHasHorizontalBorder(bool value) methods
• ChartDataTable::GetHasVerticalBorder()/ChartDataTable::SetHasVerticalBorder(bool value) methods
• ChartDataTable::GetHasOutlineBorder()/ChartDataTable::SetHasOutlineBorder(bool value) methods
• ChartPoint::GetDoughnutInnerRadius() method
• DataLabels::ApplyFont() method
• SeriesCollection::SwapSeries(int32_t sourceIndex, int32_t destIndex) method
• SparklineGroupCollection::Add(SparklineType type) method
• Cells.GetCellsWithPlaceInCellPicture() method
• ConversionUtility class

Deprecated API Members

• AxisBins::ResetOverflow() and AxisBins::ResetUnderflow() methods
• GetHasBorderHorizontal(); method
• SetHasBorderHorizontal(bool value); method
• GetHasBorderVertical(); method
• SetHasBorderVertical(bool value); method
• GetHasBorderOutline(); method
• SetHasBorderOutline(bool value); method
• SeriesCollection::ChangeSeriesOrder(int32_t sourceIndex, int32_t destIndex) method

You can view the list of all new features, enhancements, and bug fixes introduced in this release by visiting Aspose.Cells for C++ 24.7 Release Notes.