location: LibreOffice

Institute of Mathematics - PublicMathWiki:

Please enter your password of your account at the remote wiki below.
/!\ You should trust both wikis because the password could be read by the particular administrators.

Clear message

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.