📄 vcf1.h
字号:
BOOL GetDoObjLostFocus();
void SetDoObjLostFocus(BOOL);
long GetPrintDevMode();
void SetPrintDevMode(long);
long GetNumSheets();
void SetNumSheets(long);
long GetSheet();
void SetSheet(long);
short GetColWidthUnits();
void SetColWidthUnits(short);
BOOL GetShowTypeMarkers();
void SetShowTypeMarkers(BOOL);
short GetShowTabs();
void SetShowTabs(short);
BOOL GetShowEditBar();
void SetShowEditBar(BOOL);
BOOL GetShowEditBarCellRef();
void SetShowEditBarCellRef(BOOL);
BOOL GetAllowDesigner();
void SetAllowDesigner(BOOL);
OLE_HANDLE GetHWnd();
void SetHWnd(OLE_HANDLE);
BOOL GetAllowAutoFill();
void SetAllowAutoFill(BOOL);
// Operations
public:
CString GetColText(long nCol);
void SetColText(long nCol, LPCTSTR lpszNewValue);
CString GetDefinedName(LPCTSTR pName);
void SetDefinedName(LPCTSTR pName, LPCTSTR lpszNewValue);
CString GetEntryRC(long nRow, long nCol);
void SetEntryRC(long nRow, long nCol, LPCTSTR lpszNewValue);
CString GetFormattedTextRC(long nRow, long nCol);
void SetFormattedTextRC(long nRow, long nCol, LPCTSTR lpszNewValue);
CString GetFormulaRC(long nRow, long nCol);
void SetFormulaRC(long nRow, long nCol, LPCTSTR lpszNewValue);
long GetLastColForRow(long nRow);
void SetLastColForRow(long nRow, long nNewValue);
BOOL GetLogicalRC(long nRow, long nCol);
void SetLogicalRC(long nRow, long nCol, BOOL bNewValue);
double GetNumberRC(long nRow, long nCol);
void SetNumberRC(long nRow, long nCol, double newValue);
CString GetRowText(long nRow);
void SetRowText(long nRow, LPCTSTR lpszNewValue);
CString GetTextRC(long nRow, long nCol);
void SetTextRC(long nRow, long nCol, LPCTSTR lpszNewValue);
short GetTypeRC(long nRow, long nCol);
void SetTypeRC(long nRow, long nCol, short nNewValue);
void EditPasteValues();
void GetAlignment(short* pHorizontal, BOOL* pWordWrap, short* pVertical, short* pOrientation);
void GetBorder(short* pLeft, short* pRight, short* pTop, short* pBottom, short* pShade, unsigned long* pcrLeft, unsigned long* pcrRight, unsigned long* pcrTop, unsigned long* pcrBottom);
void GetFont(BSTR* pName, short* pSize, BOOL* pBold, BOOL* pItalic, BOOL* pUnderline, BOOL* pStrikeout, unsigned long* pcrColor, BOOL* pOutline, BOOL* pShadow);
void GetLineStyle(short* pStyle, unsigned long* pcrColor, short* pWeight);
void GetPattern(short* pPattern, unsigned long* pcrFG, unsigned long* pcrBG);
void GetProtection(BOOL* pLocked, BOOL* pHidden);
void GetTabbedText(long nR1, long nC1, long nR2, long nC2, BOOL bValuesOnly, long* phText);
void SetTabbedText(long nStartRow, long nStartCol, long* pRows, long* pCols, BOOL bValuesOnly, LPCTSTR pText);
void AddColPageBreak(long nCol);
void AddPageBreak();
void AddRowPageBreak(long nRow);
void AddSelection(long nR1, long nC1, long nR2, long nC2);
void Attach(LPCTSTR pTitle);
void AttachToSS(long hSrcSS);
void CalculationDlg();
void CancelEdit();
void CheckRecalc();
void ClearClipboard();
void ClearRange(long nR1, long nC1, long nR2, long nC2, short ClearType);
void ColorPaletteDlg();
void ColWidthDlg();
void CopyAll(long hSrcSS);
void CopyRange(long nDstR1, long nDstC1, long nDstR2, long nDstC2, long hSrcSS, long nSrcR1, long nSrcC1, long nSrcR2, long nSrcC2);
void DefinedNameDlg();
void DeleteDefinedName(LPCTSTR pName);
void DeleteRange(long nR1, long nC1, long nR2, long nC2, short ShiftType);
void Draw(long hDC, long x, long y, long cx, long cy, long nRow, long nCol, long* pRows, long* pCols, long nFixedRow, long nFixedCol, long nFixedRows, long nFixedCols);
void EditClear(short ClearType);
void EditCopy();
void EditCopyDown();
void EditCopyRight();
void EditCut();
void EditDelete(short ShiftType);
void EditInsert(short ShiftType);
void EditPaste();
void EndEdit();
void FilePageSetupDlg();
void FilePrint(BOOL bShowPrintDlg);
void FilePrintSetupDlg();
void FormatAlignmentDlg();
void FormatBorderDlg();
void FormatCurrency0();
void FormatCurrency2();
void FormatDefaultFontDlg();
void FormatFixed();
void FormatFixed2();
void FormatFontDlg();
void FormatFraction();
void FormatGeneral();
void FormatHmmampm();
void FormatMdyy();
void FormatNumberDlg();
void FormatPatternDlg();
void FormatPercent();
void FormatScientific();
void GetActiveCell(long* pRow, long* pCol);
short GetColWidth(long nCol);
void SetColWidth(long nCol, short nNewValue);
short GetRowHeight(long nRow);
void SetRowHeight(long nRow, short nNewValue);
void GetDefaultFont(BSTR* pBuf, short* pSize);
void GetHdrSelection(BOOL* pTopLeftHdr, BOOL* pRowHdr, BOOL* pColHdr);
void GetIteration(BOOL* pIteration, short* pMaxIterations, double* pMaxChange);
void GetPrintScale(short* pScale, BOOL* pFitToPage, long* pVPages, long* pHPages);
void GetSelection(short nSelection, long* pR1, long* pC1, long* pR2, long* pC2);
void GotoDlg();
void HeapMin();
void InitTable();
void InsertRange(long nR1, long nC1, long nR2, long nC2, short ShiftType);
void LineStyleDlg();
void MoveRange(long nR1, long nC1, long nR2, long nC2, long nRowOffset, long nColOffset);
void ObjAddItem(long ID, LPCTSTR pItem);
void ObjAddSelection(long ID);
void ObjBringToFront();
void ObjDeleteItem(long ID, short nItem);
void ObjGetCell(long ID, short* pControlCellType, long* pRow, long* pCol);
void ObjGetPos(long ID, float* pX1, float* pY1, float* pX2, float* pY2);
void ObjGetSelection(short nSelection, long* pID);
void ObjInsertItem(long ID, short nItem, LPCTSTR pItem);
void ObjNameDlg();
void ObjNew(short ObjType, float nX1, float nY1, float nX2, float nY2, long* pID);
void ObjNewPicture(float nX1, float nY1, float nX2, float nY2, long* pID, long hMF, long nMapMode, long nWndExtentX, long nWndExtentY);
void ObjOptionsDlg();
void ObjPosToTwips(float nX1, float nY1, float nX2, float nY2, long* pX, long* pY, long* pCX, long* pCY, short* pShown);
void ObjSendToBack();
void ObjSetCell(long ID, short ControlCellType, long nRow, long nCol);
void ObjSetPicture(long ID, long hMF, short nMapMode, long nWndExtentX, long nWndExtentY);
void ObjSetPos(long ID, float nX1, float nY1, float nX2, float nY2);
void ObjSetSelection(long ID);
void OpenFileDlg(LPCTSTR pTitle, long hWndParent, BSTR* pBuf);
void ProtectionDlg();
void RangeToTwips(long nRow1, long nCol1, long nRow2, long nCol2, long* pX, long* pY, long* pCX, long* pCY, short* pShown);
void Read(LPCTSTR pPathName, short* pFileType);
void ReadFromBlob(long hBlob, short nReservedBytes);
void Recalc();
void RemoveColPageBreak(long nCol);
void RemovePageBreak();
void RemoveRowPageBreak(long nRow);
void RowHeightDlg();
void SaveFileDlg(LPCTSTR pTitle, BSTR* pBuf, short* pFileType);
void SaveWindowInfo();
void SetActiveCell(long nRow, long nCol);
void SetAlignment(short HAlign, BOOL bWordWrap, short VAlign, short nOrientation);
void SetBorder(short nOutline, short nLeft, short nRight, short nTop, short nBottom, short nShade, unsigned long crOutline, unsigned long crLeft, unsigned long crRight, unsigned long crTop, unsigned long crBottom);
void SetColWidth(long nC1, long nC2, short nWidth, BOOL bDefColWidth);
void SetColWidthAuto(long nR1, long nC1, long nR2, long nC2, BOOL bSetDefaults);
void SetDefaultFont(LPCTSTR pName, short nSize);
void SetFont(LPCTSTR pName, short nSize, BOOL bBold, BOOL bItalic, BOOL bUnderline, BOOL bStrikeout, unsigned long crColor, BOOL bOutline, BOOL bShadow);
void SetHdrSelection(BOOL bTopLeftHdr, BOOL bRowHdr, BOOL bColHdr);
void SetIteration(BOOL bIteration, short nMaxIterations, double nMaxChange);
void SetLineStyle(short nStyle, unsigned long crColor, short nWeight);
void SetPattern(short nPattern, unsigned long crFG, unsigned long crBG);
void SetPrintAreaFromSelection();
void SetPrintScale(short nScale, BOOL bFitToPage, short nVPages, short nHPages);
void SetPrintTitlesFromSelection();
void SetProtection(BOOL bLocked, BOOL bHidden);
void SetRowHeight(long nR1, long nR2, short nHeight, BOOL bDefRowHeight);
void SetRowHeightAuto(long nR1, long nC1, long nR2, long nC2, BOOL bSetDefaults);
void SetSelection(long nR1, long nC1, long nR2, long nC2);
void ShowActiveCell();
void Sort3(long nR1, long nC1, long nR2, long nC2, BOOL bSortByRows, long nKey1, long nKey2, long nKey3);
void SortDlg();
void StartEdit(BOOL bClear, BOOL bInCellEditFocus, BOOL bArrowsExitEditMode);
void SwapTables(long hSS2);
void TransactCommit();
void TransactRollback();
void TransactStart();
void TwipsToRC(long x, long y, long* pRow, long* pCol);
void SSUpdate();
short SSVersion();
void Write(LPCTSTR pPathName, short FileType);
void WriteToBlob(long* phBlob, short nReservedBytes);
void SetRowHidden(long nRow1, long nRow2, BOOL bHidden);
void SetColHidden(long nCol1, long nCol2, BOOL bHidden);
void SetColWidthTwips(long nCol1, long nCol2, long nWidth, BOOL bDefColWidth);
CString GetDefinedNameByIndex(long nName);
void SetDefinedNameByIndex(long nName, LPCTSTR lpszNewValue);
CString GetSheetName(long nSheet);
void SetSheetName(long nSheet, LPCTSTR lpszNewValue);
unsigned long GetPaletteEntry(long nEntry);
void SetPaletteEntry(long nEntry, unsigned long newValue);
void EditInsertSheets();
void EditDeleteSheets();
void InsertSheets(long nSheet, long nSheets);
void DeleteSheets(long nSheet, long nSheets);
void Refresh();
short GetColWidthTwips(long Col);
void SetColWidthTwips(long Col, short nNewValue);
long NextColPageBreak(long Col);
long NextRowPageBreak(long Row);
long ObjFirstID();
long ObjNextID(long ID);
short ObjGetItemCount(long ID);
short ObjGetType(long ID);
short ObjGetSelectionCount();
CString FormatRCNr(long Row, long Col, BOOL DoAbsolute);
long SS();
CString ErrorNumberToText(long SSError);
CString GetObjItem(long ID, short Item);
void SetObjItem(long ID, short Item, LPCTSTR lpszNewValue);
CString GetObjItems(long ID);
void SetObjItems(long ID, LPCTSTR lpszNewValue);
CString GetObjName(long ID);
void SetObjName(long ID, LPCTSTR lpszNewValue);
CString GetObjText(long ID);
void SetObjText(long ID, LPCTSTR lpszNewValue);
short GetObjValue(long ID);
void SetObjValue(long ID, short nNewValue);
BOOL GetObjVisible(long ID);
void SetObjVisible(long ID, BOOL bNewValue);
long ObjNameToID(LPCTSTR Name);
long DefinedNameCount();
CString GetAutoFillItems(short Index);
void SetAutoFillItems(short Index, LPCTSTR lpszNewValue);
void ValidationRuleDlg();
void SetValidationRule(LPCTSTR Rule, LPCTSTR Text);
void GetValidationRule(BSTR* Rule, BSTR* Text);
short AutoFillItemsCount();
void CopyRangeEx(long nDstSheet, long nDstR1, long nDstC1, long nDstR2, long nDstC2, long hSrcSS, long nSrcSheet, long nSrcR1, long nSrcC1, long nSrcR2, long nSrcC2);
void Sort(long nR1, long nC1, long nR2, long nC2, BOOL bSortByRows, const VARIANT& Keys);
BOOL GetColHidden(long nCol);
void SetColHidden(long nCol, BOOL bNewValue);
BOOL GetRowHidden(long nRow);
void SetRowHidden(long nRow, BOOL bNewValue);
void DeleteAutoFillItems(short nIndex);
void ODBCConnect(BSTR* pConnect, BOOL bShowErrors, short* pRetCode);
void ODBCDisconnect();
void ODBCQuery(BSTR* pQuery, long nRow, long nCol, BOOL bForceShowDlg, BOOL* pSetColNames, BOOL* pSetColFormats, BOOL* pSetColWidths, BOOL* pSetMaxRC, short* pRetCode);
BOOL GetSheetSelected(long nSheet);
void SetSheetSelected(long nSheet, BOOL bNewValue);
void LaunchDesigner();
void AboutBox();
};
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -