Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

The tag has no usage guidance.

7
votes
2answers
157 views

Make org-mode table formulas use common arithmetic precedence

Given this org-mode document: | 4 | ? | #+TBLFM: $2=$1/2*2 Evaluating the formulas produces (in the second cell) the surprising result 1, instead of (4/2*2=) 4. Apparently, multiplication has a ...
4
votes
2answers
59 views

Org table spreadsheet recalculate all TBLFM lines

The following answer states, that one must have all recalculating formulas in one #+TBLFM line: https://emacs.stackexchange.com/a/10946/10090. Indeed, when I try the following formulas only the first ...
1
vote
1answer
73 views

Org table spreadsheet use column name on left hand side

I have the following table and formulas: | | Runde | 0 | 1 | 2 | Resultat | % | |---+-------+---+---+---+----------+------------| | ! | name | | | | result | percentage | | # | ...
2
votes
2answers
87 views

Number-separators in org-mode tables

I often paste org-mode tables numbers that are e.g. space-separated. Then I have to delete spaces before things like =$2/2 work correctly. Is there a way to change "number format", e.g. plug in a ...
2
votes
0answers
24 views

Re-apply table formulas on org-mode export

I'm using an org-mode file to do some filesystem monitoring. To that purpose I have a table in which I'm calling code blocks through org-sbe in the formulas. It looks like this: #+NAME: part-size #+...
0
votes
0answers
26 views

How to do org-mode cross table formulas? [duplicate]

If I have 2 separate tables in an org-mode doc is there a way to reference fields between them? * Table 1 |----------+------+------------+---------| | 12/20/17 | Thing | coolidge | 158.46 | |------...
0
votes
0answers
24 views

Add money numbers in org mode

Normally, the number is in the format as "11,000.00" How can I use the formula to deal with these numbers? | | | | | |----------+--------+---+---| | 2,411.64 | | | | | ...
2
votes
0answers
39 views

Replace formula by computed value

I'd like to select a simple formula like 17+5 and replace that by the computed result, 22 in this case. And I need this to work during keyboard macro execution, to quickly process large portions of my ...
0
votes
2answers
341 views

Can I use formula to manipulate text in org mode table?

I can use following code to create sum of numbers. But how can I append some text? #+TBLFM: $4=$2+$1+$3 For example | 名字 | 内容1 | 内容2 | 结果 results | |--------+--------------+...
1
vote
1answer
634 views

Orgmode Spreadsheet: update formula when adding new column

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 ...
7
votes
1answer
405 views

org-mode : in a table, calculate a person's age based on their birthday

Let's say I have the following table: | Name | Age | Date of Birth | Income | |--------+------------------+------------------+--------| | Joe | | <1984-02-20 ...
15
votes
3answers
2k views

Can I format cells in an org-mode table differently depending on a formula?

I have a column in an org-mode table with numbers in each cell. I'd like to change the background color of the cell to red if the number is below 1 or above 2. How can I do that?