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.
206
questions
1
vote
2answers
10 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
...
1
vote
0answers
18 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
13 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
14 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
22 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
49 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
40 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 ...
2
votes
1answer
352 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
25 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
17 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
35 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
20 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
39 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
12 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
34 views
Org-table misaligns with Chinese data
Org table vertical lines do not align properly with Chinese data.
| 標題一 | 標題二 | 標題三 |
|----------+--------------+----------|
| 中文圖表 | 直線會對不準 | 像這樣子 |
| 這 | 是不是 | 問題 |
| ...
2
votes
1answer
105 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
48 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
28 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
67 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
60 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
24 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
62 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
77 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-...
0
votes
2answers
67 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
67 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
0answers
18 views
Recalculate buffer tables after field motion commands?
I would like emacs to automatically run org-table-recalculate-buffer-tables every time and only if
A) cursor is in a table
AND
B) after a field motion command (TAB, S-TAB or RET) OR (optionally) ...
0
votes
0answers
75 views
Using org-mode clock-report, how can I add a total row + cell with a formula that is automatically updated upon dblock update?
I am having trouble with using the formulas to create a cell that totals a column. Is it possible to dynamically add a line and a total cell to the bottom of clock report tables? because when I add a ...
0
votes
2answers
40 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 ...
0
votes
0answers
15 views
columnview vs ID
I would like to produce a table which filters by ID using columnview, is it meant to be used as a filter?
using org 9.2.2, emacs 25.2.2, linux
* columnview filter test
:PROPERTIES:
:COLUMNS: %ID ...
1
vote
1answer
82 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
154 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
189 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
0answers
27 views
Partial table fold in `org-mode`
I wonder whether it is possible to fold (as in code folding) part of a long table in org-mode.
0
votes
1answer
58 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
71 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 ...
0
votes
0answers
45 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
203 views
Calculating with timestamps in org-mode tables
Emacs 26.1
| | Start date | End date | State | Task | Duration (hours) |
|---+------------------------+------------------------+-------+----------+------------------|
|...
0
votes
1answer
38 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
34 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
88 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
42 views
Rotate the yanking ring
I have such a table
| C | M |
|---------------------+---------------------|
| Character | Word |
|---------------------+----------...
3
votes
2answers
631 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
68 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) |
|---+------------------------+------------------------+--...
0
votes
2answers
68 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
1answer
224 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-...
0
votes
1answer
160 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
108 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 | ...
4
votes
1answer
908 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
128 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-...
