Tag Archives: libreoffice

How to Hide a Spreadsheet Column in LibreOffice Calc Software & Sites 06 APR 2012

Seeing as Ubuntu ships with LibreOffice (forked from OpenOffice) as its default office suite these days, I guess I should try and get a little more familiar with its various time-saving tips and tricks, like this one noted here today.

(And If you don’t know what I’m talking about, then: “LibreOffice is the power-packed free, libre and open source personal productivity suite for Windows, Macintosh and GNU/Linux, that gives you six feature-rich applications for all your document production and data processing needs: Writer, Calc, Impress, Draw, Math and Base.”)

Anyway, Calc is LibreOffice’s spreadsheet application (similar to Microsoft Office’s Excel), and today’s handy little user interface tip shows us how to quickly and efficiently hide unwanted columns which you still want present, but just not visible in order to save on screen real estate.

To hide a column, grab with your mouse pointer the targeted column’s right hand edge, and begin resizing it like you normally would. In this case you want to shrink it, so in other words, drag towards the left. If you stop and release the mouse button before reaching the column’s left hand edge, the column will be shrunk to a smaller width.

And here is where it gets fun. Keep on resizing until you drag the right hand edge past the left hand edge! Releasing the mouse at this point will result in the column instantly hiding itself!

Which of course is pretty nifty! :)

How to Stop LibreOffice Writer from Automatically replacing Simple Quotation marks with Curly Quotation marks CodeUnit 14 OCT 2011

While curly or smart quotation marks are perhaps more preferable when writing a novel or an official document, there is often a case for not automatically replacing your simple straight quotation marks (both single and double quotes) with these more fancy, curly quotation marks, like when you are including code in your text for example.

LibreOffice Writer by default does this replacement for you, but thankfully it at least makes it pretty simple to turn this feature off as well.

Simply access the main Tools menu, select the AutoCorrect options… and on the resulting dialog window, open the Localized Options tab.

There you will see sections detailing the replacement for both Single and Double quotes – simply uncheck the Replace box to turn off, or alternatively check the box to turn the autocorrect feature back on.

Easy as that! :)