If you have used previous versions of Spread, you should read these topics to familiarize yourself with the updates available in Spread version 8.0. For additional information and instructions for upgrading your existing projects, see Project Upgrade.
New Properties
- AppearanceStyle
- CellNoteIndicatorColor
- CellNoteIndicatorShape
- CTAppearance Class (BackColor)
- CTAppearance Class (DrawColors)
- CTAppearance Class (DrawPrimaryButton)
- CTAppearance Class (DrawSecondaryButton)
- CTAppearance Class (Font)
- CTAppearance Class (ForeColor)
- CTAppearance Class (LockBackColor)
- CTAppearance Class (LockForeColor)
- CTAppearance Class (SelBackColor)
- CTAppearance Class (SelForeColor)
- CTAppearance Class (Style)
- CTAppearance Class (TypeCustomName)
- CTAppearance Class (TypeCustomStyle)
- EnhanceStaticCells
- HiglightAlphaBlend
- HighlightAlphaBlendColor
- HighlightHeaders
- HighlightStyle
- ScrollBarStyle
- TabEnhancedShape
- TabStripButtonPolicy
- TypeCustomItemData
- UseVisualStyles
New Methods
- AddCustomCellType
- EnumCustomCellType
- ExportRangeToHtmlEx
- GetCustomCellType
- GetCustomEditor
- GetCustomRenderer
- GetFontHandle
- ExportToHtmlEx
- IsExcel2007File
- IsHorizontalScrollBarVisible
- IsVerticalScrollBarVisible
- OpenExcel2007File
- SetEnhancedColumnHeaderColors
- SetEnhancedCornerColors
- SetEnhancedRowHeaderColors
- SetEnhancedScrollBarColors
- SetEnhancedSheetTabColors
- LoadBlockFromBuffer
- LoadFromBuffer
- PaintControl
- RemoveCustomCellType
- SaveBlockToBuffer
- SaveExcel2007File
- SaveToBuffer
New Events
- CircularFormula
- CTCancelEditing
- CTCreateEditorControl
- CTCreateRendererControl
- CTGetEditorValue
- CTGetPreferredSize
- CTGetReservedCursor
- CTInitializeControl
- CTIsReservedKey
- CTIsReservedLocation
- CTIsValid
- CTPaintCell
- CTSetValue
- CTStartEditing
- CTStopEditing
- CTStringFormat
- CTStringUnFormat
Changes to Spread 7 Properties
- UserColAction
This property has a new Auto Size setting.
- PrintFooter, PrintHeader
-
These properties now support /date and /time.
- CellType
-
The check box cell type now has a default familiar windows appearance.
There is a new Scientific cell type.
- MaxTextColWidth
-
This property supports button cells now.
- TypeHAlign, TypeVAlign
-
These properties work with button cells now.
Changes to Spread 7 Methods
Changes to Spread 7 Events
- TextTipFetch
The type for the Multiline parameter has changed to FPSpreadADO.TextTipFetchMultilineConstants instead of Integer. If you used this event in your project it will need to be updated.
- CustomFunction
The type for the Status parameter has changed to FPSpreadADO.ValueStatusConstants instead of Integer. The enumerations have also changed. If you used this event in your project it will need to be updated.
Obsolete Properties
- PrintSmartPrint
Still provided for backward compatibility. If set, overrides PrintScaling Method property, but for best results, use PrintScalingMethod property.
- Users of Spread 3.0 and Spread 3.5 should see the list of Obsolete Properties from Previous Versions.