|
|
NeoOffice Tips and Hints
From NeoWiki
(Difference between revisions)
| Revision as of 15:27, 14 April 2007 (edit) Jgd (Talk | contribs) (→Calc-specific Tips - add Using the Solver Function) ← Previous diff |
Revision as of 19:35, 20 April 2007 (edit) (undo) Jgd (Talk | contribs) (→Calc-specific Tips - Importing and Exporting Comma and Tab Delimited Files) Next diff → |
||
| Line 35: | Line 35: | ||
| * [[Inserting and Editing Notes in Calc|Inserting and Editing Notes in Calc]] | * [[Inserting and Editing Notes in Calc|Inserting and Editing Notes in Calc]] | ||
| * [[Using the Solver Function|Using the Solver function]] | * [[Using the Solver Function|Using the Solver function]] | ||
| + | * [[Importing and Exporting Comma and Tab Delimited Files|Importing and Exporting Comma and Tab Delimited Files]] | ||
| * [http://documentation.openoffice.org/Samples_Templates/User/template_2_x/calc/index.html Templates for Calc] | * [http://documentation.openoffice.org/Samples_Templates/User/template_2_x/calc/index.html Templates for Calc] | ||
Revision as of 19:35, 20 April 2007
About the Different Components of NeoOffice
The items in this section are currently under development
- NeoOffice Writer
- NeoOffice Calc
- NeoOffice Impress
- NeoOffice Draw
- NeoOffice Math
- NeoOffice File Formats - file formats supported by each component
Writer-specific Tips
- Performing calculations in a table within a text document
- Using AutoTexts
- Creating a Table of Contents
- Using a Master Document
- Importing a Calc Sheet into a Writer Table
- Creating a Table of Contents
- How to Number Pages [fr]
- References in NeoOffice Writer [fr]
- References in a Master Document [fr]
- Creating an Index [fr]
Calc-specific Tips
- Adding multiple rows or columns to a spreadsheet
- Computing and graphing a regression line
- Exporting Calc charts or spreadsheets as images
- Inserting a line break in a cell
- Using a Calc spreadsheet as a data source (NeoOffice 2.x)
- Selecting and filling a range of cells
- Importing HTML tables into a Calc document
- Performing Addition with Time-Formatted Cells in Calc
- Converting a Text String to a Number in Calc
- Inserting and Editing Notes in Calc
- Using the Solver function
- Importing and Exporting Comma and Tab Delimited Files
- Templates for Calc
Impress-specific tips
Math-specific tips
- Defining Formula Fonts in NeoOffice
- Formatting Formulas in NeoOffice Math
- Page Setting Formulas in NeoOffice Math
- Using Catalog in NeoOffice Math
Databases
Tips from Trinity
The forums at http://trinity.neooffice.org/ contain many tips, hints, and answers to frequently asked questions. The New Articles Needed page in this wiki contains links to some of the most helpful threads at trinity.
Note that the predominant language of the trinity forums is English, so most if not all of these threads will be in English. At the time of this writing (April 2007), there were French, Spanish, and Italian speakers among the "regulars" at trinity. If you are in need of a summary or explanation of a tip in one of these languages, post a request in the appropriate thread, and someone may be able to help you.
Improving the Mac OS X Experience
- Customizing Menu & Keyboard shortcuts to be more Mac-like
- Customizing the UI font and background color to be more Mac-like
- Searching contents of NeoOffice files
- How to use NeoOffice from somewhere other than your /Applications folder
- Setting the default application for opening OpenOffice.org, Microsoftâ„¢ Officeâ„¢, and other file types
- How to launch directly into particular applications (word processor, spreadsheet, etc.)
- How to use data from the Mac OS X Address Book
- How to use Eudora or Entourage with NeoOffice 2.0
Compatibility and Document Exchange
- Improving Compatibility with Microsoft Office
- Setting the default file format for saving your work
- Using PDF to preserve exact layout, fonts and formatting
- Opening AppleWorks documents
- Converting non-UTF-8 text files
- Using NeoOffice with QuarkXPress and InDesign
- Applications and tools which support OpenDocument
Fonts & Languages
- How to get alternative fonts to expand the range of languages you can use
- Accessing Helvetica Oblique and Courier Oblique (Italic)
- Problems with the Symbol font, Greek text, or bullets in Word documents
- Setting the default font in Calc, Impress, or Draw
- Bidi and vertical text
- Activating the dictionary for your language and using more than one language's dictionary
- Changing the language of the user interface and using a different language from the system language
Printing and Exporting to PDF
- Using the extendedPDF macro with NeoOffice
- Methods of exporting PDF compared
- How to create brochures
Styles and Templates
- Using Page Styles
- Using Character Styles
- Using Paragraph Styles
- How to edit the default styles present in all new documents (as well as tips on styles and templates)
- How do I change the style of the footnote number (and other footnote/endnote style questions)?
Miscellaneous Tips
- Using clipart or photos in NeoOffice
- How do I turn off word auto-completion and other automatic formatting?
- Tips on using Find and Replace
- How to remove marked sections of text
- How to dock the Stylist and other palettes, and how to detach toolbars
- How to close palettes and floating windows
- Using EndNote and other citation or bibliographic software
- How to use equations (including LATEX) in your documents
- Adding Page Numbers [es]
- The Navigator
- Disabling Patch-Checking and Donation Messages
