Questions tagged [spreadsheet]
The spreadsheet tag has no usage guidance.
37
questions
1
vote
1
answer
74
views
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 |
|----------+-----...
- 1,175
0
votes
1
answer
39
views
Orgmode-Spreadsheet: TBLFM-In-cell-calculation also possible with elisp code?
Cell fields do automatic calculation by default.
For example
|-------+----------|
| Test | Value |
|-------+----------|
| Stone | 5.4+12.3 |
|-------+----------|
#+TBLFM: @>$>=@>$>
...
- 43
0
votes
3
answers
90
views
How to turn numeric percent cell content |86%| into progress bar ▊▊▊▊------ purely with TBLFM & elisp code?
This is a bit trickier, but the result is awesome:
|-------------------------------------------------------|
| Progress |
| [%, ...
- 43
0
votes
2
answers
122
views
How to round on 2 decimals in org mode table using elisp?
That's probably a low hanging fruit.
In short, what I want:
6.7690001 ---> 6.77
I know how to do it in org mode table using regular TBLFM:
|---------|
|6.7690001|
|---------|
#+TBLFM: @1$1=@1$1;%....
- 43
0
votes
2
answers
34
views
How to prevent digit loss in orgmode spreadsheets with elisp?
That's probably a low hanging fruit.
Assume an orgmode spreadsheet with one side for input - a number -
and the other side for output.
The other side is specified with simple elisp code,
taking the ...
- 43
0
votes
1
answer
54
views
How can I fill a column with relative indexing in org-mode?
It turns out that ses-mode (Simple Emacs Spreadsheet) is
not yet ready
for doing operations on rows/columns.
And so I'm turning my attention to org-mode.
I store the following data in a .org file
| ...
- 317
2
votes
1
answer
57
views
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?
- 317
0
votes
1
answer
28
views
How to code this dynamic table from a web application called omni calculator (on salary conversions) as an org table in Emacs?
I like this application. I would like to build something similar but as a table inside a .org file.
This is an interesting and easy-to-understand particular case. But I would use this kind of approach ...
- 1,369
1
vote
1
answer
463
views
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 ...
- 1,291
0
votes
1
answer
97
views
org mode table: calculate sums between all pairs of adjacent hlines
I am curious as to whether it's possible to automate the TBLFM in a particular way. This example illustrates the problem I am asking about:
|------------------------------------------------------------...
- 1,786
1
vote
0
answers
33
views
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 ...
0
votes
1
answer
454
views
Org mode: Using elisp formula to automatically sort tables
I'm trying to use table formulas to automatically sort my tables. I have made this:
| Animal | Nombre |
|----------+--------|
| Bison | 5 |
| Vache | 4 |
| Aligator | 7 |
| ...
- 147
0
votes
1
answer
47
views
Org mode: Insert the result of a table formula between two existing columns
I have a very simple table like this:
| A | B | C |
|---+---+----|
| 1 | 2 | 15 |
| 1 | 2 | 32 |
| 1 | 2 | 81 |
I want to apply a formula that calculate the sum between A and B and insert the result ...
- 147
1
vote
1
answer
358
views
Org mode: Simple "if" formula on my table throws an error
I have a very simple table that looks like this:
| Fabricant | Catégorie | Animal | Nombre |
|-----------+-----------+------------------------+--------|
| Pearson | Camp | Bœuf ...
- 147
1
vote
1
answer
83
views
How to fill in a formula into adjacent cells in org-mode spreadsheet?
For example, in the following table
|------------+------------+-----+-----+-----+-----+-----+-----+-----+-----|
| Pobability | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 |
| Odds ...
- 1,175
0
votes
2
answers
191
views
How to compute ln in Org-Mode spreadsheet
Is there a formula to compute the natural logarithm of a number in Org-Mode spreadsheet? For example, to compute ln(1), Excel or Calc formula is =ln(1), what would it be in Org-Mode?
The result should ...
- 1,175
0
votes
1
answer
51
views
SES does not initialize properly when opening existing spreadsheet files
When I attempt to open an existing SES (Simple Emacs Spreadsheet) file in GNU Emacs 24.3.1 (i386-mingw-nt6.1.7601), the file comes up, but SES has not been properly initialized, even though the file ...
0
votes
0
answers
54
views
Marking up colored text in Org
I want to generate an Excel spreadsheet programmatically from an Org document. Any tips on how to markup colored text? I understand that Org does not natively support color markup, wondering if there'...
4
votes
2
answers
145
views
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 ...
- 41
2
votes
1
answer
1k
views
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 ...
- 526
0
votes
0
answers
92
views
Org-mode spreadsheet time diff elisp formula or GNU Calc
I wish to substract from a start time an end time in my org-mode spreadsheet. My times strings look like this (only the inline code):
starttime: 9:42 or 09:42
endtime: 18:20
So it's 24h format.
I ...
1
vote
1
answer
493
views
Org Mode - Use remote table reference in constants
In https://orgmode.org/manual/References.html remote references are mentioned. Also there are constants for a local environment of a table. I would like to retrieve the value for a constant from the ...
0
votes
4
answers
439
views
org-mode spreadsheet multiply 2 columns element-wise using GNU Emacs Calc formula
I am looking for a way to multiply 2 columns element by element and then sum the resulting vector. I have the following example:
| | | col1 | enable |
|---+-------+------+--------|
| | ...
2
votes
0
answers
55
views
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 ...
- 131
1
vote
1
answer
48
views
Looking up values in an org spreadsheet
I imagine it would be possible, with the tables
| food | kcal/hg |
|---------+---------|
| sausage | 281 |
and
| food | g | kcal |
|---------+-----+------|
| sausage | 100 | ...
- 3,204
1
vote
1
answer
185
views
Why does all but the first `org-lookup-first` returns nil
I have an org file in which I lookup for some values in different tables. The problem is that in two of them, only the first row gets its value, while in the rest of the rows the value returned is ...
- 121
9
votes
1
answer
3k
views
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$...
- 1,559
6
votes
2
answers
2k
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 ...
2
votes
1
answer
968
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 |
| # | ...
0
votes
1
answer
171
views
Constant not recognized in lisp formula within org-mode spreadsheet
Here is a simple org-mode spreadsheet in which the third column is computed in terms of the second column by multiplying it
by the exchange rate between Euros and Dollars (taken to be 1.23) thru the ...
- 787
3
votes
2
answers
3k
views
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 ...
- 895
0
votes
1
answer
442
views
Getting SES mode to act somewhat like a regular spreadsheet
So I have been working in an office that deals a ton with spreadsheets (mostly non-numeric data). With some things SES mode is a perfect alternative to the standard Excel sheet. I have found one thing ...
- 15
2
votes
1
answer
164
views
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'...
- 1,762
10
votes
1
answer
4k
views
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 |
+----+-------------+-------+
|... ...
- 537
2
votes
1
answer
65
views
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: | | ...
- 6,861
2
votes
2
answers
380
views
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 ...
- 215
1
vote
1
answer
1k
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 ...
- 903