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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
8 views

getting org-lookup-last to look for non-blanks

I have a log of where and when I last mowed the grass (argument with the wife, don't ask). I'd like to display how long between mows - I tried to use org-lookup-last to see the last non-blank entry in ...
  • 432
0 votes
1 answer
63 views

Fold tables in org mode

Is there a default way to make tables in org mode foldable? Obviously, I can just advise org-table-create to wrap the new table inside a drawer, but I was wondering whether this is overdesigned and ...
0 votes
1 answer
18 views

Remove rows/columns of Org table before passing to a Babel block

Is there a simple way to remove specific rows/columns of an Org table when passing them to a Babel block? For example, I'd like to process the data in the table below using Matlab. The column headers ...
0 votes
3 answers
68 views

How to use table lookup functions results as input for calculations?

I have the following static table: #+name: static |-------+---------------+-----+--------| | | Date of birth | Sex | Height | |-------+---------------+-----+--------| | Croce | <1985-07-30>...
0 votes
1 answer
26 views

calc: fill multiple adjacent rows with a formula?

With Table>Set Field>Formula, I'm able to do what I want for a particular field, in this case that corresponding to Aug 07. How can I fill multiple adjacent fields in one go, say Aug 7-15? #+...
  • 629
0 votes
1 answer
49 views

How to use fonts for normal text for org-mode tables?

Since the Emacs version upgrade to version 28 org-mode tables have become very small in size. Their font size has been reduced. Is there a way to tell Emacs to use the default font for the tables? ...
  • 13
1 vote
1 answer
52 views

Where can I find org-table formatting documentation?

I'd like to do some formatting on org-tables than I'm using. For example, make this table : |----------------+----------+---------+---------+---------| | Russia | 12000000 | 1700000 | 4950000 |...
0 votes
1 answer
112 views

org mode tables slowed down by evil mode

I am trying to create a table in org-mode like that (/ is where my cursor is) | this is a test | foo | bar | | ---------/---- | --- | --- | If I now press enter, emacs hangs and I have to interrupt ...
  • 101
1 vote
1 answer
38 views

Org mode table range excludes empty cells

For me this problem occurs when using org-lookup-first. However, I think this might happen in a lot of other circumstances as well. When specifying a range of cells for example via @1$1..@>$1 it ...
2 votes
2 answers
66 views

How to show an org-table from another file?

I have a refcards.org file where I store and maintain tens of tables (each having a specific name, e.g. #+name: key-somename). I would like to mention and show these tables in some other org files ...
0 votes
2 answers
75 views

Getting content of paragraph element using Org Element API

I've been trying to get the content of the paragraph element unsuccessfully using org-element-contents, is there something I am missing here? I have a org document as follows: * world ** China *** ...
1 vote
0 answers
20 views

Why does C-u C-c C-c place the vsum() in current row of an org-mode table instead of the row mentioned in #+TBLFM?

I have this org-mode table in a file named 1.org: | . | A | B | C | |---+----+-----+------| | X | 10 | 100 | 1000 | | Y | 20 | 200 | 2000 | | Z | 30 | 300 | 3000 | |---+----+-----+------| | T | ...
  • 13
0 votes
0 answers
33 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(...
  • 441
1 vote
1 answer
104 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
144 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,777
0 votes
0 answers
12 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(...
  • 191
0 votes
0 answers
52 views

Formating a table with org mode

Can someone tell me how to format this sample table with org mode.. | A | B | C | Total | -> Header title center align ? +-----|-----|-----|---------| | 5 | 5 | 5 | 15 | | 6 | ...
1 vote
1 answer
51 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
48 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
115 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
28 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)$ | ...
5 votes
1 answer
98 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 | ...
0 votes
0 answers
39 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 ...
0 votes
0 answers
49 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
38 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
64 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
12 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
81 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 | |-----+-----+-----| | | | | ...
  • 107
3 votes
2 answers
216 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. ...
0 votes
0 answers
17 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
80 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 | | ...
1 vote
2 answers
85 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
179 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
34 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 ...
1 vote
1 answer
69 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
103 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: ...
0 votes
2 answers
72 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 | |--------+--------| ...
1 vote
0 answers
114 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 $...
  • 449
0 votes
1 answer
37 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
41 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
57 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
72 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
74 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
101 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
43 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-...
2 votes
1 answer
201 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 ...
3 votes
0 answers
271 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 ...
2 votes
0 answers
111 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 ...
  • 147
1 vote
1 answer
98 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 | |----...
  • 147
0 votes
1 answer
272 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

1
2 3 4 5
7