Aspose.Cells for .NET 18.10 Release Notes

CELLSNET-46311Get connection points from shapesNew Feature 
CELLSNET-46194Change columns’ fixed size width (i.e., pt/px) into scalable unit like “em” or “percent”Enhancement 
CELLSNET-46383Issue with the image source when rendering Excel to HTML file formatBug 
CELLSNET-46367Font size changed from 6.5 to 6 while converting XLSX to HTML  Bug 
CELLSNET-46353Recognize empty tags likewhile converting HTML to MS Excel file format  Bug 
CELLSNET-46341Sub-Total missing when rows collapsed after refreshBug 
CELLSNET-46330Issue in number fields while calling the Worksheet.AutoFitColumns()Bug 
CELLSNET-42681XLSB file gets corrupt on opening and savingBug 
CELLSNET-46382CSV import creates incorrect formatting using PreferredParsersBug 
CELLSNET-46338“_xll” attached in front of formula nameBug 
CELLSNET-46334Named range formula ("=GET.CELL") not properly created in German localeBug 
CELLSNET-46321Escape character is displayed as it is in PDFBug 
CELLSNET-46376PDF output page size(and margins) doesn’t match MS Excel outputBug 
CELLSNET-46373Height of image in header truncated along with broken layout during XLSM->PDF conversionBug 
CELLSNET-46349Image not repeating properly when print titles are set for rows and columnsBug 
CELLSNET-46358Rendering image from a simple chart takes all resources and then raises exceptionBug 
CELLSNET-46343Accessing visibility properties changed the visibility of the chart in the re-saved outputBug 
CELLSNET-46390SourceFullName property of OLE Object is empty while accessing in XLSBBug 
CELLSNET-46385Header picture/shape is not rendered correctly when re-saving an XLSX fileBug 
CELLSNET-46384Difference in OLE Objects before and after saving the XLSB fileBug 
CELLSNET-46378Phonetic guide missing after copy and saveBug 
CELLSNET-46375Resizing tables changes format of cellsBug 
CELLSNET-46374Wrong detection of cell foreground and background colorBug 
CELLSNET-46369Autofit happens automatically to the hidden rows when rows are auto filteredBug 
CELLSNET-46368Custom scheme ’m-files://…’ is converted in document save-operationBug 
CELLSNET-46357XLSB files cannot be opened using LoadDataFilterOption other than LoadDataFilterOption.AllBug 
CELLSNET-46356Formula missing single quoteBug 
CELLSNET-46351LoadDataFilterOptions.SheetSettings not working for XLSB filesBug 
CELLSNET-46350View is changed to protected while converting XLS -> XLSM -> XLSBug 
CELLSNET-46347XLSX file is corrupt after converting from an XML (SpreadsheetML) fileBug 
CELLSNET-46344Smart Marker does not evaluate ISBLANK properlyBug 
CELLSNET-46319FilterOperatorType.Contains missing from APIBug 
CELLSNET-46354Exception occurred when loading an Excel fileException 

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 HtmlSaveOptions.WidthScalable property

Indicates whether using scalable unit to describe the column width when exporting file to HTML. The default value is false.

Adds WorkbookDesigner.UpdateEmptyStringAsNull property

Indicates whether processing the empty string value as null.

Updates the returned value of DocumentProperty.ToDateTime() method, BuiltInDocumentPropertyCollection.CreatedTime, BuiltInDocumentPropertyCollection.LastPrinted and BuiltInDocumentPropertyCollection.LastSavedTime properties.

Returns the time in local timezone.

Requires stronger constraint for user’s input for FormatCondition.Formula1/Formula2

The plain input string cannot be determined whether it should refer to a Name reference or it is just a constant string value. So, now we require the formula must start with ‘=’ sign. For plain string value “sss”, please use format like “="sss"”.