📄 vcf1.cpp
字号:
void CVCF1::SetMouseIcon(LPDISPATCH propVal)
{
SetProperty(0x62, VT_DISPATCH, propVal);
}
BOOL CVCF1::GetDoObjValueChanged()
{
BOOL result;
GetProperty(0x63, VT_BOOL, (void*)&result);
return result;
}
void CVCF1::SetDoObjValueChanged(BOOL propVal)
{
SetProperty(0x63, VT_BOOL, propVal);
}
BOOL CVCF1::GetScrollToLastRC()
{
BOOL result;
GetProperty(0x64, VT_BOOL, (void*)&result);
return result;
}
void CVCF1::SetScrollToLastRC(BOOL propVal)
{
SetProperty(0x64, VT_BOOL, propVal);
}
BOOL CVCF1::GetModified()
{
BOOL result;
GetProperty(0x65, VT_BOOL, (void*)&result);
return result;
}
void CVCF1::SetModified(BOOL propVal)
{
SetProperty(0x65, VT_BOOL, propVal);
}
BOOL CVCF1::GetDoObjGotFocus()
{
BOOL result;
GetProperty(0x66, VT_BOOL, (void*)&result);
return result;
}
void CVCF1::SetDoObjGotFocus(BOOL propVal)
{
SetProperty(0x66, VT_BOOL, propVal);
}
BOOL CVCF1::GetDoObjLostFocus()
{
BOOL result;
GetProperty(0x67, VT_BOOL, (void*)&result);
return result;
}
void CVCF1::SetDoObjLostFocus(BOOL propVal)
{
SetProperty(0x67, VT_BOOL, propVal);
}
long CVCF1::GetPrintDevMode()
{
long result;
GetProperty(0x68, VT_I4, (void*)&result);
return result;
}
void CVCF1::SetPrintDevMode(long propVal)
{
SetProperty(0x68, VT_I4, propVal);
}
long CVCF1::GetNumSheets()
{
long result;
GetProperty(0x69, VT_I4, (void*)&result);
return result;
}
void CVCF1::SetNumSheets(long propVal)
{
SetProperty(0x69, VT_I4, propVal);
}
long CVCF1::GetSheet()
{
long result;
GetProperty(0x6a, VT_I4, (void*)&result);
return result;
}
void CVCF1::SetSheet(long propVal)
{
SetProperty(0x6a, VT_I4, propVal);
}
short CVCF1::GetColWidthUnits()
{
short result;
GetProperty(0x6b, VT_I2, (void*)&result);
return result;
}
void CVCF1::SetColWidthUnits(short propVal)
{
SetProperty(0x6b, VT_I2, propVal);
}
BOOL CVCF1::GetShowTypeMarkers()
{
BOOL result;
GetProperty(0x6c, VT_BOOL, (void*)&result);
return result;
}
void CVCF1::SetShowTypeMarkers(BOOL propVal)
{
SetProperty(0x6c, VT_BOOL, propVal);
}
short CVCF1::GetShowTabs()
{
short result;
GetProperty(0x6d, VT_I2, (void*)&result);
return result;
}
void CVCF1::SetShowTabs(short propVal)
{
SetProperty(0x6d, VT_I2, propVal);
}
BOOL CVCF1::GetShowEditBar()
{
BOOL result;
GetProperty(0x6e, VT_BOOL, (void*)&result);
return result;
}
void CVCF1::SetShowEditBar(BOOL propVal)
{
SetProperty(0x6e, VT_BOOL, propVal);
}
BOOL CVCF1::GetShowEditBarCellRef()
{
BOOL result;
GetProperty(0x6f, VT_BOOL, (void*)&result);
return result;
}
void CVCF1::SetShowEditBarCellRef(BOOL propVal)
{
SetProperty(0x6f, VT_BOOL, propVal);
}
BOOL CVCF1::GetAllowDesigner()
{
BOOL result;
GetProperty(0x1, VT_BOOL, (void*)&result);
return result;
}
void CVCF1::SetAllowDesigner(BOOL propVal)
{
SetProperty(0x1, VT_BOOL, propVal);
}
OLE_HANDLE CVCF1::GetHWnd()
{
OLE_HANDLE result;
GetProperty(DISPID_HWND, VT_I4, (void*)&result);
return result;
}
void CVCF1::SetHWnd(OLE_HANDLE propVal)
{
SetProperty(DISPID_HWND, VT_I4, propVal);
}
BOOL CVCF1::GetAllowAutoFill()
{
BOOL result;
GetProperty(0x70, VT_BOOL, (void*)&result);
return result;
}
void CVCF1::SetAllowAutoFill(BOOL propVal)
{
SetProperty(0x70, VT_BOOL, propVal);
}
/////////////////////////////////////////////////////////////////////////////
// CVCF1 operations
CString CVCF1::GetColText(long nCol)
{
CString result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x110, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, parms,
nCol);
return result;
}
void CVCF1::SetColText(long nCol, LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_BSTR;
InvokeHelper(0x110, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nCol, lpszNewValue);
}
CString CVCF1::GetDefinedName(LPCTSTR pName)
{
CString result;
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x111, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, parms,
pName);
return result;
}
void CVCF1::SetDefinedName(LPCTSTR pName, LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR VTS_BSTR;
InvokeHelper(0x111, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
pName, lpszNewValue);
}
CString CVCF1::GetEntryRC(long nRow, long nCol)
{
CString result;
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x112, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, parms,
nRow, nCol);
return result;
}
void CVCF1::SetEntryRC(long nRow, long nCol, LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_BSTR;
InvokeHelper(0x112, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nRow, nCol, lpszNewValue);
}
CString CVCF1::GetFormattedTextRC(long nRow, long nCol)
{
CString result;
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x113, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, parms,
nRow, nCol);
return result;
}
void CVCF1::SetFormattedTextRC(long nRow, long nCol, LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_BSTR;
InvokeHelper(0x113, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nRow, nCol, lpszNewValue);
}
CString CVCF1::GetFormulaRC(long nRow, long nCol)
{
CString result;
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x114, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, parms,
nRow, nCol);
return result;
}
void CVCF1::SetFormulaRC(long nRow, long nCol, LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_BSTR;
InvokeHelper(0x114, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nRow, nCol, lpszNewValue);
}
long CVCF1::GetLastColForRow(long nRow)
{
long result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x115, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, parms,
nRow);
return result;
}
void CVCF1::SetLastColForRow(long nRow, long nNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x115, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nRow, nNewValue);
}
BOOL CVCF1::GetLogicalRC(long nRow, long nCol)
{
BOOL result;
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x116, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, parms,
nRow, nCol);
return result;
}
void CVCF1::SetLogicalRC(long nRow, long nCol, BOOL bNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_BOOL;
InvokeHelper(0x116, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nRow, nCol, bNewValue);
}
double CVCF1::GetNumberRC(long nRow, long nCol)
{
double result;
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x117, DISPATCH_PROPERTYGET, VT_R8, (void*)&result, parms,
nRow, nCol);
return result;
}
void CVCF1::SetNumberRC(long nRow, long nCol, double newValue)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_R8;
InvokeHelper(0x117, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nRow, nCol, newValue);
}
CString CVCF1::GetRowText(long nRow)
{
CString result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x118, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, parms,
nRow);
return result;
}
void CVCF1::SetRowText(long nRow, LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_BSTR;
InvokeHelper(0x118, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nRow, lpszNewValue);
}
CString CVCF1::GetTextRC(long nRow, long nCol)
{
CString result;
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x119, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, parms,
nRow, nCol);
return result;
}
void CVCF1::SetTextRC(long nRow, long nCol, LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_BSTR;
InvokeHelper(0x119, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nRow, nCol, lpszNewValue);
}
short CVCF1::GetTypeRC(long nRow, long nCol)
{
short result;
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x11a, DISPATCH_PROPERTYGET, VT_I2, (void*)&result, parms,
nRow, nCol);
return result;
}
void CVCF1::SetTypeRC(long nRow, long nCol, short nNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I2;
InvokeHelper(0x11a, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nRow, nCol, nNewValue);
}
void CVCF1::EditPasteValues()
{
InvokeHelper(0x71, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CVCF1::GetAlignment(short* pHorizontal, BOOL* pWordWrap, short* pVertical, short* pOrientation)
{
static BYTE parms[] =
VTS_PI2 VTS_PBOOL VTS_PI2 VTS_PI2;
InvokeHelper(0x72, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
pHorizontal, pWordWrap, pVertical, pOrientation);
}
void CVCF1::GetBorder(short* pLeft, short* pRight, short* pTop, short* pBottom, short* pShade, unsigned long* pcrLeft, unsigned long* pcrRight, unsigned long* pcrTop, unsigned long* pcrBottom)
{
static BYTE parms[] =
VTS_PI2 VTS_PI2 VTS_PI2 VTS_PI2 VTS_PI2 VTS_PI4 VTS_PI4 VTS_PI4 VTS_PI4;
InvokeHelper(0x73, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
pLeft, pRight, pTop, pBottom, pShade, pcrLeft, pcrRight, pcrTop, pcrBottom);
}
void CVCF1::GetFont(BSTR* pName, short* pSize, BOOL* pBold, BOOL* pItalic, BOOL* pUnderline, BOOL* pStrikeout, unsigned long* pcrColor, BOOL* pOutline, BOOL* pShadow)
{
static BYTE parms[] =
VTS_PBSTR VTS_PI2 VTS_PBOOL VTS_PBOOL VTS_PBOOL VTS_PBOOL VTS_PI4 VTS_PBOOL VTS_PBOOL;
InvokeHelper(0x74, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
pName, pSize, pBold, pItalic, pUnderline, pStrikeout, pcrColor, pOutline, pShadow);
}
void CVCF1::GetLineStyle(short* pStyle, unsigned long* pcrColor, short* pWeight)
{
static BYTE parms[] =
VTS_PI2 VTS_PI4 VTS_PI2;
InvokeHelper(0x75, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
pStyle, pcrColor, pWeight);
}
void CVCF1::GetPattern(short* pPattern, unsigned long* pcrFG, unsigned long* pcrBG)
{
static BYTE parms[] =
VTS_PI2 VTS_PI4 VTS_PI4;
InvokeHelper(0x76, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
pPattern, pcrFG, pcrBG);
}
void CVCF1::GetProtection(BOOL* pLocked, BOOL* pHidden)
{
static BYTE parms[] =
VTS_PBOOL VTS_PBOOL;
InvokeHelper(0x77, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
pLocked, pHidden);
}
void CVCF1::GetTabbedText(long nR1, long nC1, long nR2, long nC2, BOOL bValuesOnly, long* phText)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_BOOL VTS_PI4;
InvokeHelper(0x78, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nR1, nC1, nR2, nC2, bValuesOnly, phText);
}
void CVCF1::SetTabbedText(long nStartRow, long nStartCol, long* pRows, long* pCols, BOOL bValuesOnly, LPCTSTR pText)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_PI4 VTS_PI4 VTS_BOOL VTS_BSTR;
InvokeHelper(0x79, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nStartRow, nStartCol, pRows, pCols, bValuesOnly, pText);
}
void CVCF1::AddColPageBreak(long nCol)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x7a, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nCol);
}
void CVCF1::AddPageBreak()
{
InvokeHelper(0x7b, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CVCF1::AddRowPageBreak(long nRow)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x7c, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nRow);
}
void CVCF1::AddSelection(long nR1, long nC1, long nR2, long nC2)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0x7d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nR1, nC1, nR2, nC2);
}
void CVCF1::Attach(LPCTSTR pTitle)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x7e, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
pTitle);
}
void CVCF1::AttachToSS(long hSrcSS)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x7f, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
hSrcSS);
}
void CVCF1::CalculationDlg()
{
InvokeHelper(0x80, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CVCF1::CancelEdit()
{
InvokeHelper(0x81, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CVCF1::CheckRecalc()
{
InvokeHelper(0x82, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CVCF1::ClearClipboard()
{
InvokeHelper(0x83, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CVCF1::ClearRange(long nR1, long nC1, long nR2, long nC2, short ClearType)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I2;
InvokeHelper(0x84, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nR1, nC1, nR2, nC2, ClearType);
}
void CVCF1::ColorPaletteDlg()
{
InvokeHelper(0x85, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CVCF1::ColWidthDlg()
{
InvokeHelper(0x86, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CVCF1::CopyAll(long hSrcSS)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x87, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
hSrcSS);
}
void CVCF1::CopyRange(long nDstR1, long nDstC1, long nDstR2, long nDstC2, long hSrcSS, long nSrcR1, long nSrcC1, long nSrcR2, long nSrcC2)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0x88, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nDstR1, nDstC1, nDstR2, nDstC2, hSrcSS, nSrcR1, nSrcC1, nSrcR2, nSrcC2);
}
void CVCF1::DefinedNameDlg()
{
InvokeHelper(0x89, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CVCF1::DeleteDefinedName(LPCTSTR pName)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x8a, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
pName);
}
void CVCF1::DeleteRange(long nR1, long nC1, long nR2, long nC2, short ShiftType)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I2;
InvokeHelper(0x8b, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nR1, nC1, nR2, nC2, ShiftType);
}
void CVCF1::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)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_PI4 VTS_PI4 VTS_I4 VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0x8c, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
hDC, x, y, cx, cy, nRow, nCol, pRows, pCols, nFixedRow, nFixedCol, nFixedRows, nFixedCols);
}
void CVCF1::EditClear(short ClearType)
{
static BYTE parms[] =
VTS_I2;
InvokeHelper(0x8d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -