In addition to the guides for Writer and Impress, there is also a downloadable manual for OpenOffice Calc. Download the 516-page guide for OpenOffice Calc from Scribd. … [Read more...]
Stylin’ in OpenOffice [Formatting for Calc and Writer]
February 21, 2010 By 1 Comment
A lot of people think that most word-processing applications like Writer and its competition, are just like typewriters, with basic formatting like bold and underlining. This is OK for starting the document, but if it's something that may require a format change in the future, then it could be a long and painful process. Fortunately, over at World Label, they've put together some basic … [Read more...]
Display Formulas in Cells [Calc Tip]
January 29, 2010 By Leave a Comment
Calc can either show the formula or the results of the formula. Most of the time you will want to see the results of the formula, however occasionally, especially when you are troubleshooting, it is useful to display the formula itself for each cell. To do this, follow the instructions below. Be in a Calc file > Tools > Options (The “Options” window appears) Click on the + … [Read more...]
Random Number Generator [Calc]
December 8, 2009 By 7 Comments
Amazon affiliate: OpenOffice.org 3.0 for Beginners A friend of mine is familiar with working in Lotus 1-2-3 and has asked me for some assistance in converting to Excel or OpenOffice Calc. Of course I chose to post my Calc solutions here. :-) The formula for random number generation is quite easy. =RAND() This will get you a random number between zero and 1 (2 decimal places is the … [Read more...]
OpenOffice Calc Shortcuts [and differences with Microsoft Excel]
November 12, 2009 By Leave a Comment
A great deal of people using spreadsheets love using keyboard shortcuts. Here are some selected Excel and Calc default keyboard shortcuts - and the difference in accessing the related functions. Below are some additional shortcut keys that are useful in Calc. Function Excel Shortcut Calc Shortcut Rearranges the relative or absolute references (for example, A1, $A$1, $A1, A$1) in the input … [Read more...]
Shared Calc Spreadsheets – Available in Ooo 3.0
November 4, 2009 By Leave a Comment
Just a quick post with a bit of a find: OpenOffice.org Ninja has a great post on how to share spreadsheets on a network, with updates and change conflict resolution. Cooool :) … [Read more...]
Calc: Calendar Template (Basic)
July 24, 2007 By Leave a Comment
I have created a calendar template in Calc for a client. The dates are automatically calculated. You only need to amend the first Sunday to achieve the date range that you need. Download the file FREE from the following link: A Calendar Template File for OpenOffice 2.0 … [Read more...]
Recent Comments