Elevate your .NET spreadsheet processing capabilities with Aspose.Cells for .NET 24.7 (MSI). This release empowers you to create, manipulate, and convert Excel files precisely and efficiently.

Create and Manipulate Spreadsheets

Generate complex Excel workbooks from scratch, import data from various sources, and apply advanced formatting with ease with the latest C# spreadsheet API version.

Enhanced Charting

Visualize data effectively in your Excel processing solutions with support for chart star outlines, improved TreeMap chart display, and flexible data label customization.

Optimized Calculations

Aspose.Cells for .NET 24.7 helps you accelerate your workflows with significant performance improvements in LET and MAKEARRAY function calculations.

Expanded Functionality

Utilize the new DROP function for data manipulation within your C# and VB.NET spreadsheet manipulation apps, place pictures within cells, and control picture effects.

Platform Compatibility

With the support of the DateOnly and TimeOnly data types (for .NET 6 and above), you can enhance the flexibility of your applications.

Reliable PDF Conversion

Convert Excel files to high-quality PDF documents with accurate text rendering, shape preservation, and improved dashed line support.

Robust Formula Handling

Developers can now benefit from improved formula calculation accuracy, including fixes for complex array functions, RATE function, and shared formulas.

Other Highlights

• Save documents in the Azw3 format for wider compatibility.
• Convert files to various formats using the ConversionUtility class.
• Improved overall performance for various spreadsheet operations.

Bug Fixes

• Resolved numerous issues related to PDF conversion, formula calculations, chart rendering, and more.
• Enhanced data accuracy and reliability across different spreadsheet formats.

Public API and Backwards Incompatible Changes

• Added Cells.ExportDataTable() method behavior changes.
• Introduced AbstractCalculationEngine.ForceRecalculate(string functionName) method.
• Added Picture.PlaceInCell() method.
• Added Shape.IsDecorative property.
• Added JsonLoadOptions.KeptSchema property.
• Added PivotTableCalculateOption class and PivotTable.CalculateData(PivotTableCalculateOption) method.
• Added SlicerCacheItemSortType.Natural enum.
• Added SaveFormat.Azw3 enum and EbookSaveOptions(SaveFormat saveFormat) constructor.
• Deprecated AxisBins.ResetOverflow() and AxisBins.ResetUnderflow() methods.
• Deprecated ChartDataTable properties: HasBorderHorizontal, HasBorderVertical, and HasBorderOutline.
• Added ChartDataTable properties: HasHorizontalBorder, HasVerticalBorder, and HasOutlineBorder.
• Deprecated ChartPoint.InnerRadiusPx property.
• Added ChartPoint.DoughnutInnerRadius property.
• Added DataLabels.ApplyFont() method.
• Added Series.XValuesFormatCode property.
• Deprecated SeriesCollection.ChangeSeriesOrder(Int32,Int32) method.
• Added SeriesCollection.SwapSeries(Int32,Int32) method.
• Added SparklineGroupCollection.Add(Charts.SparklineType) method.
• Removed obsolete ChartDataTable.Background property.
• Added Cells.GetCellsWithPlaceInCellPicture() method.
• Added ConversionUtility class.
• Added Cell.PutValue(DateOnly) and Cell.PutValue(TimeOnly) methods.
• Added GridJsWorkbook.JsonToStream(Stream stream, string filename) and GridJsWorkbook.JsonToStreamByUid(Stream stream, string uid, string filename) methods.

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