Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more

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
2 votes
1 answer
46 views

How Do I Calculate the File Time for a Given Week Number?

I would like to create a table where one column contains a range of week numbers and another contains the clocked file time for each of those weeks. The latter column should be filled automatically ...
Wildebeest's user avatar
2 votes
3 answers
125 views

How to convert an org-table to JSON?

Here is a minimal example of an org-table: #+NAME: radar |----------+------| | Variable | Val | |----------+------| | Red | 43.3 | | Blue | 83.1 | | Yellow | 86.4 | |----------+------| I ...
crocefisso's user avatar
  • 1,351
1 vote
4 answers
69 views

In org-mode, can I show the formula of the table cell at point in eldoc?

I'd like C-c ? to happen automatically when I focus on a table cell, is there something built-in to do this? (Or is there some other way to quickly show which cells are "input" vs "...
unhammer's user avatar
  • 1,159
0 votes
0 answers
21 views

Is there a compact way to use `@I` notation in Org-Mode table / Spreadsheet?

To get all the values between the first hline and the third you'd normally do @I..@III, however I'm already in my ninth line, and it's getting longer by the time I get to others. Is there a more ...
Maxi_2601's user avatar
0 votes
2 answers
24 views

org table formula throws error when it depends on another formula

In my training center, i have the students name put into a table. And I like to parse the names into first, middle and last names. AFAIK, there is no indexOf string function in elisp. So, I thought of ...
Saravana's user avatar
  • 2,071
0 votes
1 answer
46 views

Floor timestamp to nearest quarter in the hour

How to floor timestamps to their nearest quarter in the hour in an org-table. I can't seem to convert the stamps to only minutes to do calculations. Or is there another way? | start | floored | |------...
my_display_name's user avatar
1 vote
2 answers
117 views

Create table with circles around words and hiding some of the grid lines in Emacs Org-mode

I am new to Emacs. Is there any way to create a table in Org mode like in the example table below. Particularly I'd need to be able to circle some of the words and hide some of the grid lines. The end ...
Tiberius's user avatar
  • 113
1 vote
1 answer
98 views

Is it possible to do conditional formatting on an org-table?

Here is an example of a table to format, the first row represents how often a task is done per year, the first column represents how long a task takes in seconds |-------+------------+-----------+---...
crocefisso's user avatar
  • 1,351
0 votes
1 answer
42 views

Is it because this org-table formula contains double quotes it doesn't work?

| Column Name | Description | Comment | |--------------------+-------------------------------------------+---------| | lyt_form_id | record id ...
vfclists's user avatar
  • 1,423
0 votes
1 answer
94 views

How to export a PostgreSQL DB model to an org-mode file with tables

Having a PostgreSQL DB model defined in SQL, i would like to generate an org-mode file with a bunch of org mode tables to document it. So for each CREATE TABLE, it creates an org-mode table with its ...
nephewtom's user avatar
  • 2,261
0 votes
1 answer
54 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
  • 379
1 vote
1 answer
45 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,348
2 votes
1 answer
79 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
  • 641
1 vote
2 answers
76 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
  • 5,318
0 votes
0 answers
20 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,423
0 votes
0 answers
14 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
98 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
  • 121
0 votes
1 answer
43 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
24 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
90 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,351
1 vote
1 answer
75 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
73 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
123 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
548 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
26 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
18 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,229
4 votes
1 answer
124 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,351
0 votes
1 answer
65 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
89 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
53 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,351
2 votes
1 answer
124 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
  • 641
0 votes
1 answer
82 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
59 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
  • 649
0 votes
1 answer
264 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
  • 379
0 votes
2 answers
98 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
  • 379
0 votes
1 answer
73 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,351
0 votes
1 answer
158 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
47 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
1 answer
79 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
  • 379
1 vote
5 answers
428 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
  • 379
0 votes
1 answer
57 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 ...
Tinker's user avatar
  • 116
1 vote
0 answers
101 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,969
1 vote
1 answer
205 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
328 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
56 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
145 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,351
0 votes
1 answer
264 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,423
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
399 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
2 3 4 5
8