📄 f1book.cpp
字号:
}
BOOL CF1Book::GetFormatPaintMode()
{
BOOL result;
GetProperty(0x58c, VT_BOOL, (void*)&result);
return result;
}
void CF1Book::SetFormatPaintMode(BOOL propVal)
{
SetProperty(0x58c, VT_BOOL, propVal);
}
BOOL CF1Book::GetCanEditPasteSpecial()
{
BOOL result;
GetProperty(0x58d, VT_BOOL, (void*)&result);
return result;
}
void CF1Book::SetCanEditPasteSpecial(BOOL propVal)
{
SetProperty(0x58d, VT_BOOL, propVal);
}
BOOL CF1Book::GetPrecisionAsDisplayed()
{
BOOL result;
GetProperty(0x593, VT_BOOL, (void*)&result);
return result;
}
void CF1Book::SetPrecisionAsDisplayed(BOOL propVal)
{
SetProperty(0x593, VT_BOOL, propVal);
}
BOOL CF1Book::GetDoSafeEvents()
{
BOOL result;
GetProperty(0x596, VT_BOOL, (void*)&result);
return result;
}
void CF1Book::SetDoSafeEvents(BOOL propVal)
{
SetProperty(0x596, VT_BOOL, propVal);
}
long CF1Book::GetDefaultFontCharSet()
{
long result;
GetProperty(0x59c, VT_I4, (void*)&result);
return result;
}
void CF1Book::SetDefaultFontCharSet(long propVal)
{
SetProperty(0x59c, VT_I4, propVal);
}
BOOL CF1Book::GetWantAllWindowInfoChanges()
{
BOOL result;
GetProperty(0x5a0, VT_BOOL, (void*)&result);
return result;
}
void CF1Book::SetWantAllWindowInfoChanges(BOOL propVal)
{
SetProperty(0x5a0, VT_BOOL, propVal);
}
CString CF1Book::GetUrl()
{
CString result;
GetProperty(0x5a1, VT_BSTR, (void*)&result);
return result;
}
void CF1Book::SetUrl(LPCTSTR propVal)
{
SetProperty(0x5a1, VT_BSTR, propVal);
}
long CF1Book::GetMousePointer()
{
long result;
GetProperty(0xfffffdf7, VT_I4, (void*)&result);
return result;
}
void CF1Book::SetMousePointer(long propVal)
{
SetProperty(0xfffffdf7, VT_I4, propVal);
}
CPicture CF1Book::GetMouseIcon()
{
LPDISPATCH pDispatch;
GetProperty(0xfffffdf6, VT_DISPATCH, (void*)&pDispatch);
return CPicture(pDispatch);
}
void CF1Book::SetMouseIcon(LPDISPATCH propVal)
{
SetProperty(0xfffffdf6, VT_DISPATCH, propVal);
}
BOOL CF1Book::GetDataLossIsError()
{
BOOL result;
GetProperty(0x5a4, VT_BOOL, (void*)&result);
return result;
}
void CF1Book::SetDataLossIsError(BOOL propVal)
{
SetProperty(0x5a4, VT_BOOL, propVal);
}
BOOL CF1Book::GetMinimalRecalc()
{
BOOL result;
GetProperty(0x5a5, VT_BOOL, (void*)&result);
return result;
}
void CF1Book::SetMinimalRecalc(BOOL propVal)
{
SetProperty(0x5a5, VT_BOOL, propVal);
}
BOOL CF1Book::GetAllowCellTextDlg()
{
BOOL result;
GetProperty(0x5a6, VT_BOOL, (void*)&result);
return result;
}
void CF1Book::SetAllowCellTextDlg(BOOL propVal)
{
SetProperty(0x5a6, VT_BOOL, propVal);
}
BOOL CF1Book::GetShowLockedCellsError()
{
BOOL result;
GetProperty(0x5a7, VT_BOOL, (void*)&result);
return result;
}
void CF1Book::SetShowLockedCellsError(BOOL propVal)
{
SetProperty(0x5a7, VT_BOOL, propVal);
}
long CF1Book::GetPrintDevNames()
{
long result;
GetProperty(0x5aa, VT_I4, (void*)&result);
return result;
}
void CF1Book::SetPrintDevNames(long propVal)
{
SetProperty(0x5aa, VT_I4, propVal);
}
short CF1Book::GetPrintCopies()
{
short result;
GetProperty(0x5b0, VT_I2, (void*)&result);
return result;
}
void CF1Book::SetPrintCopies(short propVal)
{
SetProperty(0x5b0, VT_I2, propVal);
}
/////////////////////////////////////////////////////////////////////////////
// CF1Book operations
double CF1Book::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 CF1Book::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);
}
void CF1Book::FormatCellsDlg(long Pages)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x546, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Pages);
}
CString CF1Book::GetColText(long nCol)
{
CString result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x110, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, parms,
nCol);
return result;
}
void CF1Book::SetColText(long nCol, LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_BSTR;
InvokeHelper(0x110, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nCol, lpszNewValue);
}
CString CF1Book::GetDefinedName(LPCTSTR Name)
{
CString result;
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x111, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, parms,
Name);
return result;
}
void CF1Book::SetDefinedName(LPCTSTR Name, LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR VTS_BSTR;
InvokeHelper(0x111, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
Name, lpszNewValue);
}
CString CF1Book::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 CF1Book::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 CF1Book::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;
}
CString CF1Book::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 CF1Book::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 CF1Book::GetLastColForRow(long nRow)
{
long result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x115, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, parms,
nRow);
return result;
}
BOOL CF1Book::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 CF1Book::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);
}
CString CF1Book::GetRowText(long nRow)
{
CString result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x118, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, parms,
nRow);
return result;
}
void CF1Book::SetRowText(long nRow, LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_BSTR;
InvokeHelper(0x118, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nRow, lpszNewValue);
}
CString CF1Book::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 CF1Book::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 CF1Book::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;
}
long CF1Book::GetObjCellType(long ObjID)
{
long result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x559, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, parms,
ObjID);
return result;
}
void CF1Book::SetObjCellType(long ObjID, long nNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x559, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
ObjID, nNewValue);
}
long CF1Book::GetObjCellRow(long ObjID)
{
long result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x55a, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, parms,
ObjID);
return result;
}
void CF1Book::SetObjCellRow(long ObjID, long nNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x55a, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
ObjID, nNewValue);
}
long CF1Book::GetObjCellCol(long ObjID)
{
long result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x55b, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, parms,
ObjID);
return result;
}
void CF1Book::SetObjCellCol(long ObjID, long nNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x55b, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
ObjID, nNewValue);
}
long CF1Book::GetObjSelection(short nSelection)
{
long result;
static BYTE parms[] =
VTS_I2;
InvokeHelper(0x55c, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, parms,
nSelection);
return result;
}
void CF1Book::EditPasteValues()
{
InvokeHelper(0x71, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CF1Book::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 CF1Book::GetBorder(short* pLeft, short* pRight, short* pTop, short* pBottom, short* pShade, long* pcrLeft, long* pcrRight, long* pcrTop, 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 CF1Book::GetFont(BSTR* pName, short* pSize, BOOL* pBold, BOOL* pItalic, BOOL* pUnderline, BOOL* pStrikeout, 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 CF1Book::GetLineStyle(short* pStyle, 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 CF1Book::GetPattern(short* pPattern, long* pcrFG, long* pcrBG)
{
static BYTE parms[] =
VTS_PI2 VTS_PI4 VTS_PI4;
InvokeHelper(0x76, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
pPattern, pcrFG, pcrBG);
}
void CF1Book::GetProtection(BOOL* pLocked, BOOL* pHidden)
{
static BYTE parms[] =
VTS_PBOOL VTS_PBOOL;
InvokeHelper(0x77, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
pLocked, pHidden);
}
void CF1Book::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 CF1Book::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 CF1Book::AddColPageBreak(long nCol)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x7a, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nCol);
}
void CF1Book::AddPageBreak()
{
InvokeHelper(0x7b, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CF1Book::AddRowPageBreak(long nRow)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x7c, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nRow);
}
void CF1Book::AddSelection(long nRow1, long nCol1, long nRow2, long nCol2)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0x7d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nRow1, nCol1, nRow2, nCol2);
}
void CF1Book::Attach(LPCTSTR Title)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x7e, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Title);
}
void CF1Book::AttachToSS(long hSrcSS)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x7f, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
hSrcSS);
}
void CF1Book::CalculationDlg()
{
InvokeHelper(0x80, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CF1Book::CancelEdit()
{
InvokeHelper(0x81, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CF1Book::CheckRecalc()
{
InvokeHelper(0x82, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CF1Book::ClearClipboard()
{
InvokeHelper(0x83, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CF1Book::ClearRange(long nRow1, long nCol1, long nRow2, long nCol2, long ClearType)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0x84, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nRow1, nCol1, nRow2, nCol2, ClearType);
}
void CF1Book::ColorPaletteDlg()
{
InvokeHelper(0x85, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CF1Book::ColWidthDlg()
{
InvokeHelper(0x86, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CF1Book::CopyAll(long hSrcSS)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x87, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
hSrcSS);
}
void CF1Book::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 CF1Book::DefinedNameDlg()
{
InvokeHelper(0x89, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CF1Book::DeleteDefinedName(LPCTSTR pName)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x8a, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
pName);
}
void CF1Book::DeleteRange(long nRow1, long nCol1, long nRow2, long nCol2, long ShiftType)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0x8b, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nRow1, nCol1, nRow2, nCol2, ShiftType);
}
void CF1Book::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 CF1Book::EditClear(long ClearType)
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -