LibreOffice

From Elvanör's Technical Wiki
Revision as of 04:24, 30 December 2009 by Elvanor (talk | contribs)
Jump to navigation Jump to search

Gentoo installation

  • Emerge myspell-en, myspell-fr etc to get spellchecking support.

Writer

  • To create a line break, use SHIFT + ENTER. This won't create a new paragraph.

Pages

  • You can edit the page style at the bottom of the application screen (left click to change the page style).
  • If the footer is different on left and right pages, edit the page style, Footer tab, and check the checkbox "Same Content Left / Right".
  • To be able to correctly print (at the right size) double check that Page Format (in Format -> Page) is set to the correct size. Else the printer will ask for another paper size and refuse to print.

Paragraphs

  • If there is a thin black line appearing somewhere, it is most likely a paragraph border. To remove it, edit the paragraph formatting.

Numbering and Bullets

  • When creating a new paragraph (typing ENTER), a new number / bullet is automatically inserted. You can remove it by pressing BACKSPACE.
  • I don't know how to have two or more levels of numbering / bullets on the same line.

Calc

Types

  • It seems that there is no function to convert an internal date to a text (using some formatting options).

Sheets

  • You can delete the current sheet via Edit -> Sheet -> Delete.

Rows and columns

  • You may move a row/column/cells by using the following procedure:
    • Select the cells you want to move.
    • Then click on the black square, and start to drag and drop it.
    • While dragging hold the alt key to move it to the destination.

Cells

Referencing external cells

  • You can reference cells in another sheet or even in another document. You can even use some functions to build the path of the other document. Example:
=INDIRECT(CONCATENATE(Sheet2.B1,YEAR(H1),"-", MONTH(DATE(Sheet2.B10,Sheet2.B9,1)) - 1, "-vincent-bernardi-pay.ods'", "#$sheet1.i15"))

The CONCATENATE function is used to build the path. Note that you *must* use double quotes for concatenate to work when dealing with inline strings. The INDIRECT function is used to actually get the value of the referenced cell.

  • Note that if you don't remember the syntax for referencing an external document or another stylesheet, you can just click on a cell, type "=" then click on the target cell on the external document. It will fill in the reference for you.

Merged Cells

  • You can see if some cells are merged by clicking on a row / column head. Then all cells belonging to the row are highlighted in blue except those that are merged.
  • To unmerge: Format -> Merge cells.