Aspose.Cells for .NET 23.5 Release Notes

CELLSNET-53234Support to update references of external sheet data to local sheet when removing external linksNew Feature
CELLSNET-46133Render Checkbox control as control and not as static pictureNew Feature
CELLSNET-53252Set image desired dimension and keep aspect ratio while converting workbook to imagesNew Feature
CELLSNET-53267AutoFit rows for renderingNew Feature
CELLSNET-53109Support getting PivotArea and PivotFormatNew Feature
CELLSNET-53216The file size of generated pdf is too large while converting to pdfEnhancement
CELLSNET-53181Invalid column index.’ on saving pdfBug
CELLSNET-53192Tick symbol does not appear properly when converting Excel to pdfBug
CELLSNET-53292Abnormal text rotation when converting file to PdfBug
CELLSNET-53293Connection line position error when converting file to PdfBug
CELLSNET-46629Excel to PDF conversion with timeline objectBug
CELLSNET-53124Setting values & calculate corrupts the workbook in recent version of Aspose.CellsBug
CELLSNET-53186Cannot parse the formula which contains a whole column in Apple numbers fileBug
CELLSNET-53208File get broken after formula removalBug
CELLSNET-53228The layout of Legend is not consistent with Excel when chart to imageBug
CELLSNET-53229The Axis color is not consistent with Excel when chart to imageBug
CELLSNET-53235Error plot is not displayBug
CELLSNET-53153Unable to output PDF when converting a file with many imagesBug
CELLSNET-53209A corrupted file is generated when converting a large file to PDFBug
CELLSNET-53286Header image conversion error when converting file to PDFBug
CELLSNET-49624Text wrapping issue during XLSX to HTML conversionBug
CELLSNET-51101Excel to HTML conversion - formatting/contents are distorted and disorderedBug
CELLSNET-53206Export range as HTML with links changes styles/formattingBug
CELLSNET-53133Excel crashes with document saved back from Aspose.CellsBug
CELLSNET-53180Allow text to overflow shape settings to be cleared when saving file to xlsBug
CELLSNET-53185Hole size of doughnut chart lost when saving as ODSBug
CELLSNET-53191TextBox text margin error when saving file to xlsBug
CELLSNET-53207Excel spreadsheet is not rendered to PDF properly (with all data/contents) until saved via MS ExcelBug
CELLSNET-53218Pivot table graph is displayed differently in the converted PDF file after refreshing the pivottableBug
CELLSNET-53258Chart Title Alignment changed from left to center when resaving fileBug
CELLSNET-53260TextBox can be edited after setting protectionBug
CELLSNET-53268Leading zeros are getting removedBug
CELLSNET-53271Font size changes when saving file as xlsBug
CELLSNET-53279The returned font of shape rich formatted text is not same as Excel.Bug
CELLSNET-53283The Font of chart Lenged is not same as ExcelBug
CELLSNET-53285The table should not expand if it contains total row.Bug
CELLSNET-53287The picture in the header should display in grayscale and in two-color(black and white)Bug
CELLSNET-53251Invalid table reference CellsException during roundtripException

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.

Changes behavior of ExternalLinkCollection.Clear(bool)/RemoveAt(int,bool) methods

In old versions, when “updateReferencesAsLocal” is true, we only update those references of external names to local names of current workbook. For references of external sheet data, we updated them as “#REF!” always. From 23.5, if there is one worksheet in current workbook with the same sheet name of the external reference, then the reference will be updated to the local sheet too.

Adds Row.GetEnumerator(bool reversed, bool sync) method

Provide user the ability of traversing Cell in reversed order.

Obsoletes Cells.GetRowEnumerator()

Please use RowCollection.GetEnumerator() instead.

Obsoletes Chart.IsReferedByChart() method and adds Chart.IsCellReferedByChart() method

Please use Chart.IsCellReferedByChart() instead.

Adds SeriesLayoutProperties.IsIntervalLeftClosed property

Indicates whether the interval is closed on the left side.

Adds ShapeTextAlignment.IsLockedText property

Indicates whether the text of the shape is locked.

Removes obsoleted ShapeFormat class and Shape.ShapeFormat

Use Shape.Line and Shape.Fill property instead.

Adds ListColumn.TotalsRowLabel property

Gets and sets the label of totals row in the table.

Adds ListObject.PutCellValue(Int32,Int32,Object,Boolean) method

Sets the value to the cell in the table.

Adds PivotAreaType enum and PivotArea.RuleType property

Gets and sets the type of pivot area in the pivot table.

Adds PivotTableFormat class

Represents the format for the PivotTable.

Adds PivotTableFormatCollection class

Represents all formats for the PivotTable.

Adds PivotTable.PivotFormats property

Gets and adds all formats for the PivotTable.

Adds PivotTable.AutofitColumnWidthOnUpdate property

Indicates whether auot fitting column width when refreshing PivotTable.

Adds PivotAreaFilter and PivotAreaFilterCollection class

Represents the filters to select pivot area in the PivotTable.

Adds PivotArea.Filters property

Represents the filters to select pivot area in the PivotTable.

Adds PivotArea.IsRowGrandIncluded and PivotArea.IsColumnGrandIncluded properties

Indicates wehther including row or column grand total into the area.

Adds PivotArea.AxisType property

Gets and sets the region of the PivotTable to which this rule applies.

Adds PivotArea.IsOutline property

Indicates whether the rule refers to the pivot area that is in outline mode.

Adds ImageOrPrintOptions.SetDesiredSize(int desiredWidth, int desiredHeight, bool keepAspectRatio) method

Sets desired width and height of image, and specify whether to keep aspect ratio of origin image.

Obsoletes ImageOrPrintOptions.SetDesiredSize(int desiredWidth, int desiredHeight) method

Please use ImageOrPrintOptions.SetDesiredSize(desiredWidth, desiredHeight, false) instead.

Adds PdfSaveOptions.Watermark property

Gets or sets watermark to output.

Adds RenderingFont and RenderingWatermark classes

For adding watermark to output of rendering.

Adds AutoFitterOptions.ForRendering property

Indicates whether fit for rendering purpose.

Changes definition of EquationNodeParagraph.EquationHorizontalJustificationType

Change from instance variable to property/method access.