• How to automatically print or convert to PDF, MS Office or other formats OpenDocument files

    The script and tricks in the ODF scripting section of this website show how to create office-ready texts, presentations and spreadsheets automatically, in the OpenDocument format, which is a worldwide standards. This is all many people need to work today. Sometimes, however, it’s still necessary to either print those documents, or exchange them to somebody in other formats, like PDF or those of the older releases of Microsoft Office (newer releases of this program are already partially compatible with OpenDocument through free plugins, so if your partners have those versions they should really use those plugins, instead of bothering you with requests for drug-like, legacy file formats, but that’s another story).
  • How to make OpenDocument slideshows out of plain text files

    Slideshows are extremely popular as presentation and educational tools, but have a couple of serious problems. The first is readability: let’s admit it, many slideshows are almost unusable. One of the secrets to useful slideshows is terseness. Each slide should contain only a few short points or pictures which summarize the key concepts you want to transmit to the audience with that part of your talk.

    The other big issue with slideshows is that GUI presentation software, be it PowerPoint, OpenOffice Impress, KPresenter or anything else, can be quite time-consuming and distracting, no matter how you use it. Writing bullets and sub bullets as simple text outlines is much faster, even when you’re just pasting together notes you scrabbled on your PDA, email fragments, quotes from Web pages or thoughts of the moment.

  • How to quickly apply color schemes to a spreadsheet with OpenOffice or LibreOffice

    How do you quickly create a spreadsheet where, for example, every other line has a background of a different color? Here are a couple of methods.

    The first one is faster (and works even in controlled environments where you can’t install extensions) if you want white rows alternated with colored ones: define a cell style and apply it only to cells in even (or odd) rows. Here is the detailed procedure:

  • How to import multiple pictures into a text document with OpenOffice or LibreOffice Writer

    This is a way to import multiple pictures into an empty text with OpenOffice Writer, one picture per page, with a database report. install the Sun Report Builder extension create a database in the same directory as the pictures enter or import in the database the file names of the pictures make sure that those names don’t contain special characters or spaces use absolute, full path names to step around a bug in the builder