Skip to content

mendel5/libreoffice

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 

Repository files navigation

libreoffice-how-to

How to use LibreOffice Writer, Calc and Impress

Writer: How to create a horizontal line in Microsoft Word and LibreOffice Writer

  • Open Tools → AutoCorrect → AutoCorrect Options.
  • In the Options tab, check the Apply Borders box.
  • Then enter --- and press Enter

Source:

General: Change Language

Writer: Page Margins / Seitenränder

Writer: Page Numbers / Seitenzahl

Calc: Pivottabelle for Fritzbox Calls

  • Go to fritz.boxTelefonieAnrufeAnruflisteAlle Anrufe → Bottom of the webpage → Sichern
  • Download the CSV file
  • Open the CSV file in LibreOffice Calc
  • Delete the first row
  • Highlight the full table
  • Click on DataPivot TableInsert or EditCurrent selectionOk
  • Select the following entries for the Pivot table:
    • Filters: empty
    • Column Fields: Data
    • Row Fields: Name, Rufnummer
    • Data Fields: Count - Rufnummer (Make sure to change the default value of Sum - Rufnummer to Count - Rufnummer)
    • Ok
  • Click on the Dropdown arrow of the column Name and only select (empty)
  • Highlight the newly created Pivot table
  • Click on Sort (AZ/ZA or Arrow down/Arrow up)
  • Sort by Count - Rufnummer and Descending
  • Done