FarPoint Spread控件使用.docVIP

交替背景色 grid1.BackColorStyle = 1 ret = grid1.SetOddEvenRowColor(HFFFFFF, HC0FFFF, fpSpread.SetOddEvenRowColor(ByVal clrBackOddAs Long, ByVal clrForeOdd As Long, ByVal clrBackEvenAs Long, ByVal clrForeEven As Long) As Boolean Parameter Description clrBackOdd Background color of odd rows clrForeOdd Text color of odd rows clrBackEven Background color of even rows clrForeEven Text color of even rows 设定回车方向 grid1.EditEnterAction = EditEnterActionNext [form.]fpSpread.EditEnterAction[ = setting%] Setting Description Constant 0 - None (Default) Active cell does not change EditEnterActionNone 1 - Up Active cell moves up EditEnterActionUp 2 - Down Active cell moves down EditEnterActionDown 3 - Left Active cell moves left EditEnterActionLeft 4 - Right Active cell moves right EditEnterActionRight 5 - Next Next cell becomes active cell(Active cell moves in the order left to right, top to bottom.) EditEnterActionNext 6 - Previous Previous cell becomes active cell(Active cell moves in the order right to left, bottom to top.) EditEnterActionPrevious 7 - Same Current cell remains active cell EditEnterActionSame 8 - Next Row Active cell moves to first column of next row EditEnterActionNextRow  按键的键值 可在代码中的任何地方用下列常数代替实际值： 常数 值 描述 vbKeyLButton 0x1 鼠标左键 vbKeyRButton 0x2 鼠标右键 vbKeyCancel 0x3 CANCEL 键 vbKeyMButton 0x4 鼠标中键 vbKeyBack 0x8 BACKSPACE 键 vbKeyTab 0x9 TAB 键 vbKeyClear 0xC CLEAR 键 vbKeyReturn 0xD ENTER 键 vbKeyShift 0x10 SHIFT 键 vbKeyControl 0x11 CTRL 键 vbKeyMenu 0x12 MENU 键 vbKeyPause 0x13 PAUSE 键 vbKeyCapital 0x14 CAPS LOCK 键 vbKeyEscape 0x1B ESC 键 vbKeySpace 0x20 SPACEBAR 键 vbKeyPageUp 0x21 PAGE UP 键 vbKeyPageDown 0x22 PAGE DOWN 键 vbKeyEnd 0x23 END 键 vbKeyHome 0x24 HOME 键 vbKeyLeft 0x25 LEFT ARROW 键 vbKeyUp 0x26 UP ARROW 键 vbKeyRight 0x27 RIGHT ARROW 键 vbKeyDown 0x28 DOWN ARROW 键 vbKeySelect 0x29 SELECT 键 vbKeyPrint 0x2A PRINT SCREEN 键 vbKeyExecute 0x2B EXECUTE 键 vbKeySnapshot 0x2C SNAPSHOT 键 vbKeyInsert