Aspose.Cells for .NET 18.4 Release Notes

CELLSNET-46045Set Pdf Page size while using Chart.ToPdf methodNew Feature 
CELLSNET-45590Support rendering Histogram MS Excel 2016 ChartNew Feature 
CELLSNET-46007Add an equivalent property to the “FilterMode” property of MS Excel Worksheet object (VBA)New Feature 
CELLSNET-46026Support additional cells modification in cellModifiedOnAjax -  Aspose.Cells.GridWebNew Feature 
CELLSNET-46013New cross type with hiding overlayed content when saving as HTMLEnhancement 
CELLSNET-45965Ability to process standard LINK element during backward conversionEnhancement 
CELLSNET-46032Do not generate single page blank PDF when Excel file is emptyEnhancement 
CELLSNET-46027Excel to PDF rendering - Header/footer problemEnhancement 
CELLSNET-45970When auto-fit a column, Aspose.Cells do not consider the row height when the cell is text wrappedEnhancement 
CELLSNET-44985Issue with auto-fit columns operation with wrapping text onEnhancement 
CELLSNET-42701AutoFitColumns’ wrap text issueEnhancement 
CELLSNET-46005Writings reversed for different sheets in the output PDF file formatBug 
CELLSNET-45958Incorrect formatting when saving XLSX as HTMLBug 
CELLSNET-45907Missing values in the rendering of chartBug 
CELLSNET-46034Cannot remove PivotTables (whose data source is external) from XLS file formatBug 
CELLSNET-46016Excel file becomes corrupt after refreshing PivotTableBug 
CELLSNET-45988Refreshing Pivot Table in “Sample2.xlsx” generates corrupt Excel fileBug 
CELLSNET-46011Workbook.Calculation gives wrong value for cell F155Bug 
CELLSNET-46001Wrong evaluation of DateTime values when calculating DateTime functionsBug 
CELLSNET-46000Shrink to fit on cells made text become slightly smaller than normal in the rendered imageBug 
CELLSNET-45998Margins are still there when all margins are set to zero and OnePagePerSheet is set to true.Bug 
CELLSNET-45990PDF output varies regarding the optimization typeBug 
CELLSNET-46053“Input string was not in a correct format” when calculating chart in the template fileBug 
CELLSNET-46029Issues with custom data filteringBug 
CELLSNET-46024During save OriginalDataSource with slash changed to backslashBug 
CELLSNET-46018Images and diagrams are missing when saving OTS fileBug 
CELLSNET-46003ListFillRange in ActiveX ComboBox not updatingBug 
CELLSNET-46002Page header rows are displayed only on the first page in output PDF Bug 
CELLSNET-45996Bug at A30 - Newlines are removedBug 
CELLSNET-45995Bug at C32 - White space is removedBug 
CELLSNET-45968Workbook.CalculateFormula changed “#REF!” to “#NAME?”Bug 
CELLSNET-46031The column is missing in GridWeb output after binding a custom class Bug 
CELLSNET-46025Data validation always failed in Aspose.Cells.GridWebBug 
CELLSNET-46020Cell value is not correct when importing an Excel file into Aspose.Cells.GridWebBug 
CELLSNET-46019Shapes position is not correct in Aspose.Cells.GridWebBug 
CELLSNET-46017After inserting row or column, worksheet become empty with one row/column in countBug 
CELLSNET-46009Values and controls are lost when cells are edited e.g. I13, I14, I15 etc.Bug 
CELLSNET-45994Display the validation input message in GridWebBug 
CELLSNET-45991Scrolling to the bottom row and clicking the group button does not collapse the rowsBug 
CELLSNET-45919Controls (options buttons and scrollbars) are not rendered when importing an Excel filBug 
CELLSNET-45975Cells in range L10:L12 cannot be mergedException 
CELLSNET-46008Invalid string in the file - exception occurs on opening the XLS fileException 
CELLSNET-46004Exception “Input string was not in a correct format” on opening an XLSX fileException 
CELLSNET-45992Aspose.Cells 18.2: Opening particular XLS file causes ArgumentOutOfRangeExceptionException 

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 new item “CrossHideRight” for HtmlCrossType enum

Displays HTML cross string and hides the right string when the text is overlapped.

Adds new item “TSV” for LoadFormat, SaveFormat and FileFormatType enums

Represents a TSV(Tab-separated values) file, same with the “TabDelimited”.

Adds enum ImageType

Represents the type of the image.

Adds MsoTextFrame.RotateTextWithShape and ShapeTextAlignment.RotateTextWithShape properties

Indicates whether the text rotates with the shape.

Adds OleObject.ImageType and Picture.ImageType properties

Gets the image format of the picture.

Obsoletes OleObject.ImageFormat and Picture.ImageFormat properties

Use OleObject.ImageType and Picture.ImageType properties instead.

Adds an overload AutoFilter.Refresh (System.Boolean) method

Gets all hidden rows’s indexes and refreshes the auto-filter.

Adds overload Cell.GetHtmlString(System.Boolean) method

Gets the HTML string which contains data and some formats in this cell.

Adds BuiltInDocumentPropertyCollection.Language property

Gets and sets the language of the file.

Adds Style.SetPatternColor(Aspose.Cells.BackgroundType,System.Drawing.Color,System.Drawing.Color)

Sets the pattern and color of the cell

Adds ChartPoint.XValueType property

Gets X value type of the chart point.

Adds ChartPoint.YValueType property

Gets Y value type of the chart point.

Adds enum PageLayoutAlignmentType

Represents page layout alignment types.

Adds Chart.ToPdf(System.IO.Stream,System.Single,System.Single,Aspose.Cells.PageLayoutAlignmentType,Aspose.Cells.PageLayoutAlignmentType) method

Creates the chart’s PDF with desired page size and saves it to a stream.

Adds Chart.ToPdf(System.String,System.Single,System.Single,Aspose.Cells.PageLayoutAlignmentType,Aspose.Cells.PageLayoutAlignmentType) method

Creates the chart’s PDF with desired page size and saves it to a file.

Adds PdfSaveOptions.OutputBlankPageWhenNothingToPrint property

Indicates whether to output a blank page when there is nothing to print.