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.
363
questions
0
votes
1
answer
26
views
How can I compute a running sum? [duplicate]
To get a running sum in column $2, row i of all entries in column $1 from the first row @1 up to and including row i,
| 1.01 | |
| 2.02 | |
| 4.04 | |
the tedious solution is to write (for three ...
- 339
1
vote
1
answer
19
views
How to make orgtbl-mode work within embedded LaTeX environment in org-mode itself?
I read a blog, which mentioned using orgtbl-mode to write a matrix quickly in org table format and then translated it into the LaTeX format. The post mentioned that due to the close relation between ...
- 1,314
2
votes
1
answer
58
views
Configuring Key-bindings from Org-Table
I use init.org file to configure my emacs, and then tangle it into init.el.
Now, I would like to configure my keybindings from org-table (for more readable and printable).
Basically, I'd like to only ...
- 589
1
vote
2
answers
54
views
add Horizontal/Vertical Dividing Lines for the exported HTML table
For example, here's an Org file:
| A | B |
| C | D |
| A | B |
|---+---|
| C | C |
How to make the exported HTML tables look like:
A
B
C
D
More specifically, I want these dividing lines:
- 4,563
0
votes
0
answers
17
views
Are alphabetic cell references in org-table spreadsheet valid?
I have this formula in one of my org-tables:
#+TBLFM: A&='(concat "(vhtd/filegroups-init-group" " " (rc-dq C&) " " (rc-dq B&) " " (rc-dq D&) &...
- 1,371
0
votes
0
answers
8
views
define a special org-link face inside of org-table, different from outside?
I'd like to define a special org-link face inside of org tables, such as to set link to fixed fonts within a table, and to variable fonts outside. I tried to play with custom-theme-set-faces in ...
0
votes
1
answer
46
views
How to center a table with respect to the page, and how to reduce its font size?
I need a table to be centered with respect to the page. By default it is aligned with the left text border, and being large it exceeds the right page margin:
This is the Org-mode source:
Normal text, ...
- 107
0
votes
1
answer
37
views
Is it possible to work with org-mode tables inside org-babel source blocks as if they were placed directly in an org-file?
Imagine we have the following content of an org-file:
| | Col 1 | Col 2 |
| row 1 | | |
| row 2 | | |
#+name: Table1
#+begin_src org
| | Col 1 | Col 2 |
| row 1 | ...
- 125
1
vote
0
answers
20
views
orgtbl-to-orgtbl removes special header lines
I have a table with some formatting lines in the header, e.g.,
#+ORGTBL: SEND DEST orgtbl-to-orgtbl :splice nil :skip 0
| N | First name | Last name |
| / | < | < |
| <l&...
- 628
0
votes
0
answers
21
views
Evaluating expressions inside conditionals in org tables [duplicate]
Evaluating expressions inside conditionals works in elisp
(defun usd(amount currency)
(if (string= currency "USD")
amount
(/ amount 3.75)))
(usd 123 "USD") ; => 123
...
- 1
1
vote
1
answer
80
views
How to express time inside an org-table formula?
Consider the following org-table, where the first 3 columns are inputs:
|----------+-------+-------+----------+------+--------|
| Date | Start | End | H. slept | | Delta |
|----------+-----...
- 1,220
0
votes
1
answer
42
views
org-clock-report: Add line and calculate average working hours
I am using org-clock-report to keep track of my daily working hours. Example:
#+BEGIN: clocktable :scope file :maxlevel 2
#+CAPTION: Clock summary at [2023-07-26 Mi 06:04]
| Headline | Time |
|--...
- 25
0
votes
1
answer
44
views
Orgmode-Spreadsheet: TBLFM-In-cell-calculation also possible with elisp code?
Cell fields do automatic calculation by default.
For example
|-------+----------|
| Test | Value |
|-------+----------|
| Stone | 5.4+12.3 |
|-------+----------|
#+TBLFM: @>$>=@>$>
...
- 53
0
votes
3
answers
96
views
How to turn numeric percent cell content |86%| into progress bar ▊▊▊▊------ purely with TBLFM & elisp code?
This is a bit trickier, but the result is awesome:
|-------------------------------------------------------|
| Progress |
| [%, ...
- 53
0
votes
2
answers
203
views
How to round on 2 decimals in org mode table using elisp?
That's probably a low hanging fruit.
In short, what I want:
6.7690001 ---> 6.77
I know how to do it in org mode table using regular TBLFM:
|---------|
|6.7690001|
|---------|
#+TBLFM: @1$1=@1$1;%....
- 53
0
votes
0
answers
24
views
Emacs Org Mode concept of duration? An easily written and sortable string defining durations
Does Emacs Org Mode have a concept of "durations"? Specifically I want to define durations in years, months, weeks, and/or days, and then sort a column of such data.
Possibilities:
Emacs ...
- 125
0
votes
1
answer
13
views
Efficient way to change the format of a date in orgmode
enter code hereWhat would be the most efficient way to change the format of a list of dates like this in Emacs:
|Bob|1966/08/20|2023/05/19|
|Janice|1964/09/18|2023/05/19|
To this:
|Bob|<1966-08-20&...
- 1,167
3
votes
1
answer
92
views
How to show percentages in org-tables? [duplicate]
Consider the following table:
|--------+------|
| Number | % |
|--------+------|
| 0.004 | 0.40 |
| 0.0047 | 0.47 |
| 0.01 | 1.00 |
| 0.019 | 1.90 |
|--------+------|
#+TBLFM: $2=$1*100; %.2f
...
- 1,220
0
votes
1
answer
48
views
Is there a way to escape `|` inside tables?
If I tab this:
| Expression | Meaning |
|---+---|
| /a|b/ | a or b |
I get this:
| Expression | Meaning | |
|------------+---------+--------|
| /a | b/ | a or b |
| | ...
user19777
0
votes
2
answers
54
views
How to mark and execute multiple table formula expressions to update an org table at once?
Suppose I have this org-mode table:
| Ativo | Valor R$ | % Percentual |
|-------+----------+--------------|
| A | 13.0 | 0.1300 |
| B | 33.0 | 0.3300 |
| C | 54.0 | ...
- 1,409
1
vote
1
answer
47
views
How to build a script that queries an org-table?
I have a list of more than 80 search engines to perform keyword searches. They are listed in an org-table like this:
#+name: keyword-search
|---------------+--------------------------------------------...
- 1,220
2
votes
1
answer
89
views
How to divide too long header-arguments of src-block into multiple lines?
I'm trying to process tens of tables (from multiple org-files) in python src-block at once.
Suppose that the following file: /tmp/file1.org contains some tables:
* This org contains the tables
#+name: ...
- 589
0
votes
1
answer
52
views
How can I wrap the main text of a document around a table when exporting from Org to Latex?
I have a long, skinny table that's likely going to end up spanning multiple pages that I'm using the longtable environment for. I want to have this placed on the left-hand side of my document, and to ...
- 380
0
votes
1
answer
44
views
A way to label rows for formulas in org-mode tables?
I'm doing some tax calculations. The tedious instructions usually read like:
Subtract line 7 from line 4.
Enter the smaller for lines 2 and 3
If I'm trying to do this in a table like below, ...
- 577
0
votes
1
answer
110
views
Quickly inserting a separator line before and a column after in an org-table
It's quite easy to enter an org-table in org-mode in Emacs.
One simply types |Name|Phone| Tab.
| Name | Phone |
| | |
Inserting a separator line before
It's also easy enough to insert a ...
- 339
0
votes
2
answers
66
views
Discerning org-mode's two table styles
Prelude
I understand that org-mode has two distinct styles of tables. The two styles can be identified visually.
One looks like this
| | | |
| | | |
| | | |
| | ...
- 339
0
votes
1
answer
60
views
How to export a table with dash-lines
The following org file :
#+LATEX_HEADER: \usepackage{arydshln} % Draw dash-lines in array/tabular environments
| / | < | <> |
|---+--------+-------|
| | Name | Value |
|---+-------...
- 1,220
0
votes
1
answer
75
views
How can I add a +NAME: to an org-mode table created through emacs-lisp?
I have the following code:
#+BEGIN_SRC emacs-lisp :results value table
(append '(("a" "b" "c" "d")
hline
(1 2 3 4)
(5 6 7 8)))
#+...
0
votes
2
answers
39
views
Fixing tables in orgtbl-mode
So I had a table that looked like this
+---------------------------+------------------------------------------------+
| Version | Minimum OS Requirements |
+---...
- 207
0
votes
0
answers
18
views
Recalculating org-mode table causes it to be misaligned when there are multiple tables
Here is my org-mode file foo.org:
| Category | Points |
|-----------+--------|
| Minecraft | 13 |
| Tetris | 6 |
| Bricks | 1 |
|-----------+--------|
| | 20 |
#+...
- 67
0
votes
1
answer
64
views
How can I fill a column with relative indexing in org-mode?
It turns out that ses-mode (Simple Emacs Spreadsheet) is
not yet ready
for doing operations on rows/columns.
And so I'm turning my attention to org-mode.
I store the following data in a .org file
| ...
- 339
1
vote
5
answers
401
views
How do I switch a .txt table to a .org table?
I already have the following table in a file elite_cyclists.txt
Name Height Weight BMI
Nairo Quintana 167 59 21.2
Chris Froome 186 68 19.9
Robert ...
- 339
0
votes
1
answer
43
views
Scheduled timestamp inside of tables
I am creating a table for the upcoming winter season of anime and when I try to insert scheduled timestamps into the table for release dates it automatically pushes the timestamp under the nearest ...
1
vote
0
answers
59
views
Place caption at bottom of table?
I found this which would seemingly indicate that you just run
(setq org-html-table-caption-above nil)
if you want the caption to appear below the table. But it doesn't. How can I make the caption ...
- 2,937
1
vote
1
answer
121
views
orgmode spreadsheet: using an column formula but only between two hline separators
I'm currently keeping track of expenses using an org table; some are billed annually and some monthly and I'd like to eyeball the total monthly number. I used to use something like this:
| Bill ...
- 125
2
votes
2
answers
246
views
Fold tables in org mode
Is there a default way to make tables in org mode foldable? Obviously, I can just advise org-table-create to wrap the new table inside a drawer, but I was wondering whether this is overdesigned and ...
- 57
0
votes
1
answer
35
views
Remove rows/columns of Org table before passing to a Babel block
Is there a simple way to remove specific rows/columns of an Org table when passing them to a Babel block?
For example, I'd like to process the data in the table below using Matlab. The column headers ...
- 5
0
votes
3
answers
106
views
How to use table lookup functions results as input for calculations?
I have the following static table:
#+name: static
|-------+---------------+-----+--------|
| | Date of birth | Sex | Height |
|-------+---------------+-----+--------|
| Croce | <1985-07-30>...
- 1,220
0
votes
1
answer
163
views
What is the syntax to get org-table-get-remote-range to reference table cells in another file?
According to the docs if a file filename has a location in it like this, using the form (org-table-get-remote-range NAME-OR-ID FORM)
* Location
:PROPERTIES:
:CUSTOM_ID: Location
:END:
| a | b ...
- 1,371
0
votes
1
answer
32
views
calc: fill multiple adjacent rows with a formula?
With Table>Set Field>Formula, I'm able to do what I want for a particular field, in this case that corresponding to Aug 07. How can I fill multiple adjacent fields in one go, say Aug 7-15?
#+...
user19777
1
vote
1
answer
286
views
How to use fonts for normal text for org-mode tables?
Since the Emacs version upgrade to version 28 org-mode tables have become very small in size. Their font size has been reduced. Is there a way to tell Emacs to use the default font for the tables?
...
- 67
1
vote
1
answer
77
views
Where can I find org-table formatting documentation?
I'd like to do some formatting on org-tables than I'm using. For example, make this table :
|----------------+----------+---------+---------+---------|
| Russia | 12000000 | 1700000 | 4950000 |...
- 1,220
0
votes
1
answer
371
views
org mode tables slowed down by evil mode
I am trying to create a table in org-mode like that (/ is where my cursor is)
| this is a test | foo | bar |
| ---------/---- | --- | --- |
If I now press enter, emacs hangs and I have to interrupt ...
- 101
1
vote
1
answer
143
views
Org mode table range excludes empty cells
For me this problem occurs when using org-lookup-first. However, I think this might happen in a lot of other circumstances as well. When specifying a range of cells for example via @1$1..@>$1 it ...
- 13
2
votes
2
answers
116
views
How to show an org-table from another file?
I have a refcards.org file where I store and maintain tens of tables (each having a specific name, e.g. #+name: key-somename).
I would like to mention and show these tables in some other org files ...
- 1,220
0
votes
2
answers
307
views
Getting content of paragraph element using Org Element API
I've been trying to get the content of the paragraph element unsuccessfully using org-element-contents, is there something I am missing here?
I have a org document as follows:
* world
** China
*** ...
- 103
1
vote
0
answers
33
views
Why does C-u C-c C-c place the vsum() in current row of an org-mode table instead of the row mentioned in #+TBLFM?
I have this org-mode table in a file named 1.org:
| . | A | B | C |
|---+----+-----+------|
| X | 10 | 100 | 1000 |
| Y | 20 | 200 | 2000 |
| Z | 30 | 300 | 3000 |
|---+----+-----+------|
| T | ...
- 67
2
votes
1
answer
178
views
horizontal lines in org mode tables
I want to obtain in org mode tables something like \cline to limit horizontal lines. For example
\begin{tabular}{|c|c|c|}\hline
$p$ & $q$ & $p \rightarrowq$ \\ \hline
0& 0& 1\\
0& ...
- 47
0
votes
0
answers
181
views
Formating a table with org mode
Can someone tell me how to format this sample table with org mode..
| A | B | C | Total | -> Header title center align ?
+-----|-----|-----|---------|
| 5 | 5 | 5 | 15 |
| 6 | ...
- 169
1
vote
1
answer
54
views
orgtbl-toggle-comment freeze in one line table
For example, write only one line in foo.org.
| a |
So if execute M-x orgtbl-toggle-comment, it will freeze.
(can stop with C-g)
Is there a way to solve this?
environment:
org-version is a variable ...
- 37