Holger's Java API

## Uses of Class
com.antelmann.ooffice.OfficeException

Packages that use OfficeException
com.antelmann.db: This package contains generally useful classes for generic database management.
com.antelmann.net.mail: The classes in this package are designed to ease the handling of emails.
com.antelmann.ooffice: The classes in this package are to be used in conjunction with OpenOffice.

Uses of OfficeException in com.antelmann.db

Methods in com.antelmann.db that throw OfficeException
`static TableModel` `DBUtils.createMappingInfoModel(Database<?> db)`
`static TableModel` `DBUtils.createMappingInfoModel(Database<?> db, Monitor mon)`

Uses of OfficeException in com.antelmann.net.mail

Methods in com.antelmann.net.mail that throw OfficeException
`Email` `HtmlEmailExtractor.generateEmail(AbstractOfficeDocument doc)`

Uses of OfficeException in com.antelmann.ooffice

Methods in com.antelmann.ooffice that throw OfficeException
`void` `OOWriter.alignParagraph(ParagraphAlignment alignment)` uses the view cursor
`void` `OOWriter.alignParagraph(com.sun.star.text.XTextRange cursor, ParagraphAlignment alignment)`
`int` `OOTableWriter.appendRows(String tableName, int count)` returns the number of rows in the given table including the appended rows
`static void` `Cell.Format.applyFormat(OOCalc calc, Object cellOrRange, int formatNumber)`
`void` `Underline.applyTo(Object obj)`
`void` `ParagraphAlignment.applyTo(Object obj)`
`void` `CharacterFormat.applyTo(Object obj)`
`void` `Cell.Format.applyTo(OOCalc calc, Object cellOrRange)`
`void` `Cell.Format.applyTo(OOCalc calc, Object cellOrRange, Locale locale)` works for `XCell` or `XCellRange` objects
`static Properties` `OfficeUtils.asProperties(com.sun.star.beans.XPropertySet pset)`
`TableModel` `OOCalc.asTableModel(int sheet, String namedRange, boolean firstRowIsHeaderRow, boolean useDisplayValue)`
`TableModel` `OOCalc.asTableModel(int sheet, com.sun.star.table.XCellRange range, boolean firstRowIsHeaderRow, boolean useDisplayValue)`
`TableModel` `OOTableWriter.asTableModel(String table, boolean firstRowIsHeader)`
`TableModel` `OOCalc.asTableModel(String sheet, String namedRange, boolean firstRowIsHeaderRow, boolean useDisplayValue)`
`TableModel` `OOCalc.asTableModel(String sheet, com.sun.star.table.XCellRange range, boolean firstRowIsHeaderRow, boolean useDisplayValue)`
`static File` `OOWriter.convertToPDF(File writerFile, File pdfFile)` converts the file w/o showing the GUI (the returned file ensures a .pdf ending)
`void` `OOCalc.copy(com.sun.star.table.XCellRange source, com.sun.star.table.XCell target)`
`void` `OOTableWriter.copyCellText(com.sun.star.table.XCell origin, com.sun.star.table.XCell target)`
`static com.sun.star.uno.XComponentContext` `OfficeConnector.createRemoteContext(String host)`
`static com.sun.star.uno.XComponentContext` `OfficeConnector.createRemoteContext(String host, int port)`
`static com.sun.star.uno.XComponentContext` `OfficeConnector.createSocketContext(File ooProgramDir)`
`static com.sun.star.uno.XComponentContext` `OfficeConnector.createSocketContext(File ooProgramDir, long timeout)` transparently creates a local office process (if required), drains its output and connects to it
`void` `OOWriter.deleteImage(String imageName)`
`void` `OOCalc.deleteImage(com.sun.star.sheet.XSpreadsheet sheet, String name)`
`int` `OOTableWriter.deleteRows(String tableName, int atRow, int count)` returns the number of rows in the given table including the inserted rows
`void` `OOTableWriter.deleteTable(String tableName)`
`Object` `AbstractOfficeDocument.dispatchCommand(String command)`
`Object` `AbstractOfficeDocument.dispatchCommand(String command, Map<?,?> props)`
`Object` `AbstractOfficeDocument.dispatchCommand(String command, OfficeUtils.TargetFrame targetFrame, Map<?,?> props)`
`Object` `OfficeDocument.dispatchCommand(String command, String targetFrame, Map<?,?> props)` allows to dispatch a UNO command on the document
`Object` `AbstractOfficeDocument.dispatchCommand(String command, String targetFrame, Map<?,?> props)` allows to dispatch a UNO command on the document.
`String` `AbstractOfficeDocument.exportAsHTMLString()`
`String` `AbstractOfficeDocument.exportAsString()`
`byte[]` `AbstractOfficeDocument.exportFormat(String format)`
`byte[]` `AbstractOfficeDocument.exportHTML()`
`byte[]` `AbstractOfficeDocument.exportPDF()`
`void` `AbstractOfficeDocument.exportToHTML(File file)` deletes the target file (the name extension will be pdf) if it exists
`File` `OfficeDocument.exportToPDF(File file)`
`File` `AbstractOfficeDocument.exportToPDF(File file)` deletes the target file (the name extension will be pdf) if it exists
`Object` `OOWriter.findFirst(String searchText, boolean caseSensitive)` finds and returns an object that represents the search result based on the given text.
`Object` `OOWriter.findNext(Object previousSearchResult, String searchText, boolean caseSensitive)` sets the view cursor to the next occurrence found for further handling (as a side-effect)
`static LinkedList<Class<?>>` `OfficeUtils.findQueryPath(Object obj, Class<?> targetClass)`
`Iterator<Cell>` `OOCalc.findTextCells(int sheet, Filter<? super Cell> filter)`
`void` `OOCalc.formatCell(com.sun.star.table.XCell cell, Font font)`
`void` `OOCalc.formatCell(com.sun.star.table.XCellRange range, Font font)`
`void` `OOWriter.formatText(CharacterFormat format)` uses the view cursor
`void` `OOWriter.formatText(Color color)` uses the view cursor
`void` `OOWriter.formatText(Font font)`
`void` `AbstractOfficeDocument.formatText(Object obj, Color color)`
`void` `AbstractOfficeDocument.formatText(Object obj, float size)`
`void` `AbstractOfficeDocument.formatText(Object obj, Font font)`
`void` `AbstractOfficeDocument.formatText(Object obj, Underline ul)`
`void` `OOWriter.formatText(Underline ul)` uses the view cursor
`void` `OOWriter.formatText(com.sun.star.text.XTextRange cursor, CharacterFormat format)`
`void` `OOWriter.formatText(com.sun.star.text.XTextRange cursor, Color color)`
`void` `OOWriter.formatText(com.sun.star.text.XTextRange cursor, Font font)`
`void` `OOWriter.formatText(com.sun.star.text.XTextRange cursor, Underline ul)`
`void` `OOWriter.formatTextBackground(Color color)` uses the view cursor
`void` `OOWriter.formatTextBackground(com.sun.star.text.XTextRange cursor, Color color)`
`void` `OOCalc.freezePosition(Cell.Location location)`
`static com.sun.star.lang.XComponent` `OfficeUtils.getActiveComponent()`
`static OOWriter` `OOWriter.getActiveDocument()` seeks the currently active document on the desktop (if any) and returns it
`static OODraw` `OODraw.getActiveDocument()` seeks the currently active document on the desktop (if any) and returns it
`static OOCalc` `OOCalc.getActiveDocument()` seeks the currently active document on the desktop (if any) and returns it
`com.sun.star.text.XTextCursor` `OOWriter.getBookmarkCursor(String bookmark)` throws IllegalArgumentException if the bookmark is not found
`com.sun.star.text.XTextRange` `OOWriter.getBookmarkRange(String bookmark)` may return null if the bookmark is not found
`String` `OOWriter.getBookmarkText(String bookmark)`
`OOCalc` `OfficeComponent.getCalc()` a convenience method that accesses the embedded office component as an OOSpreadsheet instance; this only works if indeed a Calc document was previously loaded
`Cell` `OOCalc.getCell(int sheetNo, int row, int column)`
`Cell` `OOCalc.getCell(int sheet, String name)`
`Cell` `OOCalc.getCell(String namedRange)`
`Cell` `OOTableWriter.getCell(String tableName, int row, int column)`
`Cell` `OOCalc.getCell(String sheet, int row, int column)`
`Cell` `OOTableWriter.getCell(String tableName, String cellName)`
`Cell` `OOCalc.getCell(String sheet, String name)`
`Cell` `OOTableWriter.getCellForBookmark(String bookmark)`
`Cell` `OOTableWriter.getCellForCursor(com.sun.star.text.XTextCursor cursor)`
`String` `OOTableWriter.getCellNameFor(String bookmark)`
`String` `OOTableWriter.getCellNameFor(com.sun.star.table.XCell cell)`
`String[]` `OOTableWriter.getCellNamesFor(String tableName)`
`com.sun.star.table.XCellRange` `OOCalc.getCellRange(int sheet, Rectangle cellRange)`
`com.sun.star.table.XCellRange` `OOCalc.getCellRange(int sheet, String cellRangeName)`
`com.sun.star.table.XCellRange` `OOCalc.getCellRange(String namedRange)`
`com.sun.star.table.XCellRange` `OOCalc.getCellRange(String sheet, String cellRangeName)`
`String` `OOTableWriter.getCellText(com.sun.star.table.XCell cell)`
`int` `OOWriter.getCharacterCount()`
`String` `OOWriter.getClipboardAsString()` retrieves the UTF text content from the office clipboard
`Object` `OOCalc.getColumn(int sheet, int column)`
`int` `OOCalc.getColumnWidth(int sheet, int column)`
`static com.sun.star.frame.XComponentLoader` `OfficeUtils.getComponentLoader()`
`static com.sun.star.uno.XComponentContext` `OfficeConnector.getContext()` returns the cached context maintained in this class.
`com.sun.star.text.XTextCursor` `OOTableWriter.getCursorForCell(com.sun.star.table.XCell cell)`
`com.sun.star.text.XTextCursor` `OOWriter.getCursorForText(String txt, boolean caseSensitive)`
`static com.sun.star.frame.XDesktop` `OfficeConnector.getDesktop()`
`Properties` `AbstractOfficeDocument.getDocumentProperties()`
`String` `OOWriter.getFieldText(String fieldName)` the fully quantified field name is to be supplied
`Cell` `OOCalc.getFirstCell(int sheetNo, String cellRangeName)` returns the upper-left corner cell for the given range
`Cell` `OOCalc.getFirstCell(String sheet, String cellRangeName)` returns the upper-left corner cell for the given range
`Font` `OOWriter.getFont()`
`Font` `AbstractOfficeDocument.getFont(Object obj)`
`Font` `OOWriter.getFont(com.sun.star.text.XTextRange cursor)`
`BufferedImage` `OOWriter.getImage(String imageName)`
`Object` `OOCalc.getImageByName(com.sun.star.sheet.XSpreadsheet sheet, String name)`
`String[]` `OOCalc.getImageNames(com.sun.star.sheet.XSpreadsheet sheet)`
`Object` `OOWriter.getImageObject(String imageName)`
`Cell` `OOCalc.getLastCellForRange(int sheetNo, int startRow, int startColumn, int endRow, int endColumn)`
`String[]` `OOCalc.getNamedCellRanges()`
`int` `OOTableWriter.getNumberOfColumns(String tableName)`
`int` `OOTableWriter.getNumberOfRows(String tableName)`
`OfficeDocument` `OfficeComponent.getOfficeDocument()`
`int` `OOWriter.getParagraphCount()`
`Rectangle` `OOCalc.getPosition(com.sun.star.table.XCell cell)` provides the position in pixel
`Rectangle` `OOCalc.getPosition(com.sun.star.table.XCellRange range)` provides the position in pixel
`static Properties` `OfficeUtils.getProperties(Object obj)`
`Object` `OOCalc.getRow(int sheet, int row)`
`int` `OOCalc.getRowHeight(int sheet, int row)`
`com.sun.star.sheet.XSpreadsheet` `OOCalc.getSheet(int index)`
`com.sun.star.sheet.XSpreadsheet` `OOCalc.getSheet(String name)`
`int` `OOCalc.getSheetFor(String namedRange)`
`com.sun.star.text.XTextTable` `OOTableWriter.getTable(String tableName)`
`com.sun.star.text.XTextTable` `OOTableWriter.getTableFor(com.sun.star.table.XCell cell)`
`String` `OOTableWriter.getTableNameFor(String bookmark)`
`String` `OOTableWriter.getTableNameFor(com.sun.star.table.XCell cell)`
`List<com.sun.star.text.XTextFrame>` `OOWriter.getTextFrames()` provides convenience for sticker label printing
`Map<String,String>` `OOWriter.getUserFieldContent()`
`String` `OOWriter.getUserFieldText(String userFieldName)`
`int` `OOWriter.getWordCount()`
`OOWriter` `OfficeComponent.getWriter()` a convenience method that accesses the embedded office component as an OOWriter instance; this only works if indeed a Writer document was previously loaded
`static Object` `OfficeUtils.getXPropertyValue(Object obj, String key)`
`com.sun.star.text.XTextViewCursor` `OOWriter.gotoBookmark(String bookmark)` sets the view cursor to the given bookmark
`void` `OOCalc.gotoEnd()`
`boolean` `OOWriter.gotoFirst(String searchText, boolean caseSensitive)` sets the view cursor to the first occurrence of the given String (as a side-effect), so that the view cursor can be used to further handle the occurrence.
`void` `OOCalc.insert(int sheet, Rectangle cellRange, Direction moveDirection)`
`void` `OOCalc.insert(com.sun.star.table.XCellRange range, Direction moveDirection)`
`void` `OOWriter.insertBookmark(String bookmarkName, com.sun.star.text.XTextRange range)`
`void` `OOWriter.insertContent(InputStream in, com.sun.star.text.XTextRange cursor)` inserts some content into the given location; for example, the content could represent HTML
`void` `OOWriter.insertContent(Object content, com.sun.star.text.XTextRange cursor)`
`void` `OOWriter.insertContent(String content, com.sun.star.text.XTextRange cursor)` inserts the given content via ByteArrayInputStream
`void` `OOWriter.insertFileAt(File file, com.sun.star.text.XTextRange cursor)` inserts one document into another
`Object` `OOWriter.insertImage(File file, com.sun.star.text.XTextRange cursor, AnchorType at)`
`Object` `OOWriter.insertImage(File file, com.sun.star.text.XTextRange cursor, AnchorType at, boolean embed)`
`Object` `OOWriter.insertImage(File file, com.sun.star.text.XTextRange cursor, AnchorType at, boolean embed, Map<?,?> props)`
`Object` `OOWriter.insertImage(File file, com.sun.star.text.XTextRange cursor, AnchorType at, Map<?,?> props)`
`Object` `OOWriter.insertImage(Image image, com.sun.star.text.XTextRange cursor, AnchorType at)`
`Object` `OOWriter.insertImage(Image image, com.sun.star.text.XTextRange cursor, AnchorType at, Map<?,?> props)` automatically sets the Width and Height properties unless an explicit value was given
`String` `OOCalc.insertImage(int sheet, Image image, Point point)`
`String` `OOCalc.insertImage(int sheet, URL url, Rectangle rectangle)`
`Object` `OOWriter.insertImage(URL url, com.sun.star.text.XTextRange cursor, AnchorType at, boolean embed, Map<?,?> props)` allows to insert an image into the document.
`Object` `OOWriter.insertImage(URL url, com.sun.star.text.XTextRange cursor, AnchorType at, boolean embed, Map<?,?> props, String name)` allows to insert an image into the document.
`Object` `OOWriter.insertImage(URL url, com.sun.star.text.XTextRange cursor, AnchorType at, Map<?,?> props)`
`String` `OOCalc.insertImage(com.sun.star.sheet.XSpreadsheet sheet, URL url, Rectangle rectangle)`
`String` `OOCalc.insertImage(com.sun.star.sheet.XSpreadsheet sheet, URL url, Rectangle rectangle, String name)`
`void` `OOWriter.insertPageBreakAfter(com.sun.star.text.XTextRange cursor)` inserts a page break after the current paragraph of the given cursor
`void` `OOWriter.insertPageBreakBefore(com.sun.star.text.XTextRange cursor)` inserts a page break before the current paragraph of the given cursor
`int` `OOTableWriter.insertRows(String tableName, int atRow, int count)` returns the number of rows in the given table including the inserted rows
`int` `OOTableWriter.insertRowsAtBookmark(String bookmark, int count)`
`String` `OOTableWriter.insertTable(int rows, int columns)` uses the view cursor
`String` `OOTableWriter.insertTable(int rows, int columns, com.sun.star.text.XTextRange position)` the table is inserted at the start of the given position and the name of the table is returned.
`String` `OOTableWriter.insertTableModel(TableModel model)` uses the view cursor
`String` `OOTableWriter.insertTableModel(TableModel model, com.sun.star.text.XTextRange position)` inserts the model at the given location and returns the name of the table
`void` `OOWriter.insertUrlAt(URL url, com.sun.star.text.XTextRange cursor)` inserts one document into another
`boolean` `OOCalc.isColumnVisible(int sheet, int column)`
`boolean` `OOWriter.isEmbeddedImage(String imageName)`
`boolean` `OOCalc.isManualPageBreak(com.sun.star.table.XCell cell)` determines whether there has been a manual page break set for the row of the given cell.
`boolean` `OOCalc.isRowVisible(int sheet, int row)`
`Iterator<com.sun.star.text.XTextCursor>` `OOWriter.iterate(String searchText, boolean caseSensitive)` iterates over all occurrences of the given text and provides the corresponding cursors.
`ArrayList<Cell>` `OOCalc.listCells(com.sun.star.table.XCellRange range)`
`static OODraw` `OODraw.load(File file, boolean hidden)`
`void` `OfficeComponent.load(InputStream in)`
`void` `OfficeComponent.load(InputStream in, Map<?,?> props)`
`void` `OfficeComponent.load(String unoURL, Map<?,?> properties)`
`static OODraw` `OODraw.load(URL url, boolean hidden)`
`void` `OfficeComponent.load(URL url, Map<?,?> properties)`

