Aspose.Cells for .NET 24.7 (DLLs only) provides a powerful and flexible API for working with Excel spreadsheets in your cross-platform C# applications without needing an MSI installer. This release incorporates a wide range of improvements to enhance your spreadsheet processing capabilities.
Supercharged Spreadsheet Processing in .NET
Create complex Excel workbooks from scratch, fetch data from different sources, and apply advanced formatting easily with the latest C# spreadsheet API version.
Enriched Charting
Perform data visualization effectively in your .NET Excel processing solutions with chart star outlines support, better TreeMap
chart display, and flexible data label customization across Windows, Linux, and macOS systems.
Refined Calculations
Aspose.Cells for .NET 24.7 allows you to speed up your workflows with noticeable performance enhancements in LET
and MAKEARRAY
function calculations.
Broader Functionality
Leverage the newly added DROP
function for data manipulation in your C# and VB.NET spreadsheet manipulation applications, place photos within cells, and control image effects.
Compatibility Boost
Using the DateOnly
and TimeOnly
data types support (for .NET 6 and above), users can elevate the flexibility of their multi-platform applications.
Accurate PDF Conversion in C# Apps
Transform Excel spreadsheets to professional-quality PDF documents with precise text rendering, shape preservation, and refined dashed line support.
You can now experience optimized formula calculation accuracy, including fixes for complex array functions, RATE function, and shared formulas.
Other Highlights
- Convert files to various formats using the
ConversionUtility
class. - Improved overall performance for various spreadsheet operations.
- Save documents in the Azw3 format for wider compatibility.
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.