# Andreas Ahammer's OpenOffice.org Examples

Hint: if you wish to look at the ooRexx code with syntax highlighting, then you can use the free and open-source editor `"[g]vim"`, which is available for practically all platforms and can be downloaded from its homepage at http://www.vim.org/.

. <directory> (List of this directory)
  Display all of this directory's files and directories.
.. <directory> (List of parent directory)
  Display all of the parent directory's files and directories.
example01_swriter_openblank.rxo
  Open an empty swriter-file and write "Hello World!".
example01_swriter_openblank_2.rxo
  Open an empty writer document, write some text into it, then close the document.
example02_swriter_openfile.rxo
  Open an existing writer document in read-only mode.
example03a_swriter_print.rxo
  Open an existing writer document hiddenly and print its first page only to the default printer.
example03b_html_print1.rxo
  Open an existing HTML document and print it at the default printer.
example03c_html_print2.rxo
  Open a web document and print its first page at the default printer.
example04_swriter_stats1.rxo
  Open an OOo document from the web, use cursors to count paragraphs, sentences and words.
example05_swriter_stats2.rxo
  Open an OOo document hiddenly, use document properties to retrieve the count of paragraphs, sentences and words.
example06_swriter_text.rxo
  Demonstrate how to use cursors and properties to add and edit text as well as formatting paragraphs.
example07_swriter_table.rxo
  Create a writer document and insert a TextTable into it and edit it.
example08_swriter_textfield.rxo
  Create a writer document and insert TextFields into it.
example09_swriter_replace.rxo
  :oad an existing writer document ("inquiry.odt"), change its content (the title "Inquiry" to "Order"), insert text from another existing document ("orderText.odt"), save the resulting new document under a new name ("order.odt").
example10_swriter_pdf.rxo
  Open an existing writer/text file using OOo's FilePicker service and convert the loaded file to PDF.
example11_scalc_openblank.rxo
  Create a calc/spreadsheet document and insert a text in cell "A1".
example12_scalc_print.rxo
  Load an existing calc/spreadsheet document and define and print a certain area twice.
example13_scalc_formats.rxo
  Create a new calc document, enter a few values, format cells.
example14_scalc_fill.rxo
  Create calc document, fill in values and formulas, use autofill function to extend.
example15_scalc_sort.rxo
  Sort a cell range by columns and by rows, demonstrate how to copy sorted result, cf. http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Sorting.
example16_scalc_database.rxo
  Create calc document, fill in values, filter (a database operation).
example17_scalc_style.rxo
  Create calc document, fill in values; create, insert and apply custom style.
example18_scalc_chart1.rxo
  Load the calc document from example 14, create a simple chart and save to a new file.
example19_scalc_chart2a.rxo
  Load the calc document from example 18, experiment a little bit with the embedded chart.
example19_scalc_chart2b.rxo
  Load the calc document from example 18, experiment a little bit with the embedded chart.
example19_scalc_chart2c.rxo
  Load the calc document from example 18, experiment a little bit with the embedded chart.
example20_sdraw_blank.rxo
  Create a draw document, define a rectangle shape for the first draw page and add text to it.
example21_sdraw_shape.rxo
  Create a draw document, define two shapes, format them, group them and move the group.
example22_sdraw_fill.rxo
  Create a draw document, define a RectangleShape, set XText settings, including a Gradient fill.
example23_sdraw_jpg.rxo
  Open an existing draw document from the Internet and export each page to a *.jpg.
example24_simpress_blank.rxo
  Create an empty impress document and start it.
example25_simpress_presentation.rxo
  Create an empty impress document with two pages (slides), set properties for animations as well.
example26_database_openquery.rxo
  Read data from an existing (OOo-pre-installed) database.
example27_database_msaccess.rxo
  Connect to an existing MS-Access database.
example28_database_mysql.rxo
  This example will only work if you have a `MySQL` database running on port `3306` named `"Test"` with an appropriate setup and correct tables! Furthermore the class "org.gjt.mm.mysql.Driver" has to be installed!
example29_spellchecker.rxo
  Use the OOo spellchecker to check a word.

Rony G. Flatscher, 2010-08-22, Wien/Vienna, Austria, Europe