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
37 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
78 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
26 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
168 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
42 views

Org-table misaligns with Chinese data

Org table vertical lines do not align properly with Chinese data. | 標題一 | 標題二 | 標題三 | |----------+--------------+----------| | 中文圖表 | 直線會對不準 | 像這樣子 | | 這 | 是不是 | 問題 | | ...
3
votes
1answer
480 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
59 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
35 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
29 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
148 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
143 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
44 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
123 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
126 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
vote
2answers
110 views

Ipython code block producing org table

I saw a python code block example to output an array as an org-table. An example would be, #+BEGIN_SRC python :results value r = 3389.5 # km average radius re = 3396.2 # equatorial radius in km ...
0
votes
1answer
76 views

org-table: add hline based on change in column values

Given the following org-table: | col1 | col2 | col3 | col4 | |------+------+------+------| | 11 | 12 | A | 14 | | 21 | 22 | A | 24 | | 31 | 32 | A | 34 | | 41 | 42 | B ...
0
votes
2answers
93 views

Matching two columns in a table

I deal with a two column table where I have to match data from two sources. The first column contains names of persons for whom, service is provided. The second, persons who are billed. My job is to ...
1
vote
1answer
113 views

Using an org-table formula to sum up weekly time cards

I'm filling my time cards in an org-table like below. Is there a way to fill the column Totals automatically with a formula? For the individual lines in a project task, I'd like to sum the hours ...
6
votes
2answers
342 views

How to copy org-table to postgresql database?

With sqlite one can easily populate a table in a database via a org-table like so: [EDIT](using only one sqlite-scr-block with org-table variable parameter)[/EDIT] #+NAME: A | val1 | val2 | |------+...
1
vote
2answers
347 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
148 views

How do I display current cell address of an org-mode table?

I am trying to write some formulas in my tables and having a bit of a hard time figuring out the current cell's address (@row:$col). It would be awesome if I could display the cell location in the ...
1
vote
1answer
145 views

org-mode table row operations

Is it possible to do row operations of the following form in org-mode? | x1 | x2 | x3 | x4 | z1 | z2 | b | |-----+-----+-----+----+----+----+---| | 2 | 1 | -7 | -1 | 1 | 0 | 0 | | -39 | -7 ...
1
vote
0answers
83 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 ...
1
vote
1answer
574 views

Calculating with timestamps in org-mode tables

Emacs 26.1 | | Start date | End date | State | Task | Duration (hours) | |---+------------------------+------------------------+-------+----------+------------------| |...
0
votes
1answer
42 views

How to paste text into an org table with a set number of columns?

I usually have a bulk of items separated by either spaces or new lines and I want to have them all full a table with a set number of columns. Basically if I want the table to always have 3 columns, ...
0
votes
1answer
52 views

How do I reference a columnview table

I'm trying to get effort estimates out of a columnview table and do some math on it in a separate table. #+TBLNAME: estimate #+BEGIN: columnview :indent t | ITEM | TODO | Effort | ...
2
votes
1answer
134 views

Convert an org table into a tree

I have an org table and I will like to convert in into a tree. So, from: | 1 | 2 | 3 | |---+---+---| | a | b | c | | l | m | n | I will like to go to: * a :PROPERTIES: :2: b :3: ...
1
vote
2answers
81 views

Rotate the yanking ring

I have such a table | C | M | |---------------------+---------------------| | Character | Word | |---------------------+----------...
3
votes
2answers
950 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-...
0
votes
1answer
96 views

Sum columns duration/days and duration/hours

In my org file I have the table: | | Start date | End date | State | Task | Duration/days | Duration (hours) | |---+------------------------+------------------------+--...
2
votes
2answers
356 views

Table formula for dates delta

Here my org table: | | Start date | End date | State | Duration | |---+------------------------+------------------------+-------+----------| | # | <2019-01-02 Wed 10:...
0
votes
2answers
141 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 ...
1
vote
2answers
876 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-...
1
vote
2answers
621 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-...
3
votes
1answer
205 views

Org table: Calculate units

Are Org tables able to calcultate units? Say I have a table | test | Voltage | DC | Current | Power | |----------+----------+-----+------------+-------------| | DC-motor | 12 V | ...
5
votes
1answer
2k views

Using File Local Variables in org-mode

Is there a way to use file local variables set in an org-mode file in the following contexts: Simply expanding the variable when text is exported (eg: to LaTeX) Passing the value to :var in a babel ...
1
vote
2answers
260 views

How to move just one value in a table to a different column

Is there a command for moving only the value 11 to the right column in the following column? | Name | | | |------+----+---| | a | 11 | | | b | 10 | | Something like org-table-move-...
1
vote
3answers
87 views

Separately sum positive/negative numbers?

By example: | | Amount | |---+--------| | | 3.50 | | | 1.00 | | | -6.00 | | | 5.00 | | | -2.50 | |---+--------| | | 9.50 | | ^ | wins | |---+--------| | | 8.50 | | ^ | ...
3
votes
1answer
586 views

Org capture into org table

Normally org-capture lets one insert a templated subtree somewhere into an existing Org file or tree node. Is it possible to use org-capture to instead add a row to an existing Org-mode table?
4
votes
3answers
246 views

Make Org Table with #+NAME label collapsible

I have an org table with has a NAME label like: #+NAME: TBL | Foo | Bar | In the past I have always been able to expand and collapse the whole table by cycling using TAB on the #+NAME line. However ...
2
votes
1answer
289 views

org-table-copy-down for dates

Suppose I have an org-table like this: | 2018-09-09 | | | | | | 2018-09-10 | | | | | | 2018-09-11 | | | | ...
4
votes
2answers
117 views

Text substitution only in specific column of org table

I came across this problem today: I had a table with many entries and wanted to perform a text substitution (normal text substitution was sufficient as I hardly ever need regex text substitutions) in ...
0
votes
1answer
256 views

How do I ensure org-sbe is consistently passed a string when copying tables

I'm trying to transform the data from one table to another however I can't do it with built in functions so I have to use org-sbe to call some elisp: #+tblname: clues | 02a8 | 0050 | 5012 | 2225 |...
8
votes
1answer
1k views

Reference the last column / row in an org-mode table

The Situation: I read the Org Spreadsheet tutorial but couldn't find an answer. Commonly, I want to have the result of a formula in the last row of a table, i.e., have something like #+TBLFM: @LAST$...
0
votes
1answer
53 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 ...
1
vote
1answer
269 views

verbatim vertical bar in org table

I am trying to have a vertical bar inside a verbatim environment as part of an org-mode table. Following https://orgmode.org/manual/Built_002din-table-editor.html#FOOT20 I have tried this: | =find -...
1
vote
0answers
522 views

Import CSV into org-mode table, but preserve quotes around strings

I really like the ability to quickly go between CSV tables like this: a, b, c this, TRUE, 5, that, FALSE, 8 ...and org mode tables, that look like this: | a | b | c | | this | TRUE | 5 | | ...
0
votes
1answer
114 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 ...
2
votes
1answer
498 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 | | # | ...
0
votes
0answers
38 views

Save .org file from org table edit field buffer

Is there any command to save the org file from the org table edit field buffer? If not, is there any way to check if the current buffer is an org table edit field buffer? More details: When I am ...