com.f1j.ss
Class BookModelImpl

java.lang.Object
  |
  +--com.f1j.ss.BookModelImpl

public class BookModelImpl

extends java.lang.Object

implements BookModel

Implements e.Spreadsheet.

Field Summary

static short	CANCEL Specifies a CANCEL button.
static short	eClearAll Clears data, formats, and objects.
static short	eClearContents Clears cell data but leaves formatting intact.
static short	eClearDlg Displays the Clear dialog box.
static short	eClearFormats Clears formats only.
static short	eClearValues Deprecated. Replaced by #eClearContents
static short	eColWidthUnitsNormal Column width in characters.
static short	eColWidthUnitsTwips Column width in twips.
static short	eCopyAll Copies formats, values, and formulas.
static short	eCopyFormats Copies formats.
static short	eCopyFormulas Copies formulas and data.
static short	eCopyValues Copies the values only; the result is a value without the formula that produced it.
static short	eEncryptionAuto Deprecated. Replaced by DocumentEncryption.AUTO
static short	eEncryptionExcel97 Deprecated. Replaced by DocumentEncryption.EXCEL97
static short	eEncryptionWeak Deprecated. Replaced by DocumentEncryption.WEAK
static short	eFileActuate9 Deprecated. Replaced by DocumentType.ACTUATE_9_WORKBOOK
static short	eFileCurrentFormat Deprecated. Replaced by DocumentType.CURRENT_FORMAT
static short	eFileESpreadsheet11 Deprecated. Replaced by DocumentType.ESPREADSHEET_11_WORKBOOK
static short	eFileExcel5 Deprecated. Replaced by DocumentType.EXCEL_5_WORKBOOK
static short	eFileExcel97 Deprecated. Replaced by DocumentType.EXCEL_97_WORKBOOK
static short	eFileExcel97And5 Excel 97-2003 and 5.x/95 format.
static short	eFileFormulaOne3 Deprecated. Replaced by DocumentType.FORMULA_ONE_3_WORKBOOK
static short	eFileFormulaOne6 Deprecated. Replaced by DocumentType.FORMULA_ONE_6_WORKBOOK
static short	eFileFormulaOne7 Deprecated. Replaced by DocumentType.FORMULA_ONE_7_WORKBOOK
static short	eFileTabbedText Deprecated. Replaced by DocumentType.TABBED_TEXT
static short	eFileTabbedTextValuesOnly Deprecated. Replaced by DocumentType.TABBED_TEXT_VALUES_ONLY
static short	eFileUnicodeText Deprecated. Replaced by DocumentType.UNICODE_TEXT
static short	eFileUnicodeTextValuesOnly Deprecated. Replaced by DocumentType.UNICODE_TEXT_VALUES_ONLY
static short	eFixupAppend Append cells to a range during an insert.
static short	eFixupIgnoreAdjacentRanges Ignore Adjacent Ranges
static short	eFixupPrepend Prepend cells to a range during an insert.
static short	eOutlineCollapsed Collapsed rows/columns in an outline.
static short	eOutlineExpanded Expanded rows/columns in an outline.
static short	eOutlineTerminal Terminals or leaf node rows/columns in an outline.
static short	eParamCurrency Parameter Type - Currency
static short	eParamDate Parameter Type - Date
static short	eParamDouble Parameter Type - double
static short	eParametersFileActuate5 Deprecated. e.Spreadsheet 12 and up no longer write ROP files.
static short	eParametersFileActuate6 Deprecated. e.Spreadsheet 12 and up no longer write ROP files.
static short	eParametersFileActuate7 Deprecated. e.Spreadsheet 12 and up no longer write ROP files.
static short	eParametersFileActuate8 Deprecated. e.Spreadsheet 12 and up no longer write ROP files.
static short	eParamFormula Parameter Type - Formula
static short	eParamInteger Parameter Type - Integer
static short	eParamString Parameter Type - String
static short	eQueryParamCurrency Parameter Type - Currency
static short	eQueryParamDate Parameter Type - Date
static short	eQueryParamDouble Parameter Type - double
static short	eQueryParamFormula Parameter Type - Formula
static short	eQueryParamInteger Parameter Type - Integer
static short	eQueryParamString Parameter Type - String
static short	eSheetHidden Indicates the sheet is hidden.
static short	eSheetShown Indicates the sheet is not hidden.
static short	eSheetTypeChart Chartsheet sheet type.
static short	eSheetTypeSheet Worksheet sheet type.
static short	eSheetVeryHidden Indicates the sheet is hidden and the user is not allowed to unhide it via the Workbook Designer.
static short	eShiftColumns Columns in which the range resides are deleted.
static short	eShiftHorizontal Cells to the right of the range are shifted left to fill the vacated space.
static short	eShiftRows Rows in which the range resides are deleted.
static short	eShiftVertical Cells below the range are shifted up to fill the vacated space.
static short	eShowAutomatic Selections or scroll bars are displayed if book or control is active.
static short	eShowOff Selections or scrollbars are hidden.
static short	eShowOn Selections or scrollbars are displayed.
static short	eTabsBottom Tabs appear at the bottom of worksheets.
static short	eTabsOff Tabs do not appear on worksheets.
static short	eTabsTop Tabs appear at the top of worksheets.
static short	eTypeEmpty Indicates an empty cell.
static short	eTypeError Indicates the cell contains an error.
static short	eTypeLogical Indicates a logical cell.
static short	eTypeNumber Indicates a number cell.
static short	eTypeText Indicates a text cell.
static int	kAllowDefault Sheet protection allows default standard operations.
static int	kAllowDeleteColumns Sheet protection allows Delete columns.
static int	kAllowDeleteRows Sheet protection allows Delete rows.
static int	kAllowEditObjects Sheet protection allows Edit objects.
static int	kAllowFormatCells Sheet protection allows Format cells.
static int	kAllowFormatColumns Sheet protection allows Format columns.
static int	kAllowFormatRows Sheet protection allows Format rows.
static int	kAllowInsertColumns Sheet protection allows Insert columns.
static int	kAllowInsertHyperlinks Sheet protection allows Insert hyperlinks.
static int	kAllowInsertRows Sheet protection allows Insert rows.
static int	kAllowNone Sheet protection allows nothing.
static int	kAllowSelectLocked Sheet protection allows Select locked cells.
static int	kAllowSelectUnlocked Sheet protection allows Select unlocked cells.
static int	kAllowSort Sheet protection allows Sort.
static int	kAllowUseAutoFilter Sheet protection allows Use AutoFilter.
static int	kAllowUsePivotRanges Sheet protection allows Use PivotRange reports.
static int	kCodePageDefaultANSI default ANSI (language-specific) code page.
static int	kCodePageUnicodeBE Unicode Big Endian (UTF-16) code page.
static int	kCodePageUnicodeLE Unicode Little Endian (UTF-16) code page.
static int	kCodePageUTF8 UTF-8 code page.
static int	kContentsChanged Cell contents were changed in an entry method.
static int	kFontChanged Font was changed in an entry method.
static int	kFormatChanged Format was changed in an entry method.
static int	kMaxCellText The maximum length of text in a cell.
static int	kMaxCol The maximum column number.
static int	kMaxCols The maximum number of columns.
static int	kMaxPaletteEntry The maximum number of palatte entries.
static int	kMaxRow The maximum row number.
static int	kMaxRows The maximum number of rows.
static int	kMaxSheet The maximum sheet number.
static int	kMaxSheets The maximum number of sheets.
static int	kProtectStructure Workbook structure is protected.
static short	NO Specifies a NO button.
static short	OK Specifies an OK button in the type parameter to messageBox().
static short	YES Specifies a YES button.

