LibreOffice: Difference between revisions

From Elvanör's Technical Wiki
Jump to navigation Jump to search
No edit summary
Line 26: Line 26:
* To change the properties of an individual cell (such as borders), select the cell then choose Table -> Table Properties. Even though it seems this dialog is for the whole table, it will apply only on the selected cell...
* To change the properties of an individual cell (such as borders), select the cell then choose Table -> Table Properties. Even though it seems this dialog is for the whole table, it will apply only on the selected cell...


= Calc =
= Calc / Excel =


== Useful functions ==
== Useful functions ==
Line 60: Line 60:
* To create a group of rows that can be collapsed / expanded, select the rows and apply:
* To create a group of rows that can be collapsed / expanded, select the rows and apply:
** Data -> Group and Outline -> Group / Ungroup.
** Data -> Group and Outline -> Group / Ungroup.
* On Excel to move a column, select it and hold down the shift key. Note that you may have to "upgrade" the format to a newer version if you run into an error.


== Cells ==
== Cells ==

Revision as of 11:08, 3 May 2017

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.

Tables

  • To change the properties of an individual cell (such as borders), select the cell then choose Table -> Table Properties. Even though it seems this dialog is for the whole table, it will apply only on the selected cell...

Calc / Excel

Useful functions

  • NOW() gets you the current date.
  • AND (2 > 0; 4 > 0) can be used in tests.

Types

  • It seems that there is no function to convert an internal date to a text (using some formatting options).
  • You can use "'" (single quote) in front of a value to force Calc to recognize it as text.
  • There are test functions like ISTEXT, ISNONTEXT who can be useful.

Sheets

  • You can delete the current sheet via Edit -> Sheet -> Delete.
  • Window -> Split is used to have fixed views (I don't really like this feature).

Links

  • You can link a whole sheet from an external document. For that, use Insert -> Sheet from file... and check the Link checkbox. This feature can be very useful.
  • Sometimes in that case you must trigger "hard recalculation" if cells don't appear to update right. The key shortcut is Control + Shift + F9.
  • You can view all links in a given file by going to Edit -> Links.
  • Be careful: if, in a linked sheet, you reference another sheet in a cell via its name, the name won't be used. It is actually the index of the sheet in the document which will be used, thus make sure the indexes match between the original document and the linked document.

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.
  • To create a group of rows that can be collapsed / expanded, select the rows and apply:
    • Data -> Group and Outline -> Group / Ungroup.
  • On Excel to move a column, select it and hold down the shift key. Note that you may have to "upgrade" the format to a newer version if you run into an error.

Cells

  • To paste the contents of a cell, not its formula, copy as usual and then select "Paste special".
  • To use absolute cell references, write $B$1 rather than B1. When copying, the copied formulas will still reference the absolute cell.

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.

Text Cells

  • You can create a line break with Control + Enter.

Copying the formatting of some cells

Exporting to PDF

  • It is possible to define only certain sheets to be exported to PDF by defining a "Print Range" (Format -> Print Ranges -> Define). You can give a custom selection or just select "Entire sheet" to use the current sheet. In that case you don't need to enter anything in the field.

Printing

  • To scale down a sheet to a page, go to View -> Page Break Preview and then drag the page breaks as needed.
  • This also works for PDF export.

Impress

  • Export to PowerPoint (.ppt) is not perfect in LibreOffice 3.3. Layout problems can appear, it may be worthwhile to check under vanilla PowerPoint.