How to Add a Tick Symbol ✓ to Writer documents [LibreOffice, OpenOffice]

To insert the tick (✓) symbol into a Writer document, follow these instructions. From the menu (in Windows and Mac) click on Insert --> Special Character. From the Font dropdown, you need to select a font that will include the tick symbol. Times New Roman does NOT include this symbol. One font to use is OpenSymbol. Select OpenSymbol and then scroll down until you see the tick … [Read more...]

Making Search Relevant and Recent (Getting Help that Helps!)

Often, when people search for information on the web, they put search terms into Google and click search. This is especially relevant to searching for solutions to software problems as you want the solution to apply to the version of software that you currently have (if you have the most up-to-date version). Unfortunately, this general search method gives you a very large selection of web pages … [Read more...]

Integrating Google Maps in your documents (taking screenshots)

A friend of mine recently asked how can he integrate a Google Map into his document. The easiest way to do this is using a screen shot, however it is important to note that if you are going to use a map from Google, you need to attribute it. According to my reading of this page on Google Permissions, and this page on Attribution the easiest way to do this is to: Take a screenshot that includes … [Read more...]

FAQ: How to I change the default language in Word for Mac? [Word 2011]

With Office 2011 for Mac, you can check spelling and grammar in languages other than English. Word 2011 for Mac comes with foreign-language dictionaries such as Czech, French, Russian, and you can also change the 'brand' of English (UK, US, Australian). The default dictionary determines which language’s proofing tools Word uses for spelling and grammar. You can change Word’s default … [Read more...]

FAQ: How to Show Column A in LibreOffice Calc

I recently had a comment in response to FAQ: How to hide columns in Calc [Show / Hide] and decided to answer it with a video. It details two methods: A method in which you can show (unhide) all columns (this can be applied to rows), and  A method for unhiding column A alone   … [Read more...]

Changing case in Pages (iWork for Mac)

For my OpenOffice fans, my apologies for not posting on OOo or LibreOffice for a while, however I have been working in Pages for Mac recently. Just a quick tip as much for my own reference as for anyone else's - for some reason I keep losing this reference. Changing the case of letters in Pages is possible by selecting Format --> Font --> Capitalization. You can then choose the … [Read more...]

Hide Zero Values in LibreOffice Calc and Excel

Sometimes you don't want the zero values to show in your spreadsheet. Different Office programs can handle this in different ways. Below are some examples. Do you have any way that you remove zeros from your spreadsheets? If so, please feel free to contribute in the comments section below. OpenOffice / LibreOffice OpenOffice / LibreOffice has the option to hide the zero values … [Read more...]

New Line in Excel [Mac, Windows]

Quick tip: Usually when you hit the Enter key in Excel (Microsoft), it goes to the next cell. In Windows, you can hit Alt + Enter to get a new line without going to the next cell. In a Mac, you need to press Ctrl + Alt + Enter. … [Read more...]

Read ODS, ODT & ODP Files on your iPhone or iPad

I always struggle with opening open format documents on my iPhone - Apple doesn't have this as a standard format that other applications can use. I don't know of any applications that can edit Open Document Format files, however recently I downloaded the IBM Lotus Symphony Viewer. This works a treat in at least allowing me to view the data inside, which is certainly better than … [Read more...]

Turning off Capitalisation in Impress and Writer [, LibreOffice and NeoOffice]

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 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...]