Pages tagged with openoffice
- oocalc pie charts - Count occurrences of words in a column and create a pie chart from it
The column should have a title in its first cell.
Select the column.
Data -> DataPilot -> Start.
Use current selection.
Window will pop up to define the data fields...
- oocalc notes - Notes about oocalc.
Source cell range from different sheet
Copy the range in sheet 1.
Paste Special in sheet 2, selecting the Link option.
Show rows hidden by a filter
If you apply a filter and it hides a load of cells, select all cells (i.e....
- 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 abo...
- 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&rsqu...
Go to top