Aspose.Cells for .NET 21.5 Release Notes

[ ]
Key Summary Category
CELLSNET-47964 Support binding Slicer Report with pivot table and pivot chart New Feature
CELLSNET-48003 Support importing free html with svg image New Feature
CELLSNET-47988 Reffering to spill range with # New Feature
CELLSNET-47996 Support moving existing column in GridWeb New Feature
CELLSNET-48002 Support exporting all worksheets to .csv file. New Feature
CELLSNET-47975 ArgumentException on CalculateFormula method Enhancement
CELLSNET-47984 Support ELSE function when converting xls to xlsx Enhancement
CELLSNET-47989 Support setting global PageOrientationType Enhancement
CELLSNET-48051 PasteType.Values works only when pasted at other than the source range Enhancement
CELLSNET-47956 Hang on calculating formula Performance
CELLSNET-47982 New workbook hang on invalid file Performance
CELLSNET-48012 Improve performance for reading .ods file with large range of validations. Performance
CELLSNET-48039 Infinite loop when saving copied workbook Performance
CELLSNET-44224 WordArt watermark is not rendered in the output PDF file format Bug
CELLSNET-47887 Text inside shape is misplaced Bug
CELLSNET-47920 Some contents are missed in HTML to Excel conversion Bug
CELLSNET-47981 The result of exporting range with merged cells to html is incorrect Bug
CELLSNET-47985 Less number of rows when converting to html Bug
CELLSNET-47987 Move pivot field to Page section or pivot filters Bug
CELLSNET-47997 Additional columns are created after saving file to html Bug
CELLSNET-48009 File is corrupted after saving the workbook with Slicers Bug
CELLSNET-48036 Slicer control is not added based on Page Filter field of Pivot Table Bug
CELLSNET-48044 Exception raises when reading a specific mhtml file Bug
CELLSNET-47118 Incorrect value ‘TRUE’ retrieved from Cell instead of value ‘FALSE’ Bug
CELLSNET-48042 Retrieved formatted cell values are wrong in Excel worksheet Bug
CELLSNET-48031 “Shape to image Error” raises when converting xlsx file to html Bug
CELLSNET-48037 Image is distorted when saving to PDF Bug
CELLSNET-47714 Text in vertical axis overlaps horizontal axis on chart when converting to EMF Bug
CELLSNET-47856 XLSX to PDF conversion issue with pivot tables Bug
CELLSNET-47986 Chart to Image/PDF - wrong output with Waterfall chart type Bug
CELLSNET-48010 Exception when loading an Excel 2010 XLSX files Bug
CELLSNET-48020 Form controls are deleted after Load & Save Excel 95 via Aspose.Cells Bug
CELLSNET-48033 Excel file corrupted after loading and saving Bug
CELLSNET-47957 “Shape to image Error” raises when converting an Excel file to PDF file format Exception
CELLSNET-48027 Invalid parameter exception when converting shape to image Exception
CELLSNET-48029 “Shape to image Error” raises Exception
CELLSNET-48017 “Input string was not in a correct format” exception when importing html file Exception
CELLSNET-48034 Invalid font size in Mht file. Exception
CELLSNET-47977 Exception when parsing the formula ‘[96]Cost Sheet’!$D$6 Exception
CELLSNET-47979 Object reference exception on Save method Exception
CELLSNET-48040 Exception raises while converting XLSB to XLSX Exception
CELLSNET-47980 An error occurred when saving an an Excel file by Aspose.Cells Exception
CELLSNET-48001 Invalid row index exception when calling GetPrintingPageBreaks() Exception
CELLSNET-48022 Unexpected Border.LineType of a cell Exception
CELLSNET-48032 Exception when open document ODS file Exception

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

Adds Slicer.AddPivotConnection(PivotTable pivot) method.

Adds PivotTable connection for slicer.

Adds Slicer.RemovePivotConnection(PivotTable pivot) method.

Removes PivotTable connection of slicer.

Adds TxtSaveOptions.ExportAllSheets property.

Indicates whether exporting all worksheets to the file. The dafaut value is false as MS Excel.

Adds FileFormatType.Numbers09 enum.

Represents the .numbers 09 file format. And FileFormatType.Number will repsents the latest.numbers file format type later.

Adds WorkbookSettings.SetPageOrientationType() method.

Sets the print page orientation type for the whole file.

Deletes obsoleted DataBarAxisPosition.DataBarAxisAutomatic enum.

Use DataBarAxisPosition.Automatic enum instead.

Deletes obsoleted DataBarAxisPosition.DataBarAxisMidpointe num.

Use DataBarAxisPosition.Midpoint enum instead.

Deletes obsoleted DataBarAxisPosition.DataBarAxisNone enum.

Use DataBarAxisPosition.None enum instead.

Deletes obsoleted DataBarBorderType.DataBarBorderNone enum.

Use DataBarBorderType.None enum instead.

Deletes obsoleted DataBarBorderType.DataBarBorderSolid enum.

Use DataBarBorderType.Solid enum instead.

Deletes obsoleted DataBarFillType.DataBarFillGradient enum.

Use DataBarFillType.Gradient enum instead.

Deletes obsoleted DataBarFillType.DataBarFillSolid enum.

Use DataBarFillType.Solid enum instead.

Deletes obsoleted DataBarNegativeColorType.DataBarColor enum.

