LibreOffice

Restore Missing Icons

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 "&".

• 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.