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
1answer
66 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 ...
2
votes
1answer
71 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
26 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
335 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 ...
1
vote
1answer
24 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 ...
2
votes
2answers
486 views

Table formula for dates delta

Here my org table: | | Start date | End date | State | Duration | |---+------------------------+------------------------+-------+----------| | # | <2019-01-02 Wed 10:...
0
votes
0answers
144 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
49 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 ...
4
votes
1answer
206 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 | ...
2
votes
2answers
439 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/...
2
votes
2answers
113 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....
0
votes
4answers
125 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 ...
4
votes
3answers
1k views

Conditionally calculate the sum of a column depending on a fields value in another cell of the same row

In orgmode, I do have a table like the following to track my overall working time a day. It is not important for which tasks or projects or even which client I spent my time on, just if I was in ...
1
vote
1answer
43 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 "...
11
votes
2answers
2k views

How can I filter table in org mode

For example, I want to filter table that make it shows the row which only contains "USA" string in the column 3 and 4.
0
votes
1answer
124 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-...
1
vote
0answers
26 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
26 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 ...
1
vote
2answers
1k views

Org-Mode How to position tables correctly when exporting to Latex?

I have a document I have written in org-mode which contains several tables. The tables all have the following attributes. #+begin_table #+LATEX: \caption{Initial risk List} #+LATEX: \label{tab:risk-...
5
votes
2answers
300 views

Auto-update org tables before each export

I am looking for a solution (a function) that evaluates all the tables in the org file/buffer. I should be then simply able to add that to the local value of before-save-hook in org-mode. Currently, ...
3
votes
1answer
389 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
1answer
55 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 | ...
1
vote
4answers
61 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 ...
0
votes
1answer
226 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
50 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 ...
11
votes
5answers
797 views

Preview fields in org table

Sometimes it is convenient to set a manual column width when creating a table in org-mode. This makes it so that columns do not have to grow to the size of their longest entry. When an entry in and ...
0
votes
0answers
42 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
2answers
167 views

orgmode table time string delta with formula

I wish to calculate time string delta as below: | date | delta | |------------+-------| | 2018/12/28 | 0 | | 2018/12/31 | -1 | #+TBLFM: $2=if(2==@#, 0, ($1 - @-1$1); %.0f The expected ...
2
votes
1answer
392 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.
8
votes
2answers
4k views

org-mode table exports centered - change to left?

I'm exporting a simple org-table through LaTeX to PDF: | a | b | c | | 1 | 2 | 3 | After export with C-c C-e l o the PDF contains a centered table, and I'd rather have it on the left (to be clear, I'...
1
vote
0answers
437 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
641 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
48 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?
1
vote
1answer
102 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 ...
2
votes
1answer
582 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 | | # | ...
1
vote
0answers
31 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 ...
0
votes
0answers
51 views

Org-table misaligns with Chinese data

Org table vertical lines do not align properly with Chinese data. | 標題一 | 標題二 | 標題三 | |----------+--------------+----------| | 中文圖表 | 直線會對不準 | 像這樣子 | | 這 | 是不是 | 問題 | | ...
3
votes
1answer
771 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
63 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 ...
1
vote
2answers
405 views

Orgmode tables: Insert row within column

I would like to know, how to add a new line in a column without changing the other columns. Alternatively, how to move up a cell in a column without changing the other columns. Here is an example (...
0
votes
1answer
37 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
31 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 ...
10
votes
2answers
3k views

Org mode: Using todo-items or checkboxes in tables

I have several items that I need to perform the same tasks on. To get an overview, I wanted to use a table, where the columns would show me how many are done, something like this: +------+------------...
0
votes
1answer
187 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
178 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: |---+---+---+---+---| | | | | | | |---+---+---+-...
0
votes
1answer
133 views

Capturing data in org-file to org-table

I have a simple template in emacs org-mode: \begin{flushright} Name: Phone no: Billed amount: Date \end {flushright} Details: I export the document to PDF and print it. I create multiple ...
3
votes
2answers
1k views

Orgmode table error - shrunk field?

I'm very new to Emacs and Org mode, so I'm basically fumbling around. I'm getting an alarm bell ding whenever I type in an table in an *.org file. A message says "invalid function: org-table-with-...
1
vote
0answers
183 views

How to move by columns in an org table?

The title pretty much says it all. I'm looking for something similar to M-f and M-b to move right or left column-wise in an org-mode table.
1
vote
0answers
51 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 ...
0
votes
1answer
54 views

after update from ubuntu 16.04 to 18.04 cannot publish project; getting “eval: Symbol’s value as variable is void: org-enable-table-editor”

It appears that I've also lost the ability to use Emacs Org basic table editing commands. For example, when I start a table with a | and add the column headings then hit TAB, Emacs returns the same ...