Questions tagged [org-table]
for questions about Org mode's ASCII table editor. Use this tag for its spreadsheet calculations and plotting features as well.
307
questions
0
votes
0
answers
16
views
columnview sort
I would like to have that table always sorted by TODO state. In order DOING, DONE. Is it possible?
Because I couldn't find anything in documentation.
#+columns: %50ITEM(title) %author(author) %8TODO(...
- 357
1
vote
1
answer
69
views
horizontal lines in org mode tables
I want to obtain in org mode tables something like \cline to limit horizontal lines. For example
\begin{tabular}{|c|c|c|}\hline
$p$ & $q$ & $p \rightarrowq$ \\ \hline
0& 0& 1\\
0& ...
- 21
0
votes
0
answers
16
views
org mode table cell alignment for HTML export
I've got this all by itself in an org file
#+NAME: coinfliptable
#+ATTR_HTML: :border 2 :rules all :frame border
| <c10> | <c10> | <c10> | <c10> | <c10> | <c10> |
| ...
- 2,717
0
votes
0
answers
9
views
How to populate org table with org citations generated by R scr
I am trying to generate a table of org citations with the following R source block (emacs 28.1, org 9.5.3)
#+name: test-citation-table
#+BEGIN_SRC R :results replace :colnames yes
data.frame(...
- 181
1
vote
1
answer
48
views
orgtbl-toggle-comment freeze in one line table
For example, write only one line in foo.org.
| a |
So if execute M-x orgtbl-toggle-comment, it will freeze.
(can stop with C-g)
Is there a way to solve this?
environment:
org-version is a variable ...
- 27
1
vote
1
answer
41
views
Is there a way to use orgtbl-mode in the source code comment?
For example, I would like to use orgtbl-mode in the comments instead of org-mode as follows, even in ruby-mode, etc.
# |----+--------|
# | id | name |
# |----+--------|
# | 1 | alice |
# | 2 | ...
- 27
0
votes
5
answers
92
views
Devanagari script in org-table
Org-table works as expected when it comes to English characters.
| a | b | c | d | e |
| f | g | h | i | j |
| k | l | m | n | o |
| p | q | r | s | t |
| u | v | w | x | y |
| z | | | | |
...
- 365
0
votes
1
answer
25
views
sin() function in org-calc being weird?
Having read sin of pi radians, it seems as though sin is iffy around truncated inputs.
That said, I'm not quite grokking why it's this bad.
Given this org-mode table:
| i | $x_i$ | $sin(x^3)$ | ...
- 302
4
votes
1
answer
88
views
Why is the vsum of remote cells wrong in org tables?
I have some org-mode tables like this:
#+NAME: TableA
| Task | Amount |
|------+--------|
| Gna | 1 |
#+NAME: TableB
| Task | Amount |
|--------+--------|
| Gnampf | 3 |
| Overall | ...
- 169
0
votes
0
answers
30
views
Is there a version of Org Mode that would allow insertions of hlines and would adjust sum boundary hline references to change accordingly?
Is there a version of Org Mode that would allow insertions or
deletions of hlines and would adjust sum boundary hline references to change
accordingly?
The behavior that I would like to see is that ...
- 53
0
votes
0
answers
37
views
org-mode set minimum column width
I'm currently dealing with an org-mode document stored under git. In this document is a table with wide columns. Occasionally items are added and removed from this table, so the computed width of the ...
- 161
0
votes
1
answer
35
views
Emacs orgmode table formula to calculate different per km tariffs for trips under 100 km ans over 100km
I am new to Emacs Lisp. I have this price table in Org mode. A small portion of it is shown here:
*** Destinations en France
| Destination | Distance Km | Temps de trajet | Prix |
|-...
0
votes
0
answers
45
views
How to refer to relative positions in formula (orgmode table)
Given this table with columns DATE, VALUE and DIFFERENCE (empty):
| <2022-03-06 Sun> | 34 | |
| <2022-03-07 Mon> | 34 | |
| <2022-03-08 Tue> | 32 | |
| <2022-03-09 Wed> | 21 ...
0
votes
0
answers
11
views
How to use lubridate (R) to transform orgmode date timestamp into R readable dates?
My aim is to plot time against data in a plot in org-babel. However, my data table looks like this:
| date | amount
|------------------+--------|
| <2022-01-30 Sun> | 55.1 |
| <...
1
vote
1
answer
59
views
Horizontal lines on table not showing when exporting to HTML
I have this table,
| A | B | C |
|-----+-----+-----|
| 123 | 123 | 123 |
|-----+-----+-----|
| 4 | 5 | 5 |
|-----+-----+-----|
| 3 | 2 | 1 |
|-----+-----+-----|
| | | |
...
- 101
3
votes
2
answers
121
views
Org mode table misaligment
Running Emacs 27.2 on Windows 10.
My Org mode table is misaligned when I use (add-hook 'org-mode-hook 'variable-pitch-mode) (see the code below). Yes, my fonts are applied but the table is misaligned. ...
- 73
0
votes
0
answers
16
views
Formula for weight management (weight differences) [duplicate]
Let's say I have a table with my daily weight:
| date | weight | diff |
|------------+--------+------+
| 2022-30-01 | 60 | |
| 2022-31-01 | 59 | -1 |
| 2022-01-02 | 57 | -2 |...
0
votes
1
answer
62
views
How to export a table containing multi-lined cells from an org-table?
Consider the following table:
|-------------+------------------------|
| Definiendum | Definiens |
|-------------+------------------------|
| first term | - bullet point one |
| ...
- 293
1
vote
2
answers
65
views
How do I group by and aggregate orgtable more efficiently?
I have the following org table where I actively record columns 1,2,3,4 and the remaining columns are calculated from the first four. Using this I calculate the aggregate from the last three columns ...
0
votes
1
answer
86
views
Use org-babel table results as input to another org-babel snippet
I have a snippet of Python code that outputs an Org mode formatted table. After I'm satisfied with the table, I would like to generate the LaTeX markup via orgtbl-to-latex function.
For example, I ...
- 111
0
votes
1
answer
30
views
How to extract tables names from an org file?
I have an org file with headlines and subheadlines containing tables. Each table has a name (i.e. each table starts with a #+name: tablename header). I'd like to generate a list containing all tables ...
- 293
1
vote
1
answer
59
views
How to calculate velocity (units divided by time in HH:MM format) in org-table formula
Let's say I have two tasks with some duration in HH:MM format and value (points). I'd like to calculate the velocity (you can think of points as km and time in hours, you get km/h)
| task | time | ...
- 111
0
votes
2
answers
68
views
How to build an Elisp function that shows a table in a new window?
I have an org file containing reference cards on keyboard shortcuts that I continuously edit. Each ref card is a table belonging to a headline.
Here are the first headlines of the file, as an example:
...
- 293
0
votes
2
answers
66
views
Is it possible to comment a line from a table?
Let's say I have the following table :
|--------+--------|
| Letter | Number |
|--------+--------|
| A | 1 |
| B | 2 |
| C | 3 |
|--------+--------|
...
- 293
0
votes
0
answers
55
views
How to format org table field while keeping numeric value for other formulas?
Say I create a table like this:
| Number | Share price | Total |
|---------+-------------+----------|
| 500 | 6.90 | $3450.00 |
And that 3rd field is calculated. If I use the formula $...
- 385
0
votes
1
answer
34
views
org-table, fetch a specific cell from all tables in a file
Summary of the problem
Hey guys, I am currently keeping track of the stocks I buy and sell in org mode using tables. I have N different tables in a given file, each table representing a transaction. ...
- 101
0
votes
1
answer
35
views
Evenly spaced table-cells
I would like to change the following spacing behavior so that ideally all begin and end of columns are lined up (evenly spaced).
All rows should stretch as much as the largest of them.
- 257
2
votes
1
answer
47
views
Recalculate All Org-Mode Tables at Once Ending with Summary Table
Suppose I'm creating a Christmas list and tracking the gifts I am getting for people using org-tables. I have a named table for each group of people I am getting gifts for. These tables contains ...
- 303
0
votes
1
answer
45
views
org-table-iterate not working for tables with named columns
I have the following two tables:
| ! | slope | intercept | xval | yval |
|---+-------+-----------+-------+------|
| | 1.2 | -5 | 1.4 | |
| | 2.4 | 2 | -5 | |
| ...
- 163
1
vote
0
answers
50
views
How to output orgmode julia DataFrame as orgtbl?
In the following link, we see that we can use a table package in Python to return in orgtbl format.
#+begin_src python :results value raw :output :return tabulate(df, headers=df.columns, tablefmt='...
- 257
0
votes
0
answers
45
views
How to capture the column sort in Org-mode inside a formula?
Let's say, I have a following table:
|-------+---------|
| NAME | VALUE |
|---------+-------|
| DAVID | 3.83 |
| JULIA | 0.89 |
| ALICE | 0.59 |
|-------+---------|
| SUM | ...
- 3,715
0
votes
0
answers
63
views
nest org-mode tables
I have some data which is most naturally represented like so:
| thing 1 | thing 2 | thing 3 |
| TABLE 1 | TABLE 2 | TABLE 3 |
where TABLE i is an org table. I've been over most of the documentation ...
- 145
2
votes
0
answers
41
views
Freeze column for org table
Is there something like org-table-sticky-header, but for columns?
Context:
I am trying to create a table like this and add columns to it every day:
I already figured out that I need toggle-truncate-...
- 68
2
votes
1
answer
146
views
How to create a horizontal table in org-mode
I have a physical journaling setup that I want to move to Emacs/org-mode for better integration with the rest of my note-taking. I have a set of questions that I rate myself on. On paper, I was using ...
- 68
3
votes
0
answers
177
views
Export an org-mode table to pdf/png image
I've started using org-roam more often recently, and I use LaTeX a lot in my workflow.
What I want to do is this:
Create a table in an org file with some LaTeX math symbols, using the org-mode table ...
- 341
1
vote
0
answers
52
views
Org mode: How to restrain an inline image size in a table?
I'm only interested in restraining the image size directly inside the org file and not for exportation. When the image is outside of a table it's easy to render it reduced with:
#+ATTR_ORG: :width 100
...
- 137
1
vote
1
answer
77
views
Org mode: How to escape the # character in a table formula
I am trying to rename a row inside a table using a formula in Org mode (don't ask why I'm doing this, I need to do it that way) but I'd like to call this row #. I'm doing this:
| #ERROR | B | C |
|----...
- 137
0
votes
1
answer
186
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 |
| ...
- 137
0
votes
1
answer
44
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 ...
- 137
1
vote
1
answer
112
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 ...
- 137
0
votes
0
answers
19
views
How can I localize the calculation of org-table dates?
I have an org table I use to plan some dates every weeks. So I fix the first tuesday date of the month and add seven days the following rows. Unfortunately I want the dates to be in french (Mar.) and ...
- 1,710
0
votes
2
answers
45
views
Using elisp code with table formula problem
I've got these working
#+NAME: expogrowth1
| 1 | 2 |
| 2 | 4 |
| 3 | 8 |
| 4 | 16 |
| 5 | 32 |
| 6 | 64 |
| 7 | 128 |
| 8 | 256 |
#+TBLFM: @2$2..@$2> = @-1$2*2
and
#+NAME: expogrowth2
| 1 ...
- 2,717
0
votes
1
answer
32
views
Populate table row with rate changes with one formula
I've got this Exhibit A in brute force for a rate that is halved after 10 minutes
#+NAME: ratetable
| 0 min | 10 min | 20 min | 30 min | 40 min | 50 min |
| 20.0 | 10. | 5. | 2.5 | 1.25 | ...
- 2,717
1
vote
1
answer
33
views
Use variable in reference with remote in Org-table
I have one table called GRADING containing names and points entered by hand, and another table (FOO) containing the grading scheme. Is there a simple formula which allows to lookup the number of ...
- 143
2
votes
1
answer
303
views
How to delete a single column cell in an org-mode table?
In Excel etc it is possible to delete a cell in a column and have the cells below it "shift up" without affecting the content of the other columns. I haven't found a command for this in org-...
- 776
1
vote
1
answer
76
views
Export all org-tables from batch mode
How can I export all the tables in org-mode file similar to that.
* May
:PROPERTIES:
:TABLE_EXPORT_FILE: ~/Desktop/may.csv
:TABLE_EXPORT_FORMAT: orgtbl-to-csv
:END:
|One|Two|
|---+---|
* June
:...
- 147
0
votes
0
answers
81
views
org-mode table as function
I have the following question regarding org-mode tables:
I have the following simplified org-mode table with:
A,B as arguments or parameters
and C1, C2 results or return values.
#NAME: function
| A ...
- 11
0
votes
1
answer
130
views
How to calculate time durations in tables?
How to calculate time durations in tables?
Subtraction of numerical vectors works directly:
| day | t1 | t2 | differences |
|------------------+----------+----------+----------...
- 326
1
vote
3
answers
707
views
How do I copy the content of a cell in org-mode table?
Is there a command to copy the content of a cell in a single keystroke?
When I have cursor at [x] (see below), I have to do: M-a (goes to the beginning of the cell), C-<SPC>, M-e (goes to the ...
- 431
0
votes
1
answer
84
views
Table-capture doesn't handle new line
I'm trying to table-capture this in an org file
2 3 5 7 11 13 17 19 23 29
31 37 41 43 47 53 59 61 67 71
73 79 83 89 97 101 103 107 109 113
127 131 137 139 149 151 157 163 167 173
179 181 191 193 197 ...
- 2,717