Questions tagged [spreadsheet]
37 questions
10
votes
1 answer
Reference cells of other tables in org-mode table
I have a long document with 10 tables, and I want to to have a summary table at the end of the document. Something like that:
tab1
| Nº | Description | Value |
+----+-------------+-------+
|... |
+----+-------------+-------+
| …
Jeff
- 537
- 4
- 13
9
votes
1 answer
Reference the last column / row in an org-mode table
The Situation: I read the Org Spreadsheet tutorial but couldn't find an answer. Commonly, I want to have the result of a formula in the last row of a table, i.e., have something like
#+TBLFM: @LAST$2=somefunction(...)
This means that in the…
andreas-h
- 1,559
- 13
- 22
6
votes
2 answers
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 is recalculated automatically:
| | Runde | 0 |…
Zelphir Kaltstahl
- 375
- 3
- 14
4
votes
2 answers
How does if() work in org spreadsheets?
I got the impression from the manual that
| a | |
| b | |
#+TBLFM: $2=if($-1==a, 1, 0)
should produce "1" in the first row and "0" in the second. But
instead I get
| a | 1 |
| b | b = a ? 1 : 0 |
#+TBLFM:…
Will Brown
- 41
- 1
3
votes
2 answers
Quick calculation in org-mode table
I used to think that you can just type =13*57 into an org-mode table's cell, hit Tab or Ret, and have it enter the result for you. Today, I learned that this isn't true the hard way as I used this a lot, recomputed the entire table via C-u C-c C-c,…
UTF-8
- 885
- 6
- 22
2
votes
1 answer
How can I apply one operation multiple times in ses-mode?
To add the values in B2:B5 in ses-mode I would write either
(+ B2 B3 B4 B5)
or
(apply '+ (ses-range B2 B5))
but how can I generate the values in the range C2:C5 from B2:B5?
Sam
- 317
- 1
- 11
2
votes
1 answer
Specify precision using calc in org mode spreadsheets
According to the org mode documentation for calc syntax you can append printf formatters to specify the number of decimal places to display ‘$1+$2;%.2f’ Same, format result to two decimals. Is there a way to set this as the default for all floats?…
young_souvlaki
- 526
- 2
- 13
2
votes
0 answers
Adding Emacs SES Mode Grid Lines
Began here using Emacs SES mode for some spreadsheets, but seems by default to lack the grid lines to help locating the cells and its values.
Looks like it should be in some sort of hook in my .emacs file, but until now I don't know how to enable…
Ferrari21
- 131
- 4
2
votes
1 answer
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 |
| # | Alice | 1 | 1 | 0 | 2 | 66.67 |
| # |…
Zelphir Kaltstahl
- 375
- 3
- 14
2
votes
1 answer
Error using the Emacs Spreadsheet
I have started to use the Simple Emacs Spreadsheet (SES) with
GNU Emacs 25.1.1 (x86_64-w64-mingw32) of 2016-09-17.
When I try to mark/highlight a column with (ses-mark-column), the selection doesn't operate in vertical mode. The same happens if I…
antonio
- 1,762
- 12
- 24
2
votes
1 answer
How can I protect Org spreadsheet columns from calculation?
Consider:
Before
| plan | a | b | c |
|-----------+----+---+---|
| concern 1 | -1 | 0 | 2 |
| concern 2 | 2 | 1 | 1 |
| concern 3 | 0 | 2 | 1 |
|-----------+----+---+---|
| score: | | | |
#+TBLFM: @>=vsum(@I..@II)
After
| plan …
Sean Allred
- 6,861
- 16
- 85
2
votes
2 answers
Org-mode spreadsheet: operate on range of fields
I am having hard time trying to figure out how to add contents of multiple fields.
It isn't quite obvious from Org mode manual as issue like this should be.
I'm trying to find a formula to sum the entry in fields @2$5 to @5$5 and make an entry of…
Bibek_G
- 215
- 1
- 5
1
vote
1 answer
How to express time inside an org-table formula?
Consider the following org-table, where the first 3 columns are inputs:
|----------+-------+-------+----------+------+--------|
| Date | Start | End | H. slept | | Delta |
|----------+-------+-------+----------+------+--------|
|…
crocefisso
- 1,141
- 7
- 15
1
vote
1 answer
Good mode to edit CSV files including adding and removing columns?
Looking for a mode to edit CSV files. I tried csv-mode which is great for viewing CSVs via the minor mode csv-align-mode.
However I cannot find an easy way to add or delete columns in this mode. Is this possible in csv-mode or is there another mode…
halloleo
- 1,215
- 9
- 23
1
vote
0 answers
Org-mode spreadsheet use value then reset value
I would like to input a value in a table, which is added to another existing value in the table and afterwards is reset to 0. I have tried to do this with a column formula, but the problem is, that before any value is used inside another formula, it…
Zelphir Kaltstahl
- 375
- 3
- 14