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
0answers
14 views

Org mode table export latex with above title and below notes

I would like to create the following LaTeX type table by using the standard org-mode functions. \begin{table}[!h] \centering \caption{Results} \label{tab} \begin{threeparttable} \begin{tabular}{lcccc}...
1
vote
1answer
26 views

Perform calculations in orgtbl with the LaTeX syntax?

This is an orgtbl table #+begin_src emacs-lisp :results none (setq calc-language 'latex) (calc-radians-mode) #+end_src #+attr_latex: :mode math |----------+-----+----------| | Fonction | var | ...
0
votes
1answer
31 views

Org table date arithmetic with Lisp expressions

It's easy to do date arithmetic using org-mode table formulas. For example, if I enter this table: | [2020-01-01] | | | [2020-02-01] | | | [2020-03-01] | | #+TBLFM: $2=$1+1 ...and then do C-c C-c ...
0
votes
1answer
31 views

Cumulative Column in Org Table

I would like to create a table with Coronavirus case counts for the state of Utah in the United States. I have a table with two columns: a date column and a column of total new cases for that day in ...
2
votes
1answer
34 views

Hide org-table rows outside certain date ranges?

Excel tables lets us show just the rows that have "July 2018" in a specific column, and hide the rest. Or to show "21st August 2017-30th August 2017, and also July 2018, and also all of 2019", and ...
0
votes
0answers
11 views

Custom org-refile of a table entry similar to Capture

My question concerns the refiling of table entry. I keep my cheatsheets for different kind of things in a table format. Let's suppose, that each heading has exactly one table. * My table 1 ...
1
vote
1answer
18 views

Set org-table tab-key behavior to insert row when above a footer/hline

I've been experimenting with/learning org-mode's table features and spreadsheet-like formulae. If I include a totals-type footer row in a table and precede it with a border (hline), then I can simply ...
0
votes
0answers
31 views

Time-formatted output from org-table date- and time calculation?

I have an org-table for my timesheets. Part of it looks this: | Start | End | End - Start | | <2020-03-05 10:00> | <2020-03-05 Thu 14:30> | 0.1875 | #+...
1
vote
0answers
26 views

using org table as yasnippet input

I'm using yasnippets to create code blocks in org mode to document and execute DevOps activities. To improve productivity, it would be nice to have a possibility to create org tables with rows of ...
1
vote
1answer
79 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
4answers
57 views

Nesting conditionals, consolidating functionality in elisp

Working in an org-mode file, I have this table #+tblname: site-charac-matrix | | glaze | orn | color | thin | |---+-------+-----+-------+------| | A | 0 | 1 | 0 | 0 | | B | 1 | 0 ...
0
votes
1answer
60 views

Org mode table- make entire column to contain checkbox

I have a table like this using Org mode (by typing |-- and then tab to complete |-- Item-- |--Notes---| | blah blah|blah blah | Now I would like to add another column just before Item and contains ...
2
votes
2answers
81 views

Org Reveal : Tabular fragments

I'm using org-reveal to make a presentation. I want to have elements in tabular form appear sequentially but in column-major order. I know you can put :frag property-markers for gradual appearance....
1
vote
1answer
33 views

Org-mode table recalculation with a remote() formula using calc?

Can I make table2 automatically recalculate a remote() formula when I modify data in table1? I have the below tables and the first table is automatically recalculated when I press TAB (thanks to the "...
0
votes
0answers
14 views

Footnote link broken when converting to table.el format

Org mode footnotes within table cells are broken when converting to table.el format with C-c~. * Org Table | col1 | col2 | col3 | |-----------+------+----------------| | some text | ...
0
votes
1answer
40 views

Exact steps to export to an org table to csv

Sorry if this is trivial. What are the exact step to export the following table: 1) to a buffer 2) to the file specified in properties For now if I position the cursor inside the M-x org-table-...
0
votes
0answers
11 views

Dealing with a table with too many row in org-mode

When a table gets too long, how can you deal with it? Is there any way of collapsing parts of it? Or maybe dividing it in multiple tables and still perform operations (like adding a column) on all of ...
0
votes
1answer
21 views

Applying formatting from within tables

