📄 spconst.bas
字号:
Attribute VB_Name = "spConst"
Option Explicit
' Action property settings
'##ModelId=3D338ACE00E6
Public Const SS_ACTION_ACTIVE_CELL = 0
'##ModelId=3D338ACE0122
Public Const SS_ACTION_GOTO_CELL = 1
'##ModelId=3D338ACE015E
Public Const SS_ACTION_SELECT_BLOCK = 2
'##ModelId=3D338ACE019A
Public Const SS_ACTION_CLEAR = 3
'##ModelId=3D338ACE01D6
Public Const SS_ACTION_DELETE_COL = 4
'##ModelId=3D338ACE0213
Public Const SS_ACTION_DELETE_ROW = 5
'##ModelId=3D338ACE024F
Public Const SS_ACTION_INSERT_COL = 6
'##ModelId=3D338ACE028B
Public Const SS_ACTION_INSERT_ROW = 7
'##ModelId=3D338ACE02C7
Public Const SS_ACTION_RECALC = 11
'##ModelId=3D338ACE0303
Public Const SS_ACTION_CLEAR_TEXT = 12
'##ModelId=3D338ACE033F
Public Const SS_ACTION_PRINT = 13
'##ModelId=3D338ACE037B
Public Const SS_ACTION_DESELECT_BLOCK = 14
'##ModelId=3D338ACE03C1
Public Const SS_ACTION_DSAVE = 15
'##ModelId=3D338ACF001F
Public Const SS_ACTION_SET_CELL_BORDER = 16
'##ModelId=3D338ACF005B
Public Const SS_ACTION_ADD_MULTISELBLOCK = 17
'##ModelId=3D338ACF0097
Public Const SS_ACTION_GET_MULTI_SELECTION = 18
'##ModelId=3D338ACF00CA
Public Const SS_ACTION_COPY_RANGE = 19
'##ModelId=3D338ACF0106
Public Const SS_ACTION_MOVE_RANGE = 20
'##ModelId=3D338ACF014C
Public Const SS_ACTION_SWAP_RANGE = 21
'##ModelId=3D338ACF0188
Public Const SS_ACTION_CLIPBOARD_COPY = 22
'##ModelId=3D338ACF01C4
Public Const SS_ACTION_CLIPBOARD_CUT = 23
'##ModelId=3D338ACF0200
Public Const SS_ACTION_CLIPBOARD_PASTE = 24
'##ModelId=3D338ACF023C
Public Const SS_ACTION_SORT = 25
'##ModelId=3D338ACF0278
Public Const SS_ACTION_COMBO_CLEAR = 26
'##ModelId=3D338ACF02B4
Public Const SS_ACTION_COMBO_REMOVE = 27
'##ModelId=3D338ACF02F0
Public Const SS_ACTION_RESET = 28
'##ModelId=3D338ACF0322
Public Const SS_ACTION_SEL_MODE_CLEAR = 29
'##ModelId=3D338ACF035E
Public Const SS_ACTION_VMODE_REFRESH = 30
'##ModelId=3D338ACF03AF
Public Const SS_ACTION_SMARTPRINT = 32
' Appearance property settings
'##ModelId=3D338AD00003
Public Const SS_APPEARANCE_FLAT = 0
'##ModelId=3D338AD0003F
Public Const SS_APPEARANCE_3D = 1
'##ModelId=3D338AD0007B
Public Const SS_APPEARANCE_3DWITHBORDER = 2
' BackColorStyle property settings
'##ModelId=3D338AD000B7
Public Const SS_BACKCOLORSTYLE_OVERGRID = 0
'##ModelId=3D338AD000F3
Public Const SS_BACKCOLORSTYLE_UNDERGRID = 1
'##ModelId=3D338AD00139
Public Const SS_BACKCOLORSTYLE_OVERHORZGRIDONLY = 2
'##ModelId=3D338AD0016B
Public Const SS_BACKCOLORSTYLE_OVERVERTGRIDONLY = 3
' ButtonDrawMode property settings
'##ModelId=3D338AD001A7
Public Const SS_BDM_ALWAYS = 0
'##ModelId=3D338AD001ED
Public Const SS_BDM_CURRENT_CELL = 1
'##ModelId=3D338AD0023D
Public Const SS_BDM_CURRENT_COLUMN = 2
'##ModelId=3D338AD00270
Public Const SS_BDM_CURRENT_ROW = 4
'##ModelId=3D338AD002AC
Public Const SS_BDM_ALWAYS_BUTTON = 8
'##ModelId=3D338AD002E8
Public Const SS_BDM_ALWAYS_COMBO = 16
' CellBorderStyle property settings
'##ModelId=3D338AD00324
Public Const SS_BORDER_STYLE_DEFAULT = 0
'##ModelId=3D338AD00360
Public Const SS_BORDER_STYLE_SOLID = 1
'##ModelId=3D338AD003A6
Public Const SS_BORDER_STYLE_DASH = 2
'##ModelId=3D338AD10004
Public Const SS_BORDER_STYLE_DOT = 3
'##ModelId=3D338AD10040
Public Const SS_BORDER_STYLE_DASH_DOT = 4
'##ModelId=3D338AD1007C
Public Const SS_BORDER_STYLE_DASH_DOT_DOT = 5
'##ModelId=3D338AD100C2
Public Const SS_BORDER_STYLE_BLANK = 6
'##ModelId=3D338AD100FE
Public Const SS_BORDER_STYLE_FINE_SOLID = 11
'##ModelId=3D338AD1013B
Public Const SS_BORDER_STYLE_FINE_DASH = 12
'##ModelId=3D338AD10177
Public Const SS_BORDER_STYLE_FINE_DOT = 13
'##ModelId=3D338AD101B3
Public Const SS_BORDER_STYLE_FINE_DASH_DOT = 14
'##ModelId=3D338AD101EF
Public Const SS_BORDER_STYLE_FINE_DASH_DOT_DOT = 15
' CellBorderType property settings
'##ModelId=3D338AD1023F
Public Const SS_BORDER_TYPE_NONE = 0
'##ModelId=3D338AD1027B
Public Const SS_BORDER_TYPE_OUTLINE = 16
'##ModelId=3D338AD102B7
Public Const SS_BORDER_TYPE_LEFT = 1
'##ModelId=3D338AD102F3
Public Const SS_BORDER_TYPE_RIGHT = 2
'##ModelId=3D338AD1032F
Public Const SS_BORDER_TYPE_TOP = 4
'##ModelId=3D338AD1036B
Public Const SS_BORDER_TYPE_BOTTOM = 8
' CellType property settings
'##ModelId=3D338AD1039D
Public Const SS_CELL_TYPE_DATE = 0
'##ModelId=3D338AD20006
Public Const SS_CELL_TYPE_EDIT = 1
'##ModelId=3D338AD20042
Public Const SS_CELL_TYPE_FLOAT = 2
'##ModelId=3D338AD2007E
Public Const SS_CELL_TYPE_INTEGER = 3
'##ModelId=3D338AD200BA
Public Const SS_CELL_TYPE_PIC = 4
'##ModelId=3D338AD200F6
Public Const SS_CELL_TYPE_STATIC_TEXT = 5
'##ModelId=3D338AD20132
Public Const SS_CELL_TYPE_TIME = 6
'##ModelId=3D338AD2016E
Public Const SS_CELL_TYPE_BUTTON = 7
'##ModelId=3D338AD201AA
Public Const SS_CELL_TYPE_COMBOBOX = 8
'##ModelId=3D338AD201F0
Public Const SS_CELL_TYPE_PICTURE = 9
'##ModelId=3D338AD2022C
Public Const SS_CELL_TYPE_CHECKBOX = 10
'##ModelId=3D338AD20268
Public Const SS_CELL_TYPE_OWNER_DRAWN = 11
' ClipboardOptions property settings
'##ModelId=3D338AD202A5
Public Const SS_CLIP_NOHEADERS = 0
'##ModelId=3D338AD202E1
Public Const SS_CLIP_COPYROWHEADERS = 1
'##ModelId=3D338AD2031D
Public Const SS_CLIP_PASTEROWHEADERS = 2
'##ModelId=3D338AD20359
Public Const SS_CLIP_COPYCOLHEADERS = 4
'##ModelId=3D338AD20395
Public Const SS_CLIP_PASTECOLHEADERS = 8
'##ModelId=3D338AD203DB
Public Const SS_CLIP_COPYPASTEALLHEADERS = 15
' ColHeaderDisplay and RowHeaderDisplay property settings
'##ModelId=3D338AD30043
Public Const SS_HEADER_BLANK = 0
'##ModelId=3D338AD3007F
Public Const SS_HEADER_NUMBERS = 1
'##ModelId=3D338AD300BB
Public Const SS_HEADER_LETTERS = 2
' CursorStyle property settings
'##ModelId=3D338AD300F7
Public Const SS_CURSOR_STYLE_USER_DEFINED = 0
'##ModelId=3D338AD3013D
Public Const SS_CURSOR_STYLE_DEFAULT = 1
'##ModelId=3D338AD30184
Public Const SS_CURSOR_STYLE_ARROW = 2
'##ModelId=3D338AD301C0
Public Const SS_CURSOR_STYLE_DEFCOLRESIZE = 3
'##ModelId=3D338AD301FC
Public Const SS_CURSOR_STYLE_DEFROWRESIZE = 4
' CursorType property settings
'##ModelId=3D338AD30238
Public Const SS_CURSOR_TYPE_DEFAULT = 0
'##ModelId=3D338AD3027E
Public Const SS_CURSOR_TYPE_COLRESIZE = 1
'##ModelId=3D338AD302BA
Public Const SS_CURSOR_TYPE_ROWRESIZE = 2
'##ModelId=3D338AD302F6
Public Const SS_CURSOR_TYPE_BUTTON = 3
'##ModelId=3D338AD30332
Public Const SS_CURSOR_TYPE_GRAYAREA = 4
'##ModelId=3D338AD3036E
Public Const SS_CURSOR_TYPE_LOCKEDCELL = 5
'##ModelId=3D338AD303B4
Public Const SS_CURSOR_TYPE_COLHEADER = 6
'##ModelId=3D338AD40008
Public Const SS_CURSOR_TYPE_ROWHEADER = 7
'##ModelId=3D338AD40045
Public Const SS_CURSOR_TYPE_DRAGDROPAREA = 8
'##ModelId=3D338AD40081
Public Const SS_CURSOR_TYPE_DRAGDROP = 9
' DAutoSize property settings
'##ModelId=3D338AD400BD
Public Const SS_AUTOSIZE_NO = 0
'##ModelId=3D338AD40103
Public Const SS_AUTOSIZE_MAX_COL_WIDTH = 1
'##ModelId=3D338AD4013F
Public Const SS_AUTOSIZE_BEST_GUESS = 2
' EditEnterAction property settings
'##ModelId=3D338AD4017B
Public Const SS_CELL_EDITMODE_EXIT_NONE = 0
'##ModelId=3D338AD401B7
Public Const SS_CELL_EDITMODE_EXIT_UP = 1
'##ModelId=3D338AD401F3
Public Const SS_CELL_EDITMODE_EXIT_DOWN = 2
'##ModelId=3D338AD4022F
Public Const SS_CELL_EDITMODE_EXIT_LEFT = 3
'##ModelId=3D338AD4026B
Public Const SS_CELL_EDITMODE_EXIT_RIGHT = 4
'##ModelId=3D338AD402A7
Public Const SS_CELL_EDITMODE_EXIT_NEXT = 5
'##ModelId=3D338AD402E3
Public Const SS_CELL_EDITMODE_EXIT_PREVIOUS = 6
'##ModelId=3D338AD40320
Public Const SS_CELL_EDITMODE_EXIT_SAME = 7
'##ModelId=3D338AD4035C
Public Const SS_CELL_EDITMODE_EXIT_NEXTROW = 8
' OperationMode property settings
'##ModelId=3D338AD40398
Public Const SS_OP_MODE_NORMAL = 0
'##ModelId=3D338AD403DE
Public Const SS_OP_MODE_READONLY = 1
'##ModelId=3D338AD5003C
Public Const SS_OP_MODE_ROWMODE = 2
'##ModelId=3D338AD50082
Public Const SS_OP_MODE_SINGLE_SELECT = 3
'##ModelId=3D338AD500B4
Public Const SS_OP_MODE_MULTI_SELECT = 4
'##ModelId=3D338AD500FA
Public Const SS_OP_MODE_EXT_SELECT = 5
' Position property settings
'##ModelId=3D338AD50136
Public Const SS_POSITION_UPPER_LEFT = 0
'##ModelId=3D338AD50172
Public Const SS_POSITION_UPPER_CENTER = 1
'##ModelId=3D338AD501AE
Public Const SS_POSITION_UPPER_RIGHT = 2
'##ModelId=3D338AD501E1
Public Const SS_POSITION_CENTER_LEFT = 3
'##ModelId=3D338AD5021D
Public Const SS_POSITION_CENTER_CENTER = 4
'##ModelId=3D338AD50259
Public Const SS_POSITION_CENTER_RIGHT = 5
'##ModelId=3D338AD50295
Public Const SS_POSITION_BOTTOM_LEFT = 6
'##ModelId=3D338AD502E5
Public Const SS_POSITION_BOTTOM_CENTER = 7
'##ModelId=3D338AD5032B
Public Const SS_POSITION_BOTTOM_RIGHT = 8
' PrintOrientation property settings
'##ModelId=3D338AD5035D
Public Const SS_PRINTORIENT_DEFAULT = 0
'##ModelId=3D338AD50399
Public Const SS_PRINTORIENT_PORTRAIT = 1
'##ModelId=3D338AD503DF
Public Const SS_PRINTORIENT_LANDSCAPE = 2
' PrintType property settings
'##ModelId=3D338AD6003D
Public Const SS_PRINT_ALL = 0
'##ModelId=3D338AD60079
Public Const SS_PRINT_CELL_RANGE = 1
'##ModelId=3D338AD600B6
Public Const SS_PRINT_CURRENT_PAGE = 2
'##ModelId=3D338AD600F2
Public Const SS_PRINT_PAGE_RANGE = 3
' ScrollBars property settings
'##ModelId=3D338AD6012E
Public Const SS_SCROLLBAR_NONE = 0
'##ModelId=3D338AD6016A
Public Const SS_SCROLLBAR_H_ONLY = 1
'##ModelId=3D338AD601A6
Public Const SS_SCROLLBAR_V_ONLY = 2
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -