Questions tagged [spreadsheet]
The spreadsheet tag has no usage guidance.
13
questions
1
vote
1answer
27 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
38 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
657 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
421 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
375 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
61 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
1k 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
290 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
114 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
2k 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
52 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
249 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
878 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 ...
