Frequently asked questions - Calc

From The Document Foundation Wiki
< Faq‎ | Calc
Jump to: navigation, search

How to add a row to a range (list) of data

You have a table formatted and containing calculation formulas.

For example :

copie d'écran cellules formatées et colonnes calculées
Comment continuer la saisie sans refaire formats & formules ?


Procedure

  • Copy a row already "filled" (Ctrl+C)
  • Place the cursor where you want to add the line, go to Edit ▸ Paste Special (or Ctrl+⇧ Shift+V). In the Selection area uncheck Insert All to keep only the Format & Formula.

A new row is inserted, containing the formats and the formulas. The procedure is much faster to execute than to describe: (Ctrl+C to copy the row, then Ctrl+⇧ Shift+V to paste)


Note

  • As the paste parameters are stored during the session, only a simple Ctrl+⇧ Shift+V will be needed to add more rows.
  • An alternative is to use the shortcut Ctrl+D which recopies the previous cell (row). Everything is copied: data,

formats, formulas. It is therefore enough to replace the values that need to be modified.


In certain cases, information is present in rows under the table, for example:

copie d'écran mêe tableau avec ligne de totaux en bas
Comment insérer avant la ligne des totaux ?


Procedure

  • Copy a row already "filled" (Ctrl+C)
  • Place the cursor where you want to add the line, go to Edit ▸ Paste Special (or Ctrl+⇧ Shift+V). In Selection uncheck Insert All to keep only Format & Formula, and the choose the option Shift cells Down.