Pages tagged with libreoffice

I'm still in the process of tagging pages that were migrated from the old site, so for now you're best off using the search engine rather than relying on the tags.

  • Auto resizing multiple cells in LibreOffice spreadsheet - When I export a Google Docs spreadsheet into OpenDocument format, it will open in LibreOffice calc with the height of each cell wildly different. No idea why. It seems people can get the same problem when pasting content into a LibreOffice spreadsheet....
  • LibreOffice calc / oocalc notes - Notes about oocalc. Regex find You can use regular expressions only if you tick ‘Regular expressions’ in the ‘Other options’ section of the Find & Replace dialog, accessed via Edit -> Find & Replace… Reference: List of Regular Expressions...
  • How to close a section in LibreOffice / OpenOffice - You can define sections in a LibreOffice / OpenOffice / odt document to format parts of a document differently, if e.g. you want one part to have multiple columns. Alt-Enter will close a section. Yet again it took an age to figure out - I couldn’t fi...
  • How to create different headers in an OpenOffice / LibreOffice / odt document - Summary: Create a unique page style for each header and add them by adding page breaks. Details follow after a brief rant, because I can’t help it. Rant: I hate Microsoft Office and I hate OpenOffice / LibreOffice just as much. Even thinking about the...
  • How to create a LibreOffice chart with two axes - In LibreOffice 3.5. Create your chart as normal. I’ll assume you’ve created some kind of line graph. Right-click on the chart and select Edit. Right-click and Insert/Delete Axis. Select a secondary Y axis. Now you’ll have two Y axes but they’...
  • libreoffice calc / oocalc pie charts - Count occurrences of words in a column and create a pie chart from it The column should have the title in its first cell e.g Animals: Animals Cat Dog Cat Select the col...

This website is a personal resource. Nothing here is guaranteed correct or complete, so use at your own risk and try not to delete the Internet. -Stephan

Site Info

Privacy policy

Go to top