Providing tips, tutorials and templates for various Office applications
When you need to replace text with paragraph marks (end of paragraph) / carriage returns, OpenOffice.org, LibreOffice and NeoOffice Writer all are able using the following 5 steps (click on the image to view a larger version): Note: If you don’t know how to get to the find / replace button above, hit Ctrl-F (Windows) or CMD-F (Mac). Alternatively, you can go to the ‘Edit’ Menu, and … [Read more...]
Note: For those that don't have a Mac, we'll be back to regular programming shortly. :) On Thursday I did a quick take on what my experience was on OpenOffice.org, LibreOffice and NeoOffice after installing Mac OSX Lion. There is a website that can assist you in identifying programs that work with Lion OSX - including our favourites! … [Read more...]
Today I decided to bite the bullet and install the new Lion OSX on my Macs. So far so good, however when you do the upgrade and if you use an Open Source Office software product, I suggest that you immediately open them after the installation of Lion and go through any recommended upgrades. … [Read more...]
I was recently reading through a tutorial and noticed that the writer (Akkana) was frustrated with the auto-capitalisation at the beginning of sentences in OpenOffice.org Impress. Turning this feature off is relatively simple, however you need to do it in each of the programs to ensure it is applied to both Writer and Impress. I've also included links for those wanting to do this in … [Read more...]
There is no automatic function to remove duplicate rows in Calc. In order to remove duplicate rows you need to perform some comparison tests. This tutorial will show you how to sort the data compare the data remove the duplicate rows There is a tutorial here that will show you how to check for duplicates on a single column value, however often we need to compare for more than one value … [Read more...]
Often long documents are created in Writer, and these often have complex formatting. They consist of design elements such as text, objects, paragraphs, characters, tables, etc. One of these design elements are pages. Pages have different properties compared to paragraphs and text, e.g. size and width, margins etc. From Writer's point of view these properties make up an “instruction set” … [Read more...]
When you need to replace paragraph marks (end of paragraph) / carriage returns with other text, OpenOffice.org, LibreOffice and NeoOffice Writer all are able using the following 5 steps: Note: If you don't know how to get to the find / replace button above, hit Ctrol-F (Windows) or CMD-F (Mac). Alternatively, you can go to the 'Edit' Menu, and select 'Find and Replace'. There is also … [Read more...]
It's the pain that a large number of students share: you've received your assignment brief from your school/institution and the content you can write... no problem. But that pesky formatting!!! What is “12-point font”? What does “double line spacing” mean? Some schools even impose penalties (deduct marks) if you don't get this right! This guide has been put together with the aim of … [Read more...]
To set the default zoom for PDF documents, use File > Export as PDF... and select the "Initial View" Tab (see the screen shot below). On this tab, you can set the desired magnification (zoom) for your PDF. A Note on Default Zoom It has been noted that default zoom settings perform differently depending on the operating system (Linux, Windows, Mac, etc) and the software used to open the … [Read more...]
One of the things about Open Source software is that a great deal of the help comes from the community. This is done through the community, and through an interface called a forum. Some people may not be familiar with forums, however as a way of getting assistance on specific problems they are pretty useful. Users response with different options and methods of approaching your issue or … [Read more...]
Recent Comments