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
2answers
1k views

Org-mode: How to fix table width to page width for dynamically generated tables?

I am using dynamically generated table to create a tabulated to do list with various parameters using: #+COLUMNS: %ITEM %SCHEDULED %DEADLINE for more info see: Org-Agenda export to dynamic Org-Table ...
0
votes
1answer
22 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.
2
votes
1answer
29 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 ...
0
votes
1answer
88 views

How to unpack a tuple from org-sbe evaluating a python code block into multiple columns of a org-table?

I often encounter situations where I can easily think of python code that, given some input values, computes multiple output values at once. As an example, consider the following simple code-block ...
2
votes
1answer
150 views

Org mode - Copy cells from a remote org-table with shifted columns

I want to copy the values of a shifted range of cells from a remote table. Example: #+NAME: TBL1 | 1 | 2 | 3 | 4 | | | | | | #+NAME: TBL2 | | 5 | 6 | 7 | 8 | | | | | | | The ...
0
votes
1answer
22 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 | | | ...
1
vote
0answers
29 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='...
0
votes
0answers
26 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 | ...
0
votes
0answers
34 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 ...
2
votes
0answers
34 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
1answer
105 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 ...
0
votes
1answer
36 views

How to control image sizes inside of table

I know that you can write something like: #+attr_html: :width 250 px [[./linl/to/image.jpg]] But what if I have them inside of a table like: | [[./linl/to/image.jpg]] | [[./linl/to/image2.jpg]] | ...
3
votes
0answers
73 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 ...
1
vote
0answers
27 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 ...
1
vote
1answer
38 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 | |----...
0
votes
1answer
258 views

org-mode table editor behaves strangely

With cursor in row 2, col 3 | a | b | c | | 1 | 2 | 3 _| Pressing <TAB> creates a new row: | a | b | c | | 1 | 2 | 3 | | | | | Type more than one character and press tab. Vertical ...
0
votes
1answer
73 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
40 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
53 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
0answers
18 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 ...
20
votes
5answers
4k views

Can I format cells in an org-mode table differently depending on a formula?

I have a column in an org-mode table with numbers in each cell. I'd like to change the background color of the cell to red if the number is below 1 or above 2. How can I do that?
0
votes
2answers
39 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 ...
0
votes
1answer
16 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 | ...
4
votes
3answers
2k views

How to quickly convert text to org-mode table?

windows 10, emacs 26.1 Supose I have the following text: OwnerKey OrganizationName GUID 111192 Infocom 41EA23423423423423423C8-62A61A1532C5 345423 TV A3B8F234234234234239FA5-...
1
vote
1answer
24 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 ...
2
votes
1answer
113 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-...
0
votes
1answer
40 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 :...
0
votes
0answers
19 views

How to export tables in a xltabular environment to TEX/PDF without xltabular being nested in a "table" environment?

My goal is to have a table, which can be customized with tabularX (width == textwidth), can break over multiple pages and is able to have zebra stripes (xcolor). I tried many packages, even the (...
6
votes
3answers
2k views

How do I insert resizebox code in org-mode tables when exporting to latex?

I'm trying to figure out how to insert a resize command inside a table environment in org-mode that exports to latex, Here is my minimal example of raw latex source vs org-mode tables: #+LATEX_CLASS:...
0
votes
0answers
48 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. #TBLNAME: function | ...
0
votes
1answer
101 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 | |------------------+----------+----------+----------...
3
votes
1answer
57 views

Is there a command (and ideally a key binding) to navigate to the top (or bottom) of an org table?

I have read Built-in Table Editor, and searched apropos-function org table for top, bottom, beginning, and end. I found org-table-beginning-of-field, but not anything like org-table-beginning-of-table....
1
vote
3answers
316 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 ...
0
votes
1answer
28 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 ...
0
votes
0answers
41 views

Move a row of a table.el table

I have this org-mode table, which apparently is a table.el table: +-----+------+ | Test|Foobar| +-----+------+ | | | +-----+------+ When I hit Tab in any cell, emacs tells me: Use ‘C-c '’ to ...
1
vote
1answer
59 views

Generate a new table out of old one with sorting

Here is a table where scores are calculated at last row with a formula. How to generate a new table TotalResults with 1 and last columns? Can we even sort the last column in the process? #+TBLNAME: ...
2
votes
2answers
735 views

org-babel problem printing separator rows to org-mode table

I found here in the org manual how to output from an org-babel source-code block to an org-mode table, namely through something like #+header :results output table I have had some trouble getting org-...
0
votes
0answers
25 views

formatting a org-table formula result

I would like to calculate the time in this table: | Start | End | Sum | Second Sum | |-----------------------+-----------------------+-----------+------------| |...
2
votes
2answers
478 views

calculate the sum of the muplication of 2 columns in org table

I have a org table: | a | b | c | |---+---+---| | 1 | 2 | i | | 3 | 4 | j | |---+---+---| | 4 | 6 | | I want to multiply columns a and b and sum them up (except last row: 1*2+3*4) and put into the ...
0
votes
2answers
76 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
28 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
1answer
41 views

How to properly align org table with mixed English-Bengali script?

I am unable to tidy up this table, so that last column is properly aligned, as the other two: |-----------+----------------+------------| | English | Bengali s. | Bengali w. | |-----------+------...
0
votes
0answers
20 views

Org mode tables with Devanagari characters look misaligned

Here is the table: |----+-----------| | No | Name | | 1 | Mumbai | | 2 | मुंबई | | 3 | पुणे | | 4 | उस्मानाबाद | |----+-----------| With devanagari characters, the table cell ...
1
vote
1answer
43 views

orgmode - calculate difference between two remote tables

I use below code to calculate the difference between two columns from remote tables but the output is all zero! #+name: tbl1 | x | | 1 | | 2 | | 3 | #+name: tbl2 | y | | 1 | | 1 | | 1 | #+name: ...
1
vote
4answers
141 views

Merge Columns Together in Org-Mode Tables

Is there a way to merge columns together in an org-mode table? Often when I auto-create a table it will split certain fields into unnecessary columns. I would like a way to select those columns and ...
0
votes
0answers
35 views

Why is a TAB character added when using kill-rectangle and yank-rectangle to insert multiple rows into an org-mode table?

I noticed an annoying behaviour when copying multiple rows (a list) from a web page into an org-mode table, following a process inspired by Is it possible to copy /paste multiple lines of text into ...
1
vote
1answer
32 views

What parameter in orgtbl-to-latex to set column width?

I am trying to set the alignment width of columns in latex. I am using orgtbl's orgtbl-to-latex I want to override the resultant \begin{tabular}{lllll} to something like \begin{tabular}{rlccp3 cm)} ...
1
vote
1answer
454 views

Org mode table export latex with title (upper) and notes (lower)

I would like to create the following LaTeX type table by using the standard org-mode functions. The LaTeX code is the following: \begin{table}[!h] \centering \caption{Results} \label{tab} \begin{...
0
votes
3answers
144 views

org mode sum time from remote table with org-lookup-all

I have two tables #+NAME: tasks | name | spent | |--------+--------| | task 1 | | | task 2 | | | task 3 | | | task 4 | | | task 5 | | #+NAME: works | date ...
1
vote
2answers
279 views

Is it possible to export an org table into an interactive table?

Org-mode can nicely export tables into html customly. However, these exported tables cannot be sorted or filtered (i.e. are not interactive). Would it be possible to make these tables sortable and ...

1
2 3 4 5 6