Questions tagged [spreadsheet]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
21 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
1answer
54 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 | | ...
0
votes
1answer
36 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 ...
1
vote
1answer
48 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 ...
0
votes
1answer
26 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 ...
0
votes
2answers
60 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 ...
0
votes
1answer
29 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
0answers
36 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
2answers
110 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 ...
2
votes
1answer
316 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 ...
0
votes
0answers
40 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
1answer
121 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
4answers
149 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
0answers
31 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 ...
1
vote
1answer
44 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 | ...
1
vote
1answer
123 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 ...
8
votes
1answer
2k 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$...
5
votes
2answers
829 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
1answer
676 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
1answer
117 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 ...
2
votes
2answers
2k 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 ...
0
votes
1answer
376 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 ...
2
votes
1answer
137 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'...
8
votes
1answer
3k 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 | +----+-------------+-------+ |... ...
2
votes
1answer
57 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: | | ...
2
votes
2answers
314 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 ...
1
vote
1answer
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 ...