Constructor Summary

BookModelImpl()
Deprecated. replaced by BookModel.Factory.create()

BookModelImpl(Book book)
Deprecated. replaced by BookModel.Factory.create(Book)

BookModelImpl(Book book, Group group)
Deprecated. replaced by BookModel.Factory.create(Book, com.f1j.util.Group)

Method Summary

void	addColPageBreak(int col) Adds a vertical page break to the left edge of the specified column.
void	addHyperlink(int iSheet, int iRow1, int iCol1, int iRow2, int iCol2, java.lang.String strLink, int iType, java.lang.String strToolTip) Adds a hyperlink to a worksheet range.
GRObject	addObject(short objectType, double x1, double y1, double x2, double y2) Deprecated. Replaced by com.f1j.drawing.DrawingModel.addShape(com.f1j.drawing.EAutoShape, com.f1j.drawing.ShapeAnchor).
void	addPageBreak() Adds a horizontal and vertical page break adjacent to the active cell.
GRObject	addPicture(double x1, double y1, double x2, double y2, byte[] imageData) Deprecated. Replaced by com.f1j.drawing.DrawingModel.addPicture(byte[], com.f1j.drawing.ShapeAnchor).
GRObject	addPicture(double x1, double y1, double x2, double y2, java.net.URL url) Deprecated. Replaced by com.f1j.drawing.DrawingModel.addPicture(java.io.InputStream, com.f1j.drawing.ShapeAnchor).
GRObject	addPolygon(double x1, double y1, double x2, double y2, java.awt.Point[] points, boolean closed) Deprecated.
void	addRowPageBreak(int row) Adds a horizontal page break adjacent to the top edge of the specified row.
void	addSelection(GRObject object) Deprecated. Replaced by com.f1j.drawing.DrawingModel.getSelectedShapes() and com.f1j.drawing.DrawingModel.setSelection(com.f1j.drawing.ShapeRange).
void	addSelection(int row1, int col1, int row2, int col2) Adds a new selection to the current selection list.
void	attach(Book book) Attaches the current BookModel to the specified Book using the display properties of the specified workbook.
void	attach(BookModel bookModel) Attaches the current BookModel to the specified BookModel using the display properties of the specified BookModel.
void	attach(java.lang.String workbookName) Searches for a workbook with the specified name, and attaches the current Book to it.
void	autoFreezePanes() Freezes or unfreezes the current split view.
void	autoSplitView(boolean bHorizontal, boolean bVertical) Toggles the split state of the view.
void	cancelClipboard() Clears the internal clipboard and the Windows clipboard.
void	cancelEdit() Aborts edit mode and leaves the current cell unchanged.
boolean	canEditCopy() Returns true if data can be copied and placed on the clipboard.
boolean	canEditCut() Returns true if data can be cut and placed on the clipboard.
boolean	canEditPaste() Returns true if the internal clipboard or the Windows clipboard contains items that can be pasted to the worksheet.
boolean	canEditPasteSpecial() Returns true if the internal clipboard or the Windows clipboard contains items that can be pasted to the worksheet using the Paste Special command.
int	charWidthToTwips(int charWidth) Converts column widths to units equal to 1/256th of the character 0's width in the default font.
void	checkRecalc() Recalculates the workbook if needed.
void	clearRange(int row1, int col1, int row2, int col2, short clearType) Clears the specified range.
void	copyAll(BookModel srcBookModel) Copies the contents of one workbook to another workbook.
void	copyAllToBook(Book dstBook) Copies everything from the Book attached to this BookModel to the destination workbook, dstBook.
void	copyDataFromArray(int sheet, int row1, int col1, int row2, int col2, double[][] data) Copies data from an array into a sheet.
void	copyDataToArray(int sheet, int row1, int col1, int row2, int col2, double[][] data) Copies data from the sheet into an array.
void	copyRange(int dstRow1, int dstCol1, int dstRow2, int dstCol2, BookModel srcBookModel, int srcRow1, int srcCol1, int srcRow2, int srcCol2) Copies a range of cells to a new location in the current workbook.
void	copyRange(int dstRow1, int dstCol1, int dstRow2, int dstCol2, BookModel srcBookModel, int srcRow1, int srcCol1, int srcRow2, int srcCol2, short what) Copies a range of cells to a new location in the current workbook.
void	copyRange(int dstSheet, int dstRow1, int dstCol1, int dstRow2, int dstCol2, BookModel srcBookModel, int srcSheet, int srcRow1, int srcCol1, int srcRow2, int srcCol2) Copies a range of data from one worksheet to another.
void	copyRange(int dstSheet, int dstRow1, int dstCol1, int dstRow2, int dstCol2, BookModel srcBookModel, int srcSheet, int srcRow1, int srcCol1, int srcRow2, int srcCol2, short what) Copies a range of data from one worksheet to another.
void	copySheet(int nInsertAt) Creates copies of all selected sheets.
void	copySheet(int nInsertAt, Range range) Creates copies of the specified sheets.
void	deleteAutoFillItems(int index) Deletes the specified autofill list.
void	deleteDefinedName(java.lang.String name) Deletes the specified user-defined name.
void	deleteRange(int row1, int col1, int row2, int col2, short shiftType) Deletes cells, rows, or columns from the specified range in all selected sheets.
void	deleteSheet() Deletes the delected sheets.
void	deleteSheet(Range range) Deletes the specified sheets.
void	deleteSheets(int sheet, int sheets) Deletes one or more worksheets from a workbook.
void	destroy() Releases resources associated with this BookModelImpl.
void	editCopy() Copies the selected range or objects to the clipboard.
void	editCopyDown() Copies cells in the top row of a selection to the other rows in the selected range and adjusts relative cell references appropriately.
void	editCopyRight() Copies cells in the left column of a selection to the other columns in the selected range and adjusts relative cell references appropriately.
void	editCut() Cuts the selected range or object to the clipboard and clears the range or object from the active worksheet.
void	editDelete(short shift) Deletes the selected range in all selected sheets.
void	editDeleteSheets() Deletes the selected sheets.
void	editInsert(short shiftType) Moves the selected range in all selected worksheets to insert new cells, rows, or columns.
void	editInsertSheets() Inserts one or more new worksheets, depending on the number and position of the currently selected worksheets.
void	editPaste() Pastes the contents of the clipboard to the selected range.
void	editPaste(boolean bDone) Pastes the contents of the clipboard to the selected range.
void	editPaste(short what) Pastes data from the clipboard to the selected range.
void	endEdit() Ends edit mode and applies changes to the active cell.
java.lang.String	errorNumberToText(short error) Returns a string containing the text corresponding to the specified error number.
void	filePrint(boolean showPrintDlg) Prints the selected worksheet.
void	filePrint(boolean showPrintDlg, java.lang.Object job) Prints the selected worksheet to the passed-in Printer Job.
FindReplaceInfo	find(java.lang.String findWhat, int flags) Finds the first cell containing the specified text, starting with the active cell.
FindReplaceInfo	findFirst(int sheet1, int row1, int col1, int sheet2, int row2, int col2, java.lang.String findWhat, int flags) Finds the first cell in the specified sheet for the given range.
FindReplaceInfo	findFirst(int row1, int col1, int row2, int col2, java.lang.String findWhat, int flags) Finds the first cell in the current sheet for the given range.
FindReplaceInfo	findFirst(java.lang.String findWhat, int flags) Finds the first cell containing the specified text.
FindReplaceInfo	findNext(java.lang.String findWhat, int flags) Finds the next cell containing the specified text.
FindReplaceInfo	findNext(java.lang.String findWhat, int flags, FindReplaceInfo info) Finds the next cell containing the specified text.
void	flushModifiedEvents() Sends modified events to ModifiedListeners and clears the flags indicating that the events needed to be sent.
java.lang.String	formatRCNr(int row, int col, boolean doAbsolute) Returns a string containing a formatted row and column reference.
RangeRef	formulaToRangeRef(java.lang.String formula) Creates and returns an instance of RangeRef from a formula, in US English.
RangeRef	formulaToRangeRefLocal(java.lang.String formula) Creates and returns an instance of RangeRef from a formula, in the user's local language.
void	freezePanes(int topRow, int leftCol, int splitRow, int splitCol, boolean splitView) Sets frozen panes at the specified position.
CellRef	getActiveCell() Deprecated. Replaced by GetActiveCellEx().
Range	getActiveCellEx() Returns the range of the active cell.
Range	getActiveCellEx(Range dst) Returns the range of the active cell.
int	getActiveCol() Returns the column of the active cell.
int	getActivePane() Returns the active pane.
int	getActiveRow() Returns the row of the active cell.
java.lang.String	getApplicationName() Returns the application name.
CellFormat	getAppliedCellFormat(int sheet, int row, int col) Returns the format of the specified cell into the specified CellFormat object taking into consideration any conditional formats.
java.lang.String	getAutoFillItems(int index) Returns an autofill list.
int	getAutoFillItemsCount() Returns the number of existing autofill lists.
AutoFilter	getAutoFilter() Returns the AutoFilter that is on the current worksheet, or null if there is no AutoFilter.
Book	getBook() Returns the Book attached to this BookModel.
BookModel	getBookModelImpl() Returns the BookModelImpl for this BookModel.
int	getBookProtectionFlags() Returns a set of flags indicating which actions are protected on this workbook when protection is enabled.
BookView	getBookView() Returns the view info associated with this BookModel.
CellFormat	getCellFormat() Returns the format of the selected range of cells.
void	getCellFormat(CellFormat cellFormat) Returns the format of the selected range of cells into the specified CellFormat object.
void	getCellFormat(CellFormat cellFormat, int row1, int col1, int row2, int col2) Returns the format of the specified range of cells into the specified CellFormat object.
void	getCellFormat(CellFormat cellFormat, int sheet1, int row1, int col1, int sheet2, int row2, int col2) Returns the format of the specified range of cells in the specified range of sheets into the specified CellFormat object.
CellFormat	getCellFormat(int row1, int col1, int row2, int col2) Returns the format of the specified range of cells.
CellFormat	getCellFormat(int sheet1, int row1, int col1, int sheet2, int row2, int col2) Returns the format of the specified range of cells in the specified range of sheets.
java.lang.String	getCellText() Returns a text representation of the value of the active cell.
java.lang.String	getClip() Convert selected cells to a tab-delimited text string using the formats assigned to the selected cells.
java.lang.String	getClipValues() Converts selected cells to a tab-delimited string ignoring any formatting which exists in the selected cells.
int	getCol() Returns the active column in the active worksheet.
int	getColOutlineLevel(int col) Returns the outline level of a single specified column.
java.lang.String	getColText(int col) Returns the label for a column.
int	getColWidth(int col) Returns the width of a single column.
int	getColWidthTwips(int col) Returns the width of the specified column in twips.
short	getColWidthUnits() Returns whether column widths are stored and displayed in twips or character units.
ConditionalFormat[]	getConditionalFormats() Returns the conditional formats for the current selection.
DataRangeCollection	getDataRangeCollection(int sheet) Returns the data range collection associated with the specified sheet.
DataRangeModel	getDataRangeModel() Returns a reference to the DataRange model.
DataSourceCollection	getDataSourceCollection() Returns the data source collection associated with this BookModel (JBook).
int	getDefaultColWidth() Returns the default column width.
java.lang.String	getDefaultFontName() Returns the name of the default font.
int	getDefaultFontSize() Returns the size of the default font.
int	getDefaultRowHeight() Returns the default height for rows.
java.lang.String	getDefinedName(int name) Returns the defined name for the specified index number.
java.lang.String	getDefinedName(java.lang.String name) Returns the definition associated with the specified name, in US English.
int	getDefinedNameCount() Returns the number of defined names in a view.
java.lang.String	getDefinedNameLocal(java.lang.String name) Returns the definition of a defined name in the user's local language.
DrawingModel	getDrawing() Returns a reference to the drawing model.
java.lang.String	getEntry() Returns the contents of the active cell in the first selected worksheet in edit mode format.
java.lang.String	getEntry(int row, int col) Returns the text value of the specified cell in the current worksheet in edit mode format.
java.lang.String	getEntry(int sheet, int row, int col) Returns the value of the specified cell on the specified worksheet in edit mode format.
java.lang.String	getEntry(java.lang.String location) Returns the value of the specified cell in edit mode format.
java.lang.String	getFileName() Returns the name of the workbook file currently loaded.
NumberFormat	getFirstNumberFormat() Returns a NumberFormat object representing the first entry in the workbook's number format table.
GRObject	getFirstObject() Deprecated. Replaced by com.f1j.drawing.Drawing.getShapeCount() and com.f1j.drawing.Drawing.getShape(int).
int	getFixedCol() Deprecated. Replaced by isFrozenPanes() and getLeftCol(int).
int	getFixedCols() Deprecated. Replaced by isFrozenPanes() and getSplitPos().
int	getFixedRow() Deprecated. Replaced by isFrozenPanes() and getTopRow(int).
int	getFixedRows() Deprecated. Replaced by isFrozenPanes() and getSplitPos().
java.lang.String	getFormattedText() Returns the formatted text value of the active cell.
java.lang.String	getFormattedText(int row, int col) Returns the formatted text value of the specified cell.
java.lang.String	getFormattedText(int sheet, int row, int col) Returns the value of the specified cell as it appears in the specified worksheet.
java.lang.String	getFormula() Returns the formula of the active cell.
java.lang.String	getFormula(int row, int col) Returns the text of the formula of the specified cell, in US English.
java.lang.String	getFormula(int sheet, int row, int col) Returns the text of the formula of the specified cell in the specified sheet, in US English.
java.lang.String	getFormulaLocal() Returns the text of the formula of the active cell, in the user's language.
java.lang.String	getFormulaLocal(int row, int col) Returns the text of the formula of the specified cell, in the user's language.
java.lang.String	getFormulaLocal(int sheet, int row, int col) Returns the text of the formula of the specified cell in the specified sheet, in the user's language.
java.lang.String	getGroup() Returns the Group name for the workbook attached to this BookModel.
int	getHeaderHeight() Returns the height of the column headers.
int	getHeaderWidth() Returns the width of the row headers.
java.lang.String	getHyperlinkBase() Returns the hyperlink base string used for relative hyperlinks.
Hyperlink[]	getHyperlinks(int iSheet) Returns an array of hyperlinks for an individual sheet in the book.
int	getIterationMax() Returns the maximum number of calculation iterations.
double	getIterationMaxChange() Returns the maximum iteration change value.
int	getLastCol() Returns the number of the last occupied column.
int	getLastColForRow(int row) Returns the number of the last occupied column in the specified row.
int	getLastRow() Returns the number of the last row that is not empty, including cells that contain only formatting.
int	getLeftCol() Returns the first column currently displayed in this BookModel.
int	getLeftCol(int pane) Returns the left column displayed in the specified pane.
void	getLock() Acquires a lock for the group to which this BookModel belongs.
int	getMaxCol() Returns the last column which may be displayed in the current sheet.
int	getMaxRow() Returns the last row which may be displayed in the current sheet.
int	getMinCol() Returns the first column that can be displayed in the active worksheet.
int	getMinRow() Returns the first row that can be displayed in the active worksheet.
short	getMode() Deprecated. Replaced by com.f1j.drawing.Shape.isDrawingMode() and com.f1j.drawing.DrawingModel.getDrawingModeShape() and com.f1j.drawing.DrawingModel.getDrawingModeType().
int	getNextColPageBreak(int col) Returns the next column where there is a page break.
NumberFormat	getNextNumberFormat(NumberFormat f) Returns a NumberFormat object containing the next entry in the workbook's number format table.
int	getNextRowPageBreak(int row) Returns the next row where there is a page break.
double	getNumber() Returns the numeric value of the active cell.
double	getNumber(int row, int col) Returns the numeric value of the specified cell.
double	getNumber(int sheet, int row, int col) Returns the numeric value of the specified cell in the specified worksheet.
int	getNumSheets() Returns the number of worksheets in the current workbook.
GRObject	getObject(int objectID) Deprecated. Replaced by com.f1j.drawing.DrawingModel.getShape(int).
GRObject	getObject(java.lang.String objectName) Deprecated.
int	getPaletteRGB(int entry) Returns a color in the e.Spreadsheet color palette.
short	getParameterType(int name) Returns the type of the specified parameter.
PivotRangeModel	getPivotRangeModel() Returns a reference to the PivotRange model.
short	getPolyEditMode() Deprecated.
java.lang.String	getPrintArea() Returns the current print area.
java.lang.String	getPrintAreaLocal() Returns the current print area.
double	getPrintBottomMargin() Returns the bottom print margin in inches.
java.lang.String	getPrintFooter() Returns the current page footer.
double	getPrintFooterMargin() Returns the page footer margin used during printing.
java.lang.String	getPrintHeader() Returns the page header printed at the top of each page.
double	getPrintHeaderMargin() Returns the page header margin used during printing.
double	getPrintLeftMargin() Returns the left print margin in inches.
int	getPrintNumberOfCopies() Returns the number copies to print Note: Although methods that set and get print settings are accessible in a GUI-less environment, since printing requires access to a graphical device, methods that implement printing are not usable in environments without access to graphics hardware.
int	getPrintPaperHeight() Returns the height of the paper in twips.
short	getPrintPaperSize() Returns paper size print setting value.
int	getPrintPaperWidth() Returns the width of the paper in twips.
double	getPrintRightMargin() Returns the right print margin in inches.
int	getPrintScale() Returns the scale factor for the active worksheet.
int	getPrintScaleFitHPages() Returns the number of horizontal pages to which the print job is fit.
int	getPrintScaleFitVPages() Returns the number of vertical pages to which the print job is fit.
int	getPrintStartPageNumber() Returns the number displayed on the first page printed.
java.lang.String	getPrintTitles() Returns the print titles to be printed at the top of each page, in US English.
java.lang.String	getPrintTitlesLocal() Returns the print titles to be printed at the top of each page, in the user's language.
double	getPrintTopMargin() Returns the top print margin in inches.
Range	getRange(int row1, int col1, int row2, int col2) Returns a Range object for the specified coordinates on the current worksheet.
Range	getRange(int sheet1, int row1, int col1, int sheet2, int row2, int col2) Returns a Range object for the specified coordinates on the current worksheet.
ReadResults	getReadResults() Deprecated. Replaced by Document.getDocumentSaveOptions(),