There are those who face issues with allocating page numbers in the 'Open Office framework'. Software should be used to carry out this task. The... Read more
With the simple service of Open office writer software, it is easy to add a background image to your document. To add a desired image to a specific... Read more
Excel files can be converted into PDF format and there are various ways through which this process can be done. Through OOO i.e. Open Office.org, Excel... Read more
To protect your important data you can either assign a password to a sheet or Calc document, here's how: Click on the Tools menu > Protect document >... Read more
Despite the fact that both "Spelling and Grammar" Checker are proposed in Writer, the OpenOffice.org suite (OOo) comes only a spell checker (nothing is... Read more
If you want to disable the launch of Open Office at start up, here's how to proceed: From any program (Writer, Calc...) click on the Tools menu >... Read more
If you have any difficulty to find the option to add borders to your cells, take note that the button for this purpose takes the form of a white (blank)... Read more
Under Calc all the themes, background, bullet are regrouped in the "Gallery". Simply click on the the Gallery button to access the different options To add... Read more
You can configure your Open Office suite to download available updates automatically: Launch any Open Office program (e.g Writer). Click on Tools > Options... Read more
The autocorrect under OpenOffice.orf cannot be performed if there is no dictionary installed. To install the dictionary, connect to the internet. First of... Read more
This task can be achieve with the COUNTBLANK function (no need to count manually) Syntax: =COUNTBLANK(Range of cell) In practice: First select the cell on... Read more
Open Office possess an interesting feature that allows you to send a document as email. Open the document > Click on File > Send > Document as email This... Read more
[OpenOffice Writer] Rapidly change case If you want to change your text to Uppercase or Lowercase under Open Office Writer: Select your text (Right-Click... Read more
The Hyperlink options are bound to this small icon: To insert an hyperlink: Simply select a cell Click on the Hyperlink button In the window that opens up... Read more
The Autofill feature of Calc, though far less acheived, works in the same way as under Excel: For example to autofill the days of the week. Enter the... Read more
Here's a small trick to access a hidden game under OpenOffice Calc Open a new spreadsheet In the Formula bar type: =GAME("StarWars") And press the... Read more
To hide/display the ruler feature (just below the ribbon) Click on the Tooks menu> Options Expand the OpenOffice.org Writer section > View Check or uncheck... Read more
[Open Office Calc]Insert an Audio file or Video in a cell To insert a video or audio file in a particular cell: Select the cell Click on the Insert Menu >... Read more
If you want to add an Hyperlink to a particular word or part of your text under Open Office Writer: First select the word(s) Click on the "Hyperlink" button... Read more
I would like input percentage in column C1 using the data contained in A1 and B1. Example A1 = 84 B1 = 42 C1 = % Try this: (84-42/42)*100 Read more
