Weblog

First open openoffice.org, then,

Tools / Options... / LoadSave - General

Under "Default File Format", change the "document Type" and "always save as" settings.

See also: Configure, Change or Set OpenOffice.org to Default Save Files in Microsoft Office Formats for more detailed information.

Labels: Openoffice

By default, the print settings in OpenOffice Calc will print every page in an entire workbook. You can change the print settings to only print one page (the currently viewed page/worksheet) as follows:

1. Tools
2. Options...
3. +OpenOffice.org Calc
4. Print
5. Select "Print only selected Sheets" checkbox

See: Plan-B How to make 'print only selected sheets' the DEFAULT print setting in openoffice calc.

See also: Printing Only the Sheets and Pages You Want, in OpenOffice.org Calc

Labels: Openoffice, Tools

1. Format
2. Page...
3. Click Landscape radio button (by Orientation).

Labels: Openoffice, Tools

In OO 2.2 Calc, there’s a built-in function:

Go to the Insert menu / Sheet From File / select your text file.

Check the options to choose delimiters and column types, etc.

Or, you can copy text file, then "paste special" into Calc to get to the same menu.

Labels: Openoffice, Tools