DLL Styles
Styles are settings that DLL users can apply to a control when they create it. You can assign a defined value or a numeric value for a style. The following tables list both values for the fpSpread control.
| Define Value | Numeric Value | Description |
|---|---|---|
| SSS_ALLOWCELLOVERFLOW | 0x400L | Allows text to overflow to the next cell if the next cell does not contain data |
| SSS_ALLOWUSERFORMULAS | 0x080L | Lets the user type formulas into cells (You can also provide this feature using the SSSetBool function SSB_ALLOWUSERFORMULAS option.) |
| SSS_HIDECOLHEADERS | 0x100L | Removes the column headers from the top of the sheet |
| SSS_HIDEROWHEADERS | 0x200L | Removes row headers from the side of the sheet |
| SSS_LOCKALL | 0x008L | Marks the entire sheet as locked (You can mark or unmark individual cells using the SSSetLock function. Cells are only marked as locked, not locked, until the SSSetBool function SSB_PROTECT option is TRUE. However, by default, the SSB_PROTECT option is TRUE.) |
| SSS_NOGRIDLINES | 0x040L | Removes grid lines usually displayed in the sheet |
| SSS_NORESIZE | 0x010L | Prevents the user from resizing columns and rows |
| SSS_NOSELECTBLOCK | 0x020L | Prevents the user from selecting blocks of cells |
| SSS_PROTECT | 0x004L | Protects all cells marked as locked (preventing user interaction) (You can also provide this feature using the SSSetBool function SSB_PROTECT option.) |
| SSS_RESTRICTCOLS | 0x002L | Prevents the user from leaving blank columns in the sheet (At least one cell in a column must contain data before the user can type data in the subsequent column.) |
| SSS_RESTRICTROWS | 0x001L | Prevents the user from leaving blank rows in the sheet (At least one cell in a row must contain data before the user can type data in the subsequent row.) |
| SSS_SCROLLBAREXTMODE | 0x800L | Displays scroll bars only when the maximum number of columns or rows exceeds the size of the fpSpread control |