Release Notes for Version 10.40.20162.0

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 for the exact location of these files.