1

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

  • Which spreadsheet? – Stefan Sep 28 '15 at 2:31
  • orgmode, sorry about that – Guilherme Salomé Sep 28 '15 at 2:41
2

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.

  • 1
    To expand: Almost every column/row manipulating command for org-table updates the function definitions. – Jonathan Leech-Pepin Sep 28 '15 at 11:23
  • @Jonathan Leech-Pepin: Right, I was too focused on operations for columns, , will update my answer ! – Dieter.Wilhelm Sep 28 '15 at 13:14
  • Thanks! I didn't know there were such commands. This solves my problem! Thanks!!! :D – Guilherme Salomé Sep 28 '15 at 13:32
  • @GuilhermeSalomé: You're welcome! And yes org-mode is ingenious... :-) – Dieter.Wilhelm Sep 28 '15 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 May 30 at 18:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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