location: LibreOffice

Institute of Mathematics - PublicMathWiki:

Upload page content

You can upload content for the page named below. If you change the page name, you can also upload content for another page. If the page name is empty, we derive the page name from the file name.

File to load page content from
Page name
Comment

Contents

  1. LibreOffice
    1. Restore Missing Icons
    2. Human readable Matrikelnummern

LibreOffice

Restore Missing Icons

  • openofficeicons.jpg

Sometimes, it may happen that OpenOffice's toolbar icons have disappeared. There is an easy fix for this:

  • Launch OpenOffice and open the menu Tools -> Options.

  • Select View from the list on the left.

  • Open the icon theme drop down box under the label Icon style and size and select Human.

  • Click Ok.

Now, the icons should be displayed again.

Human readable Matrikelnummern

  • Open a new Spreadsheet file in LibreOffice Calc

  • Copy and paste the data (Matr.Nummer, Vorname, Nachname).

  • Select the column Matr.Nummer, use Format > Cells...

  • Select in the box Category the item Number
  • Down in the Format-Code box write: 00--000--000
  • Hit okay (nothing will change yet)

  • This column still selected use Edit > Find & Replace...

  • In Search For give the two characters "^." and in replace with give just an ampersand "&".

snapshot.replace.jpeg

  • Then make sure the options "Current Selection Only" and "Regular Expression" are selected and hit "Replace all"
  • Now the Numbers should be formatted okay.
  • Now in a unused column on the row as the first student paste there the formula:
    • =CONCATENATE("\exam{";B2;"}{";TEXT(C2,"00--000--000");"}{";D2,"}{";E2;"}{}")
  • Change the cell references according to your data!
  • Hit Enter, select this cell and drag the lower right corner downwards so that every students line gets its copy of that formula.
  • Save the file.
  • Select the Column with the formulas and copy it.