`static

`<T> T`

`

`OfficeUtils.loadDocument(Class<T> type, File file, Map<?,?> props, OfficeUtils.TargetFrame target, int searchFlag)`

`static

`<T> T`

`

`OfficeUtils.loadDocument(Class<T> type, InputStream in, Map<?,?> props, OfficeUtils.TargetFrame target, int searchFlag)`

`static

`<T> T`

`

`OfficeUtils.loadDocument(Class<T> type, String unoUrl, Map<?,?> props, OfficeUtils.TargetFrame target, int searchFlag)`

`static

`<T> T`

`

`OfficeUtils.loadDocument(Class<T> type, URL url, Map<?,?> props, OfficeUtils.TargetFrame target, int searchFlag)`

`void` `OfficeComponent.loadFile(File file)`
`void` `OfficeComponent.loadFileAsTemplate(File file)`
`void` `OfficeComponent.loadFileReadOnly(File file)`
`void` `OfficeComponent.loadNewDocument(OODocType type)`
`void` `OfficeComponent.loadNewDocument(OODocType type, Map<?,?> props)`
`void` `OfficeComponent.loadURLAsTemplate(URL url)`
`Cell` `OOTableWriter.mergeWithRightCell(com.sun.star.table.XCell cell)` merges the given cell with the one to its right.
`void` `OOCalc.move(com.sun.star.table.XCellRange source, com.sun.star.table.XCell target)`
`static OOWriter` `OOWriter.open(File file)` opens a document for editing
`static OOWriter` `OOWriter.open(File file, boolean hidden)` opens a document for editing
`static OOWriter` `OOWriter.open(File file, boolean readOnly, boolean previewMode)` opens a document with the specified options
`static OOCalc` `OOCalc.open(File file, boolean readOnly, boolean previewMode)` opens a document with the specified options
`static OOCalc` `OOCalc.openFile(File file)` opens a document for editing
`static OOCalc` `OOCalc.openFile(File file, boolean hidden)` opens a document for editing
`static OOWriter` `OOWriter.openReadOnly(File file)` opens a document in read-only mode
`static OOCalc` `OOCalc.openReadOnly(File file)` opens a document in read-only mode
`com.sun.star.table.XCellRange` `OOCalc.placeTableModel(TableModel model, Cell.Location upperLeftCorner, boolean includeHeader, Monitor mon)`
`com.sun.star.table.XCellRange` `OOCalc.placeTableModel(TableModel model, int sheet, int row, int column, boolean includeHeader)`
`com.sun.star.table.XCellRange` `OOCalc.placeTableModel(TableModel model, int sheet, String range, boolean includeHeader)`
`void` `OOTableWriter.placeTableModel(TableModel model, String table, int startingRow, int startingColumn, boolean withHeader)` places the model into the given table starting at the given position; additional rows are inserted as needed
`com.sun.star.table.XCellRange` `OOCalc.placeTableModel(TableModel model, String sheet, int row, int column, boolean includeHeader)`
`com.sun.star.table.XCellRange` `OOCalc.placeTableModel(TableModel model, String sheet, int row, int column, boolean includeHeader, Monitor mon)`
`com.sun.star.table.XCellRange` `OOCalc.placeTableModel(TableModel model, String sheet, String range, boolean includeHeader)`
`com.sun.star.table.XCellRange` `OOCalc.placeTableModel(TableModel model, com.sun.star.table.XCell upperLeftCorner, boolean includeHeader, Monitor mon)` places the given model into the spreadsheet with the upper left corner at the given location
`void` `AbstractOfficeDocument.print()`
`void` `OfficeDocument.print(String printerName, int count)`
`Cell` `OOTableWriter.relativeMove(com.sun.star.table.XCell cell, Direction direction, int amount)` supported directions are `Direction.get2Dimensionals()`
`Cell` `OOCalc.relativeMove(com.sun.star.table.XCell cell, Direction direction, int count)`
`Cell` `OOCalc.relativeMove(com.sun.star.table.XCell cell, int xOffset, int yOffset)`
`void` `OOCalc.remove(int sheet, Rectangle cellRange, Direction moveDirection)`
`void` `OOCalc.remove(com.sun.star.table.XCellRange range, Direction moveDirection)`
`void` `OOCalc.removeSheet(int index)`
`void` `OOCalc.removeSheet(String name)`
`void` `OOCalc.renameSheet(int index, String newName)`
`void` `OOCalc.renameSheet(String oldName, String newName)`
`void` `AbstractOfficeDocument.save()`
`void` `OOWriter.setBackgroundColor(Color c)` sets the background color for the standard page
`void` `OOWriter.setBookmarkText(String bookmark, String text)` sets the text of for a defined bookmark within the given document
`void` `OOWriter.setBorder(Object obj, CellBorder border)`
`void` `OOCalc.setCellAligment(com.sun.star.table.XCell cell, ParagraphAlignment alignment)`
`void` `OOTableWriter.setCellBackground(com.sun.star.table.XCell cell, Color color)`
`void` `OOCalc.setCellBackground(com.sun.star.table.XCell cell, Color color)`
`void` `OOTableWriter.setCellBackground(com.sun.star.table.XCell cell, String imageURL)`
`void` `OOTableWriter.setCellBorder(com.sun.star.table.XCell cell, CellBorder border)`
`void` `OOCalc.setCellBorder(com.sun.star.table.XCell cell, CellBorder border)`
`void` `OOCalc.setCellBorder(com.sun.star.table.XCellRange range, CellBorder border)`
`void` `OOCalc.setCellDate(com.sun.star.table.XCell cell, Date date)`
`void` `OOCalc.setCellDateTime(com.sun.star.table.XCell cell, Date date)`
`void` `OOCalc.setCellFormat(com.sun.star.table.XCell cell, Cell.Format format)`
`void` `OOCalc.setCellFormat(com.sun.star.table.XCell cell, CharacterFormat option)`
`void` `OOCalc.setCellFormat(com.sun.star.table.XCellRange range, Cell.Format format)`
`void` `OOCalc.setCellFormat(com.sun.star.table.XCell cell, Underline option)`
`void` `OOCalc.setCellProperty(com.sun.star.table.XCellRange range, String key, Object value)`
`void` `OOCalc.setCellProperty(com.sun.star.table.XCell cell, String key, Object value)`
`com.sun.star.text.XText` `OOTableWriter.setCellText(String tableName, int row, int column, String text)` returns the text component of the target cell for further handling
`com.sun.star.text.XText` `OOTableWriter.setCellText(String tableName, String cellName, String text)` returns the text component of the target cell for further handling
`void` `OOCalc.setCellText(com.sun.star.table.XCell cell, String text)`
`void` `OOCalc.setCellTextColor(com.sun.star.table.XCell cell, Color color)`
`void` `OOCalc.setCellTime(com.sun.star.table.XCell cell, Date date)`
`void` `OOCalc.setCellTime(com.sun.star.table.XCell cell, long millis)`
`void` `OOCalc.setCellTime(com.sun.star.table.XCell cell, TimeInDay time)`
`void` `OOCalc.setCellValue(com.sun.star.table.XCell cell, Number value, String format)` cell, value and format must not be null
`void` `OOCalc.setCellValue(com.sun.star.table.XCell cell, Object value)` makes a best effort to set the cell's value using an appropriate format
`void` `OOCalc.setCellValue(com.sun.star.table.XCell cell, String value, Cell.Format format)` cell, value and format must not be null
`void` `OOCalc.setColumnVisible(int sheet, int column, boolean visible)`
`void` `OOCalc.setColumnWidth(int sheet, int column, int width)`
`void` `OOWriter.setFieldText(String fieldName, String text)` the fully quantified field name is to be supplied
`void` `OOTableWriter.setKeepTogether(String tableName, boolean flag)`
`void` `OOCalc.setManualPageBreak(com.sun.star.table.XCell cell, boolean flag)` #see `OOCalc.isManualPageBreak(XCell)`
`void` `OOCalc.setNumberFormat(com.sun.star.table.XCellRange range, String numberFormatString)`
`void` `OOCalc.setNumberFormat(com.sun.star.table.XCell cell, String numberFormatString)`
`void` `OOCalc.setOptimalColumnWidth(int sheet, int column)`
`void` `OOCalc.setOptimalColumnWidth(com.sun.star.sheet.XSpreadsheet sheet, int column)`
`static void` `AbstractOfficeDocument.setPropertyValue(Object obj, String key, Object value)`
`void` `OOTableWriter.setRepeatHeaderline(String tableName, boolean flag)`
`void` `OOCalc.setRowHeight(int sheet, int row, int width)`
`void` `OOCalc.setRowVisible(int sheet, int row, boolean visible)`
`void` `OOCalc.setSelectedRange(String range)`
`static void` `OfficeConnector.setSocketContext(File ooProgramDir)` creates a socket context on the given path and directly sets the same to be available upon subsequent calls to `OfficeConnector.getContext()`
`void` `OOTableWriter.setTableProperty(String tableName, String key, Object value)`
`void` `OOWriter.setUserFieldContent(Map<?,?> fields)` sets the field content of the field variables contained in the map.
`void` `OOWriter.setUserFieldText(String userFieldName, String text)`
`void` `OOWriter.setWatermark(File imageFile)` sets the watermark in the middle of the page for the 'Standard' page style
`void` `OOWriter.setWatermark(File imageFile, String pageStyle)`
`void` `OOWriter.setWatermark(Image image)`
`void` `OOWriter.setWatermark(Image image, String pageStyle)`
`void` `OOWriter.setWatermark(URL url, String pageStyle)`
`static void` `OfficeUtils.setXPropertyValue(Object obj, String key, Object value)`
`static Process` `OfficeConnector.startOfficeProcess(File ooProgramFolder)`
`static Process` `OfficeConnector.startOfficeProcess(File ooProgramFolder, String acceptOption)` uses the standard options; see `OfficeConnector.getStandardProcessOptions()`
`static Process` `OfficeConnector.startOfficeProcess(File ooProgramFolder, String acceptOption, String[] options)`
`static void` `OfficeUtils.storeComponent(com.sun.star.lang.XComponent component, OutputStream out, Map<?,?> props)`
`static void` `OfficeUtils.storeComponent(com.sun.star.lang.XComponent component, URL url, Map<?,?> props, boolean representNewLocation)`
`File` `AbstractOfficeDocument.storeTo(File file, boolean representNewLocation)` saves the embedded document to the given file - using the default extension, if not already given (and overwriting the file, if it exists)
`void` `AbstractOfficeDocument.storeTo(File file, String filterName, boolean representNewLocation)` saves the given document to the given file (overwriting it, if it exists) in the given format
`void` `OfficeDocument.storeTo(OutputStream out, Map<?,?> map)`
`void` `AbstractOfficeDocument.storeTo(OutputStream out, Map<?,?> props)`
`void` `AbstractOfficeDocument.storeTo(URL url, boolean representNewLocation)` saves the given document to the given url (overwriting the url if it exists)
`void` `OfficeDocument.storeTo(URL url, String filterName, boolean representNewLocation)`
`void` `AbstractOfficeDocument.storeTo(URL url, String filterName, boolean representNewLocation)` allows to specify a filterName that defines the output format (null is allowed).
`Cell` `Cell.Location.toCell(OOCalc calc)`
`Cell` `Cell.Location.toCell(OOTableWriter tw)`
`Cell` `Cell.Location.toCell(OOWriter writer)`
`static String` `OfficeUtils.translateUnoToUrl(String unoUrl)`
`static String` `OfficeUtils.translateUrlToUno(String url)`
`void` `AbstractOfficeDocument.undo()`
`void` `AbstractOfficeDocument.updateAll()` updates all embedded objects within the document

