Fpspread1控件使用手册.docVIP

Fpspread1控件使用手册： 数据类型的使用： Setting Description Constant 0 - Date Creates date cell CellTypeDate 1 - Edit (Default) Creates edit cell CellTypeEdit 4 - PIC Creates PIC cell CellTypePic 5 - Static Text Creates static text cell CellTypeStaticText 6 - Time Creates time cell CellTypeTime 7 - Button Creates button cell CellTypeButton 8 - Combo Box Creates combo box cell CellTypeComboBox 9 - Picture Creates picture cell CellTypePicture 10 - Check Box Creates check box cell CellTypeCheckBox 11 - Owner-Drawn Creates owner-drawn cell CellTypeOwnerDrawn 12 - Currency Creates currency cell CellTypeCurrency 13 - Number Creates numeric cell CellTypeNumber 14 - Percent Creates percent cell CellTypePercent 15 - Scientific Creates scientific cell CellTypeScientific  一、日期型的使用 ShortDaysUs = 星期一 + s + MO + s + TU + s + WE + s + TH + s + FR + s + SA LongDaysUs = 星期一 + s + MON + s + TUE + s + WED + s + THU + s + FRI + s + SAT ShortMonthsUs = 一月 + s + FEB + s + MAR + s + APR + s + MAY + s + JUN + s + JUL + s + AUG + s + SEP + s + OCT + s + NOV + s + DEC LongMonthsUs = 一月 + s + FEBR + s + MARC + s + APRI + s + MAY + s + JUNE + s + JULY + s + AUGU + s + SEPT + s + OCTO + s + NOVE + s + DECE Fpspread1.col=1 fpspread1. Value=date fpspread1.CellType =CellTypeDate Call fpspread1.SetCalText(ShortDaysUs, LongDaysUs, ShortMonthsUs, LongMonthsUs, Accept, Deny) 二、下拉框的使用 fpSpread1.Row = 2 fpSpread1.Col = 2 fpSpread1.CellType = CellTypeComboBox fpSpread1.TypeComboBoxList = Mastiff + Chr$(9) + Sheepdog + Chr$(9) + Terrier + Chr$(9) + Spaniel + Chr$(9) + Pointer + Chr$(9) + Coonhound fpSpread1.TypeComboBoxString = DogwoodfpSpread1.TypeComboBoxString = Pear fpSpread1.TypeComboBoxEditable = True fpSpread1.TypeComboBoxMaxDrop = 5 fpSpread1.TypeComboBoxCurSel = 0 fpSpread1.TypeComboBoxWidth = 0 三、换行 fpSpread1.TypeEditMultiLine = True fpSpread1.Text = Holly grows as small bushes and as large trees. cellheight = fpSpread1.MaxTextCellHeight