Next: Org-Plot, Previous: Orgtbl mode, Up: Tables [Contents][Index]

The table editor makes use of the Emacs `calc` package to implement
spreadsheet-like capabilities. It can also evaluate Emacs Lisp forms to
derive fields from other fields. While fully featured, Org’s implementation
is not identical to other spreadsheets. For example, Org knows the concept
of a *column formula* that will be applied to all non-header fields in a
column without having to copy the formula to each relevant field. There is
also a formula debugger, and a formula editor with features for highlighting
fields in the table corresponding to the references at the point in the
formula, moving these references by arrow keys

• References: | How to refer to another field or range | |

• Formula syntax for Calc: | Using Calc to compute stuff | |

• Formula syntax for Lisp: | Writing formulas in Emacs Lisp | |

• Durations and time values: | How to compute durations and time values | |

• Field and range formulas: | Formula for specific (ranges of) fields | |

• Column formulas: | Formulas valid for an entire column | |

• Lookup functions: | Lookup functions for searching tables | |

• Editing and debugging formulas: | Fixing formulas | |

• Updating the table: | Recomputing all dependent fields | |

• Advanced features: | Field and column names, parameters and automatic recalc |

Next: Org-Plot, Previous: Orgtbl mode, Up: Tables [Contents][Index]