f1bookview.h

这是本人两年前兼职为某个公司做的石油钻进设计软件

	void SetODBCNativeError(long);
	CString GetODBCErrorMsg();
	void SetODBCErrorMsg(LPCTSTR);
	BOOL GetDataTransferHeadings();
	void SetDataTransferHeadings(BOOL);
	BOOL GetCanEditPasteSpecial();
	void SetCanEditPasteSpecial(BOOL);
	BOOL GetPrecisionAsDisplayed();
	void SetPrecisionAsDisplayed(BOOL);
	long GetDefaultFontCharSet();
	void SetDefaultFontCharSet(long);
	BOOL GetWantAllWindowInfoChanges();
	void SetWantAllWindowInfoChanges(BOOL);
	BOOL GetDataLossIsError();
	void SetDataLossIsError(BOOL);
	BOOL GetMinimalRecalc();
	void SetMinimalRecalc(BOOL);
	BOOL GetAllowCellTextDlg();
	void SetAllowCellTextDlg(BOOL);
	BOOL GetShowLockedCellsError();
	void SetShowLockedCellsError(BOOL);

// Operations
public:
	double GetNumberRC(long nRow, long nCol);
	void SetNumberRC(long nRow, long nCol, double newValue);
	CString GetColText(long nCol);
	void SetColText(long nCol, LPCTSTR lpszNewValue);
	CString GetDefinedName(LPCTSTR Name);
	void SetDefinedName(LPCTSTR Name, LPCTSTR lpszNewValue);
	CString GetEntryRC(long nRow, long nCol);
	void SetEntryRC(long nRow, long nCol, LPCTSTR lpszNewValue);
	CString GetFormattedTextRC(long nRow, long nCol);
	CString GetFormulaRC(long nRow, long nCol);
	void SetFormulaRC(long nRow, long nCol, LPCTSTR lpszNewValue);
	long GetLastColForRow(long nRow);
	BOOL GetLogicalRC(long nRow, long nCol);
	void SetLogicalRC(long nRow, long nCol, BOOL bNewValue);
	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);
	long GetObjCellType(long ObjID);
	void SetObjCellType(long ObjID, long nNewValue);
	long GetObjCellRow(long ObjID);
	void SetObjCellRow(long ObjID, long nNewValue);
	long GetObjCellCol(long ObjID);
	void SetObjCellCol(long ObjID, long nNewValue);
	long GetObjSelection(short nSelection);
	void EditPasteValues();
	void GetAlignment(short* pHorizontal, BOOL* pWordWrap, short* pVertical, short* pOrientation);
	void GetBorder(short* pLeft, short* pRight, short* pTop, short* pBottom, short* pShade, long* pcrLeft, long* pcrRight, long* pcrTop, long* pcrBottom);
	void GetFont(BSTR* pName, short* pSize, BOOL* pBold, BOOL* pItalic, BOOL* pUnderline, BOOL* pStrikeout, long* pcrColor, BOOL* pOutline, BOOL* pShadow);
	void GetLineStyle(short* pStyle, long* pcrColor, short* pWeight);
	void GetPattern(short* pPattern, long* pcrFG, 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 nRow1, long nCol1, long nRow2, long nCol2);
	void Attach(LPCTSTR Title);
	void AttachToSS(long hSrcSS);
	void CheckRecalc();
	void ClearClipboard();
	void ClearRange(long nRow1, long nCol1, long nRow2, long nCol2, long ClearType);
	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 DeleteDefinedName(LPCTSTR pName);
	void DeleteRange(long nRow1, long nCol1, long nRow2, long nCol2, long 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(long ClearType);
	void EditCopy();
	void EditCopyDown();
	void EditCopyRight();
	void EditCut();
	void EditDelete(long ShiftType);
	void EditInsert(long InsertType);
	void EditPaste();
	void FormatCurrency0();
	void FormatCurrency2();
	void FormatFixed();
	void FormatFixed2();
	void FormatFraction();
	void FormatGeneral();
	void FormatHmmampm();
	void FormatMdyy();
	void FormatPercent();
	void FormatScientific();
	void GetActiveCell(long* pRow, long* pCol);
	short GetColWidth(long nCol);
	// method 'SetColWidth' not emitted because of invalid return type or parameter type
	short GetRowHeight(long nRow);
	// method 'SetRowHeight' not emitted because of invalid return type or parameter type
	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 HeapMin();
	void InitTable();
	void InsertRange(long nRow1, long nCol1, long nRow2, long nCol2, long InsertType);
	void MoveRange(long nRow1, long nCol1, long nRow2, long nCol2, long nRowOffset, long nColOffset);
	void ObjAddItem(long ObjID, LPCTSTR ItemText);
	void ObjAddSelection(long ObjID);
	void ObjBringToFront();
	void ObjDeleteItem(long ObjID, short nItem);
	void ObjGetCell(long ObjID, short* pControlCellType, long* pRow, long* pCol);
	void ObjGetPos(long ObjID, float* pX1, float* pY1, float* pX2, float* pY2);
	void ObjGetSelection(short nSelection, long* pID);
	void ObjInsertItem(long ObjID, short nItem, LPCTSTR ItemText);
	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 ObjPosToTwips(float nX1, float nY1, float nX2, float nY2, long* pX, long* pY, long* pCX, long* pCY, short* pShown);
	void ObjSendToBack();
	void ObjSetCell(long ObjID, short CellType, long nRow, long nCol);
	void ObjSetPicture(long ObjID, long hMF, short nMapMode, long nWndExtentX, long nWndExtentY);
	void ObjSetPos(long ObjID, float nX1, float nY1, float nX2, float nY2);
	void ObjSetSelection(long ObjID);
	void OpenFileDlg(LPCTSTR pTitle, long hWndParent, BSTR* pBuf);
	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 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 nCol1, long nCol2, short nWidth, BOOL bDefColWidth);
	void SetColWidthAuto(long nRow1, long nCol1, long nRow2, long nCol2, BOOL bSetDefaults);
	void SetDefaultFont(LPCTSTR Name, 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 nRow1, long nRow2, short nHeight, BOOL bDefRowHeight);
	void SetRowHeightAuto(long nRow1, long nCol1, long nRow2, long nCol2, BOOL bSetDefaults);
	void SetSelection(long nRow1, long nCol1, long nRow2, long nCol2);
	void ShowActiveCell();
	void Sort3(long nRow1, long nCol1, long nRow2, long nCol2, BOOL bSortByRows, long nKey1, long nKey2, long nKey3);
	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 PathName, 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, short nWidth, BOOL bDefColWidth);
	CString GetDefinedNameByIndex(short nName);
	CString GetSheetName(short nSheet);
	void SetSheetName(short 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);
	short GetColWidthTwips(long nCol);
	void SetColWidthTwips(long nCol, short nNewValue);
	long NextColPageBreak(long Col);
	long NextRowPageBreak(long Row);
	long ObjFirstID();
	long ObjNextID(long ObjID);
	short ObjGetItemCount(long ObjID);
	long ObjGetType(long ObjID);
	short ObjGetSelectionCount();
	CString FormatRCNr(long Row, long Col, BOOL DoAbsolute);
	long SS();
	CString GetObjItem(long ObjID, short nItem);
	void SetObjItem(long ObjID, short nItem, LPCTSTR lpszNewValue);
	CString GetObjItems(long ObjID);
	void SetObjItems(long ObjID, LPCTSTR lpszNewValue);
	CString GetObjName(long ObjID);
	void SetObjName(long ObjID, LPCTSTR lpszNewValue);
	CString GetObjText(long ObjID);
	void SetObjText(long ObjID, LPCTSTR lpszNewValue);
	short GetObjValue(long ObjID);
	void SetObjValue(long ObjID, short nNewValue);
	BOOL GetObjVisible(long ObjID);
	void SetObjVisible(long ObjID, BOOL bNewValue);
	long ObjNameToID(LPCTSTR Name);
	long DefinedNameCount();
	CString GetAutoFillItems(short nIndex);
	void SetAutoFillItems(short nIndex, LPCTSTR lpszNewValue);
	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 PrintPreviewDC(long hDC, short nPage, short* pPages);
	void PrintPreview(long hWnd, long x, long y, long cx, long cy, short nPage, short* pPages);
	CString GetEntrySRC(long nSheet, long nRow, long nCol);
	void SetEntrySRC(long nSheet, long nRow, long nCol, LPCTSTR lpszNewValue);
	CString GetFormattedTextSRC(long nSheet, long nRow, long nCol);
	CString GetFormulaSRC(long nSheet, long nRow, long nCol);
	void SetFormulaSRC(long nSheet, long nRow, long nCol, LPCTSTR lpszNewValue);
	BOOL GetLogicalSRC(long nSheet, long nRow, long nCol);
	void SetLogicalSRC(long nSheet, long nRow, long nCol, BOOL bNewValue);
	double GetNumberSRC(long nSheet, long nRow, long nCol);
	void SetNumberSRC(long nSheet, long nRow, long nCol, double newValue);
	CString GetTextSRC(long nSheet, long nRow, long nCol);
	void SetTextSRC(long nSheet, long nRow, long nCol, LPCTSTR lpszNewValue);
	short GetTypeSRC(long nSheet, long nRow, long nCol);
	void WriteRange(long nSheet, long nRow1, long nCol1, long nRow2, long nCol2, LPCTSTR pPathName, short FileType);
	void InsertHTML(long nSheet, long nRow1, long nCol1, long nRow2, long nCol2, LPCTSTR pPathName, BOOL bDataOnly, LPCTSTR pAnchorName);
	CString GetFormulaLocalRC(long nRow, long nCol);
	void SetFormulaLocalRC(long nRow, long nCol, LPCTSTR lpszNewValue);
	CString GetFormulaLocalSRC(long nSheet, long nRow, long nCol);
	void SetFormulaLocalSRC(long nSheet, long nRow, long nCol, LPCTSTR lpszNewValue);
	CString GetDefinedNameLocal(LPCTSTR Name);
	void SetDefinedNameLocal(LPCTSTR Name, LPCTSTR lpszNewValue);
	void CopyDataFromArray(long nSheet, long nRow1, long nCol1, long nRow2, long nCol2, BOOL bValuesOnly, const VARIANT& Array);
	void CopyDataToArray(long nSheet, long nRow1, long nCol1, long nRow2, long nCol2, BOOL bValuesOnly, const VARIANT& Array);
	void ODBCError(BSTR* pSQLState, long* pNativeError, BSTR* pErrorMsg);
	void ODBCPrepare(LPCTSTR SQLStr, short* pRetCode);
	void ODBCBindParameter(long nParam, long nCol, short CDataType, short* pRetCode);
	void ODBCExecute(long nRow1, long nRow2, short* pRetCode);
	void ObjNewPolygon(float X1, float Y1, float X2, float Y2, long* pID, const VARIANT& ArrayX, const VARIANT& ArrayY, BOOL bClosed);
	void ObjSetPolygonPoints(long nID, const VARIANT& ArrayX, const VARIANT& ArrayY, BOOL bClosed);
	CString GetTabbedTextEx(long nR1, long nC1, long nR2, long nC2, BOOL bValuesOnly);
	CF1RangeRef SetTabbedTextEx(long nStartRow, long nStartCol, BOOL bValuesOnly, LPCTSTR pText);
	long ObjCreate(long ObjType, float nX1, float nY1, float nX2, float nY2);
	long ObjCreatePicture(float nX1, float nY1, float nX2, float nY2, long hMF, long nMapMode, long nWndExtentX, long nWndExtentY);
	long ReadEx(LPCTSTR pPathName);
	long WriteToBlobEx(short nReservedBytes);
	long ObjCreatePolygon(float X1, float Y1, float X2, float Y2, const VARIANT& ArrayX, const VARIANT& ArrayY, BOOL bClosed);
	CF1ObjPos ObjGetPosEx(long ObjID);
	short ObjPosShown(float X1, float Y1, float X2, float Y2);
	CF1RangeRef GetSelectionEx(short nSelection);
	CF1Rect ObjPosToTwipsEx(float X1, float Y1, float X2, float Y2);
	CF1Rect RangeToTwipsEx(long nRow1, long nCol1, long nRow2, long nCol2);
	short RangeShown(long nR1, long nC1, long nR2, long nC2);
	long TwipsToRow(long nTwips);
	long TwipsToCol(long nTwips);
	short PrintPreviewDCEx(long hDC, short nPage);
	short PrintPreviewEx(long hWnd, long x, long y, long cx, long cy, short nPage);
	void ODBCConnectEx(LPDISPATCH pConnectObj, BOOL bShowErrors);
	void ODBCQueryEx(LPDISPATCH pQueryObj, long nRow, long nCol, BOOL bForceShowDlg);
	short ODBCPrepareEx(LPCTSTR SQLStr);
	short ODBCBindParameterEx(long nParam, long nCol, long CDataType);
	short ODBCExecuteEx(long nRow1, long nRow2);
	CString OpenFileDlgEx(LPCTSTR pTitle, long hWndParent);
	CF1BookView CreateBookView();
	void EditPasteSpecial(long PasteWhat, long PasteOp);
	CF1NumberFormat GetFirstNumberFormat();
	void GetNextNumberFormat(LPDISPATCH pNumberFormat);
	CF1Rect RangeToPixelsEx(long nRow1, long nCol1, long nRow2, long nCol2);
	void WriteEx(LPCTSTR PathName, long FileType);
	void WriteRangeEx(long nSheet, long nRow1, long nCol1, long nRow2, long nCol2, LPCTSTR pPathName, long FileType);
	void GetFontEx(BSTR* pName, long* pCharSet, short* pSize, BOOL* pBold, BOOL* pItalic, BOOL* pUnderline, BOOL* pStrikeout, long* pcrColor, BOOL* pOutline, BOOL* pShadow);
	void SetFontEx(LPCTSTR pName, long CharSet, short nSize, BOOL bBold, BOOL bItalic, BOOL bUnderline, BOOL bStrikeout, unsigned long crColor, BOOL bOutline, BOOL bShadow);
	void GetDefaultFontEx(BSTR* pBuf, long* pCharSet, short* pSize);
	void SetDefaultFontEx(LPCTSTR Name, long CharSet, short nSize);
	CF1CellFormat CreateNewCellFormat();
	CF1CellFormat GetCellFormat();
	void SetCellFormat(LPDISPATCH CellFormat);
	CString ErrorNumberToText(long SSError);
	CF1FindReplaceInfo DefineSearch(LPCTSTR FindWhat, long nSheet, long nRow1, long nCol1, long nRow2, long nCol2, short Flags);
	CF1PageSetup CreateNewPageSetup();
	CF1PageSetup GetPageSetup();
	void SetPageSetup(LPDISPATCH PageSetup);
};

//{{AFX_INSERT_LOCATION}}
// Microsoft Visual C++ will insert additional declarations immediately before the previous line.

#endif // !defined(AFX_F1BOOKVIEW_H__D9AA3CBC_1D72_4BDF_8A5A_6D4DA3BB071C__INCLUDED_)