3

I have a small square orgmode spreadsheet with some data in it and 2 extra columns to the right with some formulas, like average and sum. I want to add some new columns in the middle of my spreadsheet in order to input more data.

Question: Is there a way to update all formulas automatically in order to include the new columns?

Example: =vsum($2..$12) and I'm adding two new columns, so I want the formula to be updated to =vsum($2..$14); since there are many formulas, I want them all to be updated automatically

Improve this question
2
  • Which spreadsheet?
    – Stefan
    Commented Sep 28, 2015 at 2:31
  • orgmode, sorry about that
    – Guilherme Salome
    Commented Sep 28, 2015 at 2:41

1 Answer 1

Reset to default
4

Basically every table manipulating function is updating formulas. For example : M-S-right includes a new column (before the cursor) updating formulas to the new number of columns.

C-u C-c * is recalculating all your formulas in the spreadsheet.

Also a C-c C-c on a #+tblfm: line is (re)applying all the formulas in the table.

For more advanced stuff, like automatically recalculating please have a look at the org manual.

Improve this answer
5
  • 1
    To expand: Almost every column/row manipulating command for org-table updates the function definitions.
    – Jonathan Leech-Pepin
    Commented Sep 28, 2015 at 11:23
  • @Jonathan Leech-Pepin: Right, I was too focused on operations for columns, , will update my answer !
    – Dieter.Wilhelm
    Commented Sep 28, 2015 at 13:14
  • Thanks! I didn't know there were such commands. This solves my problem! Thanks!!! :D
    – Guilherme Salome
    Commented Sep 28, 2015 at 13:32
  • @GuilhermeSalomé: You're welcome! And yes org-mode is ingenious... :-)
    – Dieter.Wilhelm
    Commented Sep 28, 2015 at 15:50
  • @Dieter.Wilhelm Should the formula update the moment I have inserted the column? I'm using the insert column shortcut and my formulas are not updated and I"m not asked to confirm formula updates. Checked the source for the insert column function and it has code for fixing formulas, but it doesn't work.
    – Alwyn Schoeman
    Commented May 30, 2019 at 18:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.