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
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 ...
Sam7919's user avatar
  • 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 ...
tinlyx's user avatar
  • 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 ...
Garid's user avatar
  • 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:
shynur's user avatar
  • 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&) &...
vfclists's user avatar
  • 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 ...
Laurent Jacques's user avatar
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, ...
Pietro's user avatar
  • 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 | ...
martinoidar's user avatar
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&...
Niclas Börlin's user avatar
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 ...
azizan's user avatar
  • 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 | |----------+-----...
crocefisso's user avatar
  • 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 | |--...
ontheair's user avatar
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: @>$>=@>$> ...
starquake's user avatar
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 | | [%, ...
starquake's user avatar
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;%....
starquake's user avatar
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 ...
01AutoMonkey's user avatar
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&...
Edman's user avatar
  • 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 ...
crocefisso's user avatar
  • 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 | | | ...
user avatar
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 | ...
Pedro Delfino's user avatar
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 |---------------+--------------------------------------------...
crocefisso's user avatar
  • 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: ...
Garid's user avatar
  • 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 ...
Dargscisyhp's user avatar
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, ...
Rob N's user avatar
  • 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 ...
Sam7919's user avatar
  • 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 | | | | | | | | | | | | | | ...
Sam7919's user avatar
  • 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 | |---+-------...
crocefisso's user avatar
  • 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))) #+...
Stephan Neuhaus's user avatar
0 votes
2 answers
39 views

Fixing tables in orgtbl-mode

So I had a table that looked like this +---------------------------+------------------------------------------------+ | Version | Minimum OS Requirements | +---...
ychaouche's user avatar
  • 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 | #+...
Eminent's user avatar
  • 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 | ...
Sam7919's user avatar
  • 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 ...
Sam7919's user avatar
  • 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 ...
tinkerpunk.the.prol's user avatar
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 ...
147pm's user avatar
  • 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 ...
xdl's user avatar
  • 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 ...
Betta George's user avatar
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 ...
tdstoff's user avatar
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>...
crocefisso's user avatar
  • 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 ...
vfclists's user avatar
  • 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? #+...
user avatar
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? ...
Eminent's user avatar
  • 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 |...
crocefisso's user avatar
  • 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 ...
Christoph's user avatar
  • 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 ...
ToooBias's user avatar
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 ...
crocefisso's user avatar
  • 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 *** ...
Hrishikesh's user avatar
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 | ...
Eminent's user avatar
  • 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& ...
Levo's user avatar
  • 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 | ...
Michel Lecomte's user avatar
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 ...
megeton's user avatar
  • 37

1
2 3 4 5
8