# Release Notes for Version 10.40.20162.0

undefined

## Content

This set of release notes includes enhancements and version details.

## Changes from the Previous Release

* The LockBackColor, LockForeColor, and LockFont properties have been added to the Cell, Column, Row, NamedStyle, and StyleInfo classes.
* The OpenExcel, IsExcelFile, and GetExcelSheetNames methods no longer generate an error if the files are also opened in Excel.
* Additional options have been added to the GetPreferredColumnWidth and GetPreferredRowHeight methods.

## Enhancements from the Previous Release

* Control Features
    * The MoveToPreviousCellThenControl and MoveToNextCellThenControl actions have been added.
    * A status bar can now be added to the component.
    * A custom sort dialog can now be used with enhanced row filtering.
* New Charts
    * The Pareto and Histogram charts have been added.
    * The Waterfall chart has been added.
    * The Funnel chart has been added.
    * The BoxWhisker chart has been added.
    * The Sunburst chart has been added.
    * The Treemap chart has been added.
* New Cell Types
    * The GcCharMask Cell has been added.
    * The GcComboBox Cell has been added.
    * The GcMask Cell has been added.
    * The GcNumber Cell has been added.
    * The GcTextBox Cell has been added.
    * The GcTimeSpan Cell has been added.
* Printing
    * The print header and footer options have a sheet name command.
    * The PdfSecurity property has been added to the PrintInfo class.
* Spread Designer
    * The Footer Editor has been added.
* Properties and Methods
    * The AdvanceNext property has been added to the Advance event.
    * The AutoAdvance property has been added.
    * The AllowCellContentFloat property has been added.
    * The AutoSortEnhancedContextMenu property has been added.
    * The AutoSortEnhancedMode property has been added.
    * The CellSpanSelectionPolicy property has been added.
    * The StatusBarVisible property has been added.
    * The AutofitColumnOptions and AutofitRowOptions properties have been added.
* Events
    * The Sorted and Sorting events have been added.

## Resolved Issues

* Selecting a barcode cell now works correctly. [217481]
* The TextTipPolicy property now works correctly. [217479]
* Searching now works correctly. [217477]
* Using the OpenExcel method to save to a stream now works correctly with conditional formatting. [217476]
* Copying using the corner cell now works correctly. [214959]
* The FormulaChanged event now works correctly. [214824]
* Right-aligned text now overflows to adjacent cells. [211468]
* Using Ctrl + X no longer causes issues with the reference style. [211466]
* The SetColumnVisible method now works correctly. [211465]
* The horizontal and vertical scroll tips now appear correctly. [211464]
* The DragFillDataOnly and AllowUndo properties now work correctly. [211133]
* Print preview works correctly with frozen columns. [211022]
* The print header and footer are now correct when exporting to an Excel-formatted file. [208445]

## File Versions

Spread for WinForms installs the following file versions on your system. See [Installed Files](/spreadnet/docs/latest/readme/installedfiles/installfilesspwin) for the exact location of these files.

| **File** | **Version** |
| ---- | ------- |
| FarPoint.Win.Spread.dll | 10.40.20162.0 |
| FarPoint.Win.Spread.Html.dll | 10.40.20162.0 |
| FarPoint.Win.dll | 10.40.20162.0 |
| FarPoint.Win.Design.dll | 10.40.20162.0 |
| FarPoint.Win.Spread.Design.dll | 10.40.20162.0 |
| FarPoint.PluginCalendar.WinForms.dll | 10.40.20162.0 |
| FarPoint.SpreadDesigner.exe | 10.40.20162.0 |
| FarPoint.CalcEngine.dll | 10.40.20162.0 |
| FarPoint.Excel.dll | 10.40.20162.0 |
| FarPoint.Win.Ink.dll | 10.40.20162.0 |
| FarPoint.Win.TextRenderer.dll | 10.40.20162.0 |
| FarPoint.PDF.dll | 10.40.20162.0 |
| FarPoint.Win.Chart.dll | 10.40.20162.0 |
| FarPoint.Win.Chart.Design.dll | 10.40.20162.0 |
| FarPoint.Localization.dll | 10.40.20162.0 |
| GrapeCity.Win.PluginInputMan.Design.dll | 10.40.20162.0 |
| GrapeCity.Win.PluginInputMan.dll | 10.40.20162.0 |