|
|
New Articles Needed
From NeoWiki
(Difference between revisions)
| Revision as of 09:27, 28 August 2007 (edit) Jgd (Talk | contribs) (→Calc Specific Tips - Change cell reference from vertical to horizontal) ← Previous diff |
Current revision (06:26, 12 January 2010) (edit) (undo) Sardisson (Talk | contribs) (→Miscellaneous Tips - add new article needed for the greeting cards) |
||
| (37 intermediate revisions not shown.) | |||
| Line 9: | Line 9: | ||
| ==Calc Specific Tips== | ==Calc Specific Tips== | ||
| + | <!--[[Adding Controls in Calc]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=37998#37998] and [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=42830#42830] See also [http://openoffice.blogs.com/openoffice/2008/04/creating-a-drop.html this blog post from Solveig Haugland.] Done--> | ||
| + | <!--[[Inserting a Fixed Timestamp in Calc]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=38082#38082] and [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=40824#40824]--><br> | ||
| + | [[Adding a Graphic to a Header in Calc]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=40839#40839] | ||
| + | <!--[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=40194#40194 alternate row color in Calc]<br>--> | ||
| + | <!--[[Changing the Data Range of a Chart]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=5226&highlight=]<br>--> | ||
| <!--[[Parsing Names in Calc]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=27972#27972] | <!--[[Parsing Names in Calc]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=27972#27972] | ||
| :This tip explains how to use Calc's formulas to split a full name (Jane Margaret Doe) in a cell into first, middle, and last names each in their own cell. Done--> | :This tip explains how to use Calc's formulas to split a full name (Jane Margaret Doe) in a cell into first, middle, and last names each in their own cell. Done--> | ||
| <!--[[Importing and Exporting Comma and Tab Delimited Files]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=30103#30103] Done--><br> | <!--[[Importing and Exporting Comma and Tab Delimited Files]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=30103#30103] Done--><br> | ||
| <!--[[Modifying a range of cells by performing math operations]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=4239] the tips have been added to the http://--> | <!--[[Modifying a range of cells by performing math operations]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=4239] the tips have been added to the http://--> | ||
| - | [[Change cell reference from vertical to horizontal]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=4760&highlight=transpose] (use of TRANSPOSE function) | + | <!--[[Change cell reference from vertical to horizontal]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=4760&highlight=transpose] (use of TRANSPOSE function)--> |
| <!--neowiki.neooffice.org/index.php/Fr:Sélection_et_remplissage_d%27une_plage_de_cellules page in French and translated in the English page--> | <!--neowiki.neooffice.org/index.php/Fr:Sélection_et_remplissage_d%27une_plage_de_cellules page in French and translated in the English page--> | ||
| ==Writer Specific Tips== | ==Writer Specific Tips== | ||
| - | [[Putting an Image Behind Text in Writer]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=4720&highlight=] | + | [[Exploiting Calc's consecutive Fill Down in Writer tables]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=41313#41313]<br> |
| - | <br><br> | + | [[Extracting an Image from a Writer or .doc file]] [https://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=45855#45855] |
| + | |||
| + | <!--[[Putting an Image Behind Text in Writer]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=4720&highlight=]Done--> | ||
| + | <!--[[Guide to Outlining]] | ||
| + | [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=45331#45331]Done--> | ||
| + | [[Footnotes in Captions]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=39596#39596]<br> | ||
| + | [[Setting Up Indented Paragraphs]] (e.g., like scriptwriter style) [https://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=51910#51910], [https://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=51911#51911], [https://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=51923#51923]<br> | ||
| ==Database Specific Tips== | ==Database Specific Tips== | ||
| Line 25: | Line 36: | ||
| :Connecting to your FileMaker Pro database from NeoOffice | :Connecting to your FileMaker Pro database from NeoOffice | ||
| - | Exporting databases for FileMaker Pro | + | [[Exporting databases for FileMaker Pro]] |
| [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=35857#35857] | [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=35857#35857] | ||
| :Exporting your NeoOffice database for FileMaker Pro (merge with above?) | :Exporting your NeoOffice database for FileMaker Pro (merge with above?) | ||
| Line 37: | Line 48: | ||
| :Connecting to your hsqldb database from NeoOffice | :Connecting to your hsqldb database from NeoOffice | ||
| - | + | [[Case Insensitive Filtering in Base]] | |
| - | [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p= | + | [http://www.oooforum.org/forum/viewtopic.phtml?p=256188#256188] |
| + | |||
| + | [[Read-Only Forms and Difficulty Editing Data]] | ||
| + | [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=38479#38479]<br> | ||
| + | |||
| + | [[Using Listboxes]] [http://user.services.openoffice.org/en/forum/viewtopic.php?p=12632#p12632] | ||
| + | :link provides steps to display one field in the list box, but store a different field. | ||
| - | In addition, there is a [[Miscellaneous Database Tips]] page that contains stub-ish tips for connecting to dbf and MS Access databases rescued from a page that has been obsoleted. | ||
| <br><br> | <br><br> | ||
| ==Impress Specific Tips== | ==Impress Specific Tips== | ||
| - | [[Exporting Slides as Jpegs]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=33341#33341] | + | *[[Exporting Slides as Jpegs]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=33341#33341] |
| - | + | *[[Printing Handouts with Notes]] [https://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=48955#48955] | |
| <br> | <br> | ||
| ==Miscellaneous Tips== | ==Miscellaneous Tips== | ||
| - | [[ | + | [[Turning Off Contextual Toolbars]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=5317&highlight=]<br> |
| [[Setting a Default Date Format]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=4643&highlight=]<br> | [[Setting a Default Date Format]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=4643&highlight=]<br> | ||
| [[Formatting and Printing Landscape Oriented pages]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=34129#34129]<br> | [[Formatting and Printing Landscape Oriented pages]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=34129#34129]<br> | ||
| [[Applying Smart Quotes to Imported Text]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=4699&highlight=]<br> | [[Applying Smart Quotes to Imported Text]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=4699&highlight=]<br> | ||
| + | <!--[[Adapting the Pagination Extension to work in NeoOffice 2.2.3]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=5811&postdays=0&postorder=asc&start=0]<br>Done--> | ||
| <!--[[Accessing the Mac OS X Address Book]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=4718] [http://tpa.omer.bar-or.org/posts/OpenOffice.org] (applies to NeoOffice 2.2.1 EA and following) Done--> | <!--[[Accessing the Mac OS X Address Book]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=4718] [http://tpa.omer.bar-or.org/posts/OpenOffice.org] (applies to NeoOffice 2.2.1 EA and following) Done--> | ||
| - | + | <!--[[Using Macros]] [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=31422#31422] and [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=31433#31433], as well as [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=34121#34121]<br> Done--> | |
| + | Setting up language-specific templates[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=6052] (could be added as a section of [[Editing Default Styles and Using Templates]]) <br> | ||
| + | [[Creating Size-Optimized PDFs]] [https://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=6535] (link to/from existing [[Methods of Exporting PDF compared]] article) | ||
| + | [[Improving Responsiveness of NeoOffice on Older Macs]] [https://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=52313#52313] (link to this from places like the FAQ mentioning speed) | ||
| + | [[How to create foldable greeting cards]] [https://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=58338#58338] (link to this new article from [[How_to_create_brochures]] and vice versa) | ||
| <!--{{botlangbarEN|}}--> | <!--{{botlangbarEN|}}--> | ||
| [[Category:NeoOffice]][[Category:Tips and Hints]] | [[Category:NeoOffice]][[Category:Tips and Hints]] | ||
Current revision
Listed below are hints and topics from the forums at Trinity that need to be added to the wiki. You can help us by turning the content of these links into new articles by editing the stub pages.
For each topic below, there are two types of links; one to a "stub" page in the wiki and one to the actual thread at trinity. The wiki page link is provided to make creating the articles easier. If the wiki link is blue, a page is already set up for you, ready for editing. If the wiki link is red, clicking on it (if you have editing privileges) will create the page for you.
The links to the trinity threads (blue numbers in brackets with a link icon after the end bracket) are provided both for potential editors, and for those persons looking for answers to their questions. You can click on the link on this page to get to your answer more quickly. (Note that in some cases, the wiki page may contain quotes from the thread as well as links, and may be a faster route to the information you need.)
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.
Contents |
Calc Specific Tips
Writer Specific Tips
[4]
(e.g., like scriptwriter style) [5], [6], [7]
Database Specific Tips
Configuring FileMaker Pro [8] [9]
- Connecting to your FileMaker Pro database from NeoOffice
- Exporting your NeoOffice database for FileMaker Pro (merge with above?)
- Connecting to your postgresql database from NeoOffice
- Connecting to your hsqldb database from NeoOffice
- link provides steps to display one field in the list box, but store a different field.
Impress Specific Tips
Miscellaneous Tips
[18]
[19]
[20]
[21]
Setting up language-specific templates[22] (could be added as a section of Editing Default Styles and Using Templates)
[23] (link to/from existing Methods of Exporting PDF compared article)
[24] (link to this from places like the FAQ mentioning speed)
[25] (link to this new article from How_to_create_brochures and vice versa)
