Aspose.Cells for .NET 17.4.0 Release Notes

CELLSNET-45216Support “Lock project for viewing” Protection option in VbaProject PropertiesNew Feature 
CELLSNET-44219Password protect the VBA projectNew Feature 
CELLSNET-45246Implement Sort Warning feature - Sort anything that looks like a numberNew Feature 
CELLSNET-45278Function SetColumnHeaderToolTip(int colIndex, string toolTip) missing in newer APIs set - Aspose.Cells.GridWebNew Feature 
CELLSNET-45201Change filter list to multiple checkbox selection list for GridWebNew Feature 
CELLSNET-42557PivotTable Grouping and Pivot Report Filter selection disappear when loading in GridWebNew Feature 
CELLSNET-45281Sparklines disappear after rendering to PDFEnhancement 
CELLSNET-45280Sparklines disappear after re-saving the fileEnhancement 
CELLSNET-44438OutOfMemoryException while saving CSV to PDFPerformance
CELLSNET-45231Format tag in the SpreadsheetML content keeps hanging on loadingPerformance
CELLSNET-45219Remove some calls to string.ToUpper() method (if possible) in the source codePerformance
CELLSNET-45242Some shapes are separated/distorted and dim in the rendered PDF fileBug 
CELLSNET-45275Removing worksheet causes to save a corrupt XLSMBug 
CELLSNET-45262Saving worksheet as HTML with overflowed text in cellsBug 
CELLSNET-45248Some text is overlapping or invisible and vertical alignment is not right in Excel to HTML renderingBug 
CELLSNET-45229When HTML is saved as XLSX, text layout is different Bug 
CELLSNET-45228When HTML is saved as XLSX, text format is changed Bug 
CELLSNET-45227When HTML is saved as XLSX, part of content is missing Bug 
CELLSNET-45195When loading HTML and save it as XLSX, paragraphs are missing and changed Bug 
CELLSNET-45254Issue with Pivot Filters TextBug 
CELLSNET-45267Number format does not work correctly in the Pivot TableBug 
CELLSNET-45170Some text is overlapping with other cells and vertical alignment is not rightBug 
CELLSNET-45263Problem while importing dates around 1900 from CSV fileBug 
CELLSNET-45283Font is bolder in the output PDF file when setting the PDF optimization type to “MinimumSize”Bug 
CELLSNET-45265Font changed in the output image/PDFBug 
CELLSNET-45235Slight Vertical Alignment Difference between Excel and Aspose.Cells PdfsBug 
CELLSNET-45272Font is different and percentage sign is missing in the output PDF fileBug 
CELLSNET-45233Charts have “Axis Title”Bug 
CELLSNET-452323D Column charts are not rendered fine in the output PDF fileBug 
CELLSNET-45188Category axis labels are not showing of chart in the output PDFBug 
CELLSNET-45292Deleting worksheet in XLSM leaves behind a remnant sheet in vba projectBug 
CELLSNET-45286When specific file is saved, the output is corrupted Bug 
CELLSNET-45285Excel documents gets corrupted after SaveBug 
CELLSNET-45261Formula ‘DAYS’ in Excel tables gets replaced with a NamedRangeBug 
CELLSNET-45260Setting LightAngle value corrupts Excel fileBug 
CELLSNET-45253Inserting rows breaking formulas linking to external workbookBug 
CELLSNET-45252The table style was changed (The table lines are missing) after re-save in a specific XLSBug 
CELLSNET-45249Aspose.Cells sorts fine but formulas are converted to valuesBug 
CELLSNET-45244Cells range deletion with shift up option does not style on cellsBug 
CELLSNET-45241Workbook gets corrupt after open and saveBug 
CELLSNET-45237Datatable is not being shifted down properly in an XLSXBug 
CELLSNET-45236Cannot read worksheets of a password protected XLSX fileBug 
CELLSNET-45234Cells.DeleteRange() is not working properlyBug 
CELLSNET-45226Cannot update OleObject.ObjectSourceFullName propertyBug 
CELLSNET-45225Cells range deletion with shift up option does not decrease hyperlink countBug 
CELLSNET-45220Incorrect hyperlinks count when duplicating the single row data in an XLSBug 
CELLSNET-45215Moving the array in Input2.xlsx results in an unopenable file that crashes Excel on startupBug 
CELLSNET-45214Reference in the array does not update when the referenced cells are moved in Input.xlsxBug 
CELLSNET-45191Replace background for shape doesn’t workBug 
CELLSNET-45183The “Locked” attribute of ActiveX control (ComboBox) is not changed while protecting worksheetBug 
CELLSNET-45276Horizontal scrollbar lost (in Google chrome) in GridWebBug 
CELLSNET-45273Big lags (in scrolling, selecting a cell, etc.) when using long list of merged cellsBug 
CELLSNET-45257The alignment of the cells lost when inserting/pasting values into the cellsBug 
CELLSNET-45251Percentage value changes to NaNBug 
CELLSNET-44555Problem setting the value of a cell with percentage formatBug 
CELLSNET-44975Formatting error inside shapes texts when Excel is converted to PDF Exception 
CELLSNET-45266VbaProject.Sign causes an exceptionException 
CELLSNET-45239Re-adding a picture to the same XLS throws a Null Reference errorException 

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 VbaProject.Protect(bool islockedForViewing,string password) method

Protects or unprotects the VBA project.

Adds VbaProject.IsProtected property

Indicates whether the vba project is protected.

Adds VbaProject.IslockedForViewing property

Indicates whether the VBA project is locked for viewing.

Adds CopyOptions.ExtendToAdjacentRange property

Indicates whether extend ranges when copying the range to adjacent range.


 Workbook wb = new Workbook("sample.xlsx"); 

Worksheet ws = wb.Worksheets["Sheet1"]; 

CopyOptions co = new CopyOptions(); 

co.ExtendToAdjacentRange = true; 

Cells cells = ws.Cells; 

cells.CopyRows(cells, 0, 1, 1, co); 

Deletes obsoleted Workbook.ValidateFormula(string formula) method

Adds DataSorter.SortAsNumber property

Indicates whether sorting anything that looks like a number.

Usage Examples

Please check the list of help topics added in the Aspose.Cells Wiki docs: