Info Catalog org: Orgtbl mode org: Tables org: Org-Plot

org: The spreadsheet

 
 3.5 The spreadsheet
 ===================
 
 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
 

Menu

 
· 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
 

Info Catalog org: Orgtbl mode org: Tables org: Org-Plot