## page was renamed from OpenOffice <> = LibreOffice = == Restore Missing Icons == {{attachment: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 "&". {{attachment: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.