Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 11716

For questions about Org mode's ASCII table editor. Use this tag for its spreadsheet calculations and plotting features as well.

1 vote

orgtbl-aggregate: how to handle periods (.) in column header names

Funny column names have just not been anticipated. This can be a useful new feature. Your proposed syntax (single or double quotes) seems the way to go. I will look at how to implement that. (The une …
tbanel's user avatar
  • 551
0 votes
Accepted

orgtbl-aggregate: how to handle periods (.) in column header names

A new version of orgtbl-aggregate is available on Melpa and https://github.com/tbanel/orgaggregate. Column names can now contain arbitrary characters (space, dot, semicolon, etc.). Just quote them wit …
tbanel's user avatar
  • 551
1 vote

org-table, how to compute Coefficient of Determination between two time fields?

And of course you have the orgtbl-aggregate package (available on Melpa). It uses Calc as its backend engine. The vcorr function is the one to use, as wvxvw and RUserPassingBy put it. #+BEGIN: aggreg …
tbanel's user avatar
  • 551
1 vote

Possible to Set a Frozen Row in Org-Mode Table?

There is a package on Melpa that may be useful: orgtbl-show-header
tbanel's user avatar
  • 551
1 vote

how to get reference to other tables working with field references?

Or you could have just one facts table, and one summary table. The orgtbl-aggregate package available on Melpa is handy. #+TBLNAME: Year | month | some info | more info | count | notes | |-------+--- …
tbanel's user avatar
  • 551
1 vote

Conditionally calculate the sum of a column depending on a fields value in another cell of t...

An alternative would be to use the orgtbl-aggregate available on Melpa. #+name: yourtable | Day | Start | End | Home | Sum | |-----+-------+-------+------+-------| | 1 | 09:00 | 17:00 | No …
tbanel's user avatar
  • 551
1 vote

Separately sum positive/negative numbers?

You may want to take a look at the orgtbl-aggregate package available on http://melpa.org Documentation here: https://github.com/tbanel/orgaggregate First you create a column which tells it is a win …
tbanel's user avatar
  • 551
0 votes

Cumulative Column in Org Table

Initialize the first cell with @1$3=$2. This override the column formula which is correct. use orgtbl-ascii-draw for an ascii plot |------------------+----+-----+--------------| | <2020-02- …
tbanel's user avatar
  • 551
0 votes

calculate the sum of the muplication of 2 columns in org table

You could use the Orgtbl-Aggregate package available on Melpa The sums are in a separate table, easy to update #+name: mytable | a | b | c | |---+---+---| | 1 | 2 | i | | 3 | 4 | j | #+BEGIN: aggrega …
tbanel's user avatar
  • 551
3 votes

How to have the sum of a column (with computed data) in the first row?

You may use the orgtbl-aggregate package available on http://melpa.org The sum of Col1 and Col2 is given in the aggregated table below. #+name: cc | Col1 | Col2 | Sum8 | |------+------+------| | …
tbanel's user avatar
  • 551
1 vote

How do I group by and aggregate orgtable more efficiently?

You may shrink those annoying columns to zero width: #+NAME: hpush | date | progression | sets-reps | comment |…|…|…| | | | …
tbanel's user avatar
  • 551
0 votes

org mode sum time from remote table with org-lookup-all

In Calc (the Emacs embedded calculator) there is a format for hours-minutes-seconds that you may leverage. For instance, 1 hour, 25 minutes, 17 seconds is written 1@ 25' 17". Here is a variation of xu …
tbanel's user avatar
  • 551
0 votes

org mode sum time from remote table with org-lookup-all

Alternately, you may want to look at the OrgAggregate package available on Melpa. It does all kinds of aggregations. In your example with the @ ' " format, it will use the task column as a key, and su …
tbanel's user avatar
  • 551
0 votes

How to turn numeric percent cell content |86%| into progress bar ▊▊▊▊------ purely with TBLF...

| 36 | ██▌ | | 25 | █▊ | | 16 | █▏ | | 9 | ▋ | | 4 | ▎ | | 1 | ▏ | | 0 | | | 1 | ▏ | | 4 | ▎ …
tbanel's user avatar
  • 551