Use DataBarNegativeColorTypeColor enum instead.

Deletes obsoleted DataBarNegativeColorType.DataBarSameAsPositive enum.

Use DataBarNegativeColorType.SameAsPositive enum instead.

Deletes obsoleted OleObject.FileFormatType enum.

Use OleObject.FileFormatType enum instead.

Deletes obsoleted DynamicFilterType.Februray enum.

Use DynamicFilterType.Feburay enum instead.

Obsoletes FileFormatType.BMP enum and adds FileFormatType.Bmp enum.

Use FileFormatType.Bmp enum instead.

Obsoletes FileFormatType.CSV enum and adds FileFormatType.Csv enum.

Use FileFormatType.Csv enum instead.

Obsoletes FileFormatType.TSV enum and adds FileFormatType.Tsv enum.

Use FileFormatType.Tsv enum instead.

Obsoletes FileFormatType.FODS enum and adds FileFormatType.Fods enum.

Use FileFormatType.Fods enum instead.

Obsoletes FileFormatType.MSEquation enum and adds FileFormatType.MsEquation enum.

Use FileFormatType.MsEquation enum instead.

Obsoletes FileFormatType.ODF enum and adds FileFormatType.Odf enum.

Use FileFormatType.Odf enum instead.

Obsoletes FileFormatType.ODG enum and adds FileFormatType.Odg enum.

Use FileFormatType.Odg enum instead.

Obsoletes FileFormatType.ODP enum and adds FileFormatType.Odp enum.

Use FileFormatType.Odp enum instead.

Obsoletes FileFormatType.ODS enum and adds FileFormatType.Ods enum.

Use FileFormatType.Ods enum instead.

Obsoletes FileFormatType.ODT enum and adds FileFormatType.Odt enum.

Use FileFormatType.Odt enum instead.

Obsoletes FileFormatType.OTP enum and adds FileFormatType.Otp enum.

Use FileFormatType.Otp enum instead.

Obsoletes FileFormatType.OTS enum and adds FileFormatType.Ots enum.

Use FileFormatType.Ots enum instead.

Obsoletes FileFormatType.OTT enum and adds FileFormatType.Ott enum.

Use FileFormatType.Ott enum instead.

Obsoletes FileFormatType.SVG enum and adds FileFormatType.Svg enum.

Use FileFormatType.Svg enum instead.

Obsoletes FileFormatType.Sxc enum and adds FileFormatType.Sxc enum.

Use FileFormatType.Sxc enum instead.

Obsoletes FileFormatType.TIFF enum and adds FileFormatType.Tiff enum.

Use FileFormatType.Tiff enum instead.

Obsoletes FileFormatType.VSD enum and adds FileFormatType.Vsd enum.

Use FileFormatType.Vsd enum instead.

Obsoletes FileFormatType.VSDX enum and adds FileFormatType.Vsdx enum.

Use FileFormatType.Vsdx enum instead.

Obsoletes FileFormatType.XML enum and adds FileFormatType.Xml enum.

Use FileFormatType.Xml enum instead.

Obsoletes FileFormatType.XPS enum and adds FileFormatType.Xps enum.

Use FileFormatType.Xps enum instead.

Obsoletes FileFormatType.Excel2003XML enum and adds FileFormatType.SpreadsheetML enum.

Use FileFormatType.SpreadsheetML enum instead.

Obsoletes SaveFormat.XPS enum and adds SaveFormat.Xps enum.

Use SaveFormat.Xps enum instead.

Obsoletes SaveFormat.TSV enum and adds SaveFormat.Tsv enum.

Use SaveFormat.Tsv enum instead.

Obsoletes SaveFormat.TIFF enum and adds SaveFormat.Tiff enum.

Use SaveFormat.Tiff enum instead.

Obsoletes SaveFormat.SXC enum and adds SaveFormat.Sxc enum.

Use SaveFormat.Sxc enum instead.

Obsoletes SaveFormat.SVG enum and adds SaveFormat.Svg enum.

Use SaveFormat.Svg enum instead.

Obsoletes SaveFormat.ODS enum and adds SaveFormat.Ods enum.

Use SaveFormat.Ods enum instead.

Obsoletes SaveFormat.Fods enum and adds SaveFormat.Fods enum.

Use SaveFormat.Fods enum instead.

Obsoletes SaveFormat.CSV enum and adds SaveFormat.Csv enum.

Use SaveFormat.Csv enum instead.

Obsoletes LoadFormat.CSV enum and adds LoadFormat.Csv enum.

Use LoadFormat.Csv enum instead.

Obsoletes LoadFormat.TSV enum and adds LoadFormat.Tsv enum.

Use LoadFormat.Tsv enum instead.

Obsoletes LoadFormat.ODS enum and adds LoadFormat.Ods enum.

Use LoadFormat.Ods enum instead.

Obsoletes LoadFormat.SXC enum and adds LoadFormat.Sxc enum.

Use LoadFormat.Sxc enum instead.

Obsoletes LoadFormat.FODS enum and adds LoadFormat.Fods enum.

Use LoadFormat.Fods enum instead.

Adds GridCells.MoveRange() method.

Moves the range.

Adds GridCells.InsertRange() method.

Inserts a range with shift option.

Adds GridCells.DeleteRange() method.

Deletes a range with shift option.