Constructors in com.antelmann.ooffice that throw OfficeException
`OOCalc()` creates a visible blank new spreadsheet
`OOCalc(boolean hidden)` creates a blank new spreadsheet
`OOCalc(boolean previewMode, File template)`
`OOCalc(File template)` creates a visible new document based on the given template file
`OOCalc(File template, boolean hidden)` creates a new document based on the given template file
`OOCalc(File file, Map<?,?> props)` loads a document (the given file) into a blank frame along with the given properties
`OOCalc(InputStream in, boolean hidden)`
`OOCalc(InputStream in, Map<?,?> props)`
`OOCalc(URL templateURL, boolean hidden)` creates a new document based on the given template file
`OOCalc(com.sun.star.lang.XComponent comp)`
`OODraw()` creates a visible blank new drawing
`OODraw(boolean hidden)`
`OODraw(File file, Map<?,?> props)`
`OODraw(InputStream in, Map<?,?> props)` loads a drawing (the given stream) into a blank frame along with the given properties
`OODraw(URL url, boolean hidden)`
`OODraw(URL url, Map<?,?> props)` loads a document (the given file) into a blank frame along with the given properties
`OOWriter()` creates a blank new document
`OOWriter(boolean hidden)`
`OOWriter(boolean previewMode, File file)`
`OOWriter(boolean previewMode, URL url)`
`OOWriter(File template)` creates a new document based on the given template file
`OOWriter(File template, boolean hidden)`
`OOWriter(File file, Map<?,?> props)` loads a document (the given file) into a blank frame along with the given properties
`OOWriter(InputStream in, boolean hidden)`
`OOWriter(InputStream in, Map<?,?> props)`
`OOWriter(URL url, boolean hidden)`
`OOWriter(URL url, Map<?,?> props)` loads a document from the given url into a blank frame along with the given properties.
`OOWriter(com.sun.star.lang.XComponent comp)`

(c) Holger Antelmann since 2001- all rights reserved (contact: info@antelmann.com)
see www.antelmann.com/developer for further details and available downloads