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.

Return to the ReadMe.