It seems that ^c ^c applies table formatting only when point is on the formatting line (the one beginning in #+tblfm:). Is it possible to have ^c ^c apply formatting even when point is in the table ...
0
votes
0answers
11 views

Force Org-Link to inherit a different face when placed in org-table?

I currently have (variable-pitch-mode +1) set on a hook when I start org-mode. I have customized my org-mode faces such that faces like org-link inherit from my variable-pitch face. This looks great ...
1
vote
1answer
54 views

Reference cells of other tables in org-mode table as plain text

I intent to copy the value of a cell and put the exact copy to the target cell and be able to update the value on referenced cell to be updated on the targeted one. Calling remote to a cell evaluate ...
2
votes
1answer
42 views

org-table to calc matrix and back again?

Is it possible to feed data from an org table into calc as a matrix, and then get it out again as a vector to fill in a column? For example, if I have: | | Fund A | Fund B | Fund C | ...
2
votes
1answer
138 views

org column view with date calculations

* TODO fix this bug asap :PROPERTIES: :UPDATE: writing test cases almost there! :LASTUPDATED: 2019-11-25 :DEADLINE: 2019-11-30 :END: * TODO update that documentation :PROPERTIES: :UPDATE: updating my ...
2
votes
2answers
105 views

Export table to CSV file without prompt

I want to have tables that I can easily export to files. In this regard I want to associate a file path and a format to tables. This page in the docs is most relevant: https://orgmode.org/manual/...
0
votes
0answers
42 views

Org-mode parameters for custom table environment for LaTeX

I am using an overridden table environment based on tabular to get some custom cell coloring based on row alternation (similar to what rowcolors does, but also allowing column color variation at the ...
0
votes
1answer
108 views

org-mode headings to org-table

I have a big org file with lot of topics, and every topic have a books subheading. I would like write a function that can generate a list of all books in org-table. I was trying with (org-map-entries) ...
0
votes
1answer
49 views

How to transform abbrevated dates in org table

The input column represents the year without 201 and month and day without leading zeros. I must transform these into full date strings. After a couple of hours to take step 1, I'm wondering if there ...
1
vote
4answers
52 views

Convert text under a heading into an org-table

I am using spacemacs. I've written my shortcuts in an org file to not forget them. It has a structure of Description: key, then I go to the next line and enter the next command. For example *** Latex ...
4
votes
1answer
142 views

Org mode + table.el: Use Org formatting inside cells

Say I have a table in an Org document looking like this: (Source) +----------+-----------+----------+-------------------------------------------------------+ | Date | Day | Pages | ...
0
votes
0answers
27 views

How to make Alt-h work in Org mode in Spacemacs?

When inside a table in Org mode, I can press Alt-l to move the column to the right. But alt-h does nothing. The same happens when I try to put the heading one level deeper. Alt-l works but alt-h ...
0
votes
0answers
19 views

Is it possible to reference a variable or constant in a table cell?

I am trying to set a variable or constant to be used within multiple cells in a table, but it is either not possible or I am doing it wrong. For example #CONSTANTS a=3 |----------|--------| | number ...
0
votes
1answer
37 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 ...
1
vote
1answer
119 views

Convert org table to MS Excel?

Windows 10, Emacs 26.1 I has org mode table. Is it possible to convert it to MS Excel? Thanks.
0
votes
0answers
115 views

Merge two cells in an org table

I basically stumbled onto this older question how to merge cells in an org-table. This would be very useful to create a header, something like: |Merged header| |----+--------| | / | < | | 1 ...
3
votes
1answer
467 views

How do I have tables side by side?

I'd like to have small tables being shown side by side instead of one under the other, when I export to PDF. Is there an easy way to do that ? Like a break between tables ?
0
votes
1answer
30 views

How to get the number of rows between hlines for orgmode table formula?

In my orgmode table formula, i would like to get the number of rows between hlines (for example: @I..@II). Does anyone know how to do it?
0
votes
0answers
22 views

Org Mode tables: Wrapping lines to match an arbitrary width

In Org tables, I often use M-<RET> to wrap a long line in a column, at whichever place in the sentence I feel it needs to be wrapped. This sets a particular width to the column. Now sometimes I ...
1
vote
1answer
51 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 ...
1
vote
0answers
24 views

Spaces get trimmed when I use org table in (R) code block

Please, help! I use literate programming and I want to use org-mode tables as data for my R code blocks. However, when it comes to cell values that have meaningful leading and trading spaces org-mode ...
1
vote
0answers
97 views

Unicode characters in org-mode tables

Here's an org-mode table with some unicode math characters in it: Note that the columns don't align. I can manually fix the issue by inserting literal tab characters after each character via ctrl-q ...
0
votes
0answers
15 views

Org table beamer exports with white lines and text - How to change to another colour?

I am using org-mode to export a table to a beamer presentation (latex/pdf). The table is produced but the lines and text are white. Seeing as the background is white this means the slide looks blank....
0
votes
0answers
39 views

Org-table misaligns with Chinese data

Org table vertical lines do not align properly with Chinese data. | 標題一 | 標題二 | 標題三 | |----------+--------------+----------| | 中文圖表 | 直線會對不準 | 像這樣子 | | 這 | 是不是 | 問題 | | ...
2
votes
1answer
268 views

help with org-mode table formula

I want to track my cash flow and growth in text files. Here is the sample table and formula. Networth = sum of all accounts Growth = previous month networth - current month networth Growth % = ...
1
vote
2answers
54 views

Insert multiple blank line in table editor

I'm using the built-in table editor of org-mode. As described in the documentation, I can use M-S-Down to insert a row above my current row. Using the universal argument, I can create my new line ...
0
votes
1answer
31 views

org-mode table element selection with blanks

TL;DR: How do you send a list of elements from a table, including blank cells, to an elisp function? I have the table below with points on exam questions in columns 2-4. The second row contains the ...
0
votes
1answer
28 views

Is there a way to calculate rows on a “rolling” basis?

Rolling formulas are very common in accounting, for example, carrying forward a monthly balance based on expenses. So say you had a table with month, beginning balance, fixed income, expenses, and ...
0
votes
1answer
89 views

More detailed org-capture into org-table template?

(Disclaimer: I know this may seem like a very specific question. But: I haven't found the answers to similar questions to be close enough to what I need. I hope to get an answer that is easily ...
0
votes
1answer
111 views

Org-mode: customize delimiter for horizontal line in tables

The default column-delimiter for horizontal lines in tables is a + sign. How to change it to vertical bar |? Currently, it looks likes this: |---+---+---+---+---| | | | | | | |---+---+---+-...
1
vote
0answers
35 views

Insert the same item in multiple rows in orgmode

I would like to be able to insert the same string in consecutive rows of some column of an org-table. I am using spacemacs and there is a vim way to insert the same instances in all visually selected ...
3
votes
1answer
84 views

Is possible to have alternate table rows in another color in org-mode tables?

I would want something like this, for some specific tables with many rows (so columns are easier to read): I know about stripes mode (and sometimes I resort to using it), but that changes format for ...
1
vote
1answer
107 views

Naming the result of a source block

The following question has been asked (in slightly different form) in a comment of another answer: Is it possible to name the results of a source block with #+NAME: foobar (or equivalently but old-...

1
2 3 4 5