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
22 views

How to fill in a formula into adjacent cells in org-mode spreadsheet?

For example, in the following table |------------+------------+-----+-----+-----+-----+-----+-----+-----+-----| | Pobability | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | | Odds ...
0
votes
2answers
31 views

How to compute ln in Org-Mode spreadsheet

Is there a formula to compute the natural logarithm of a number in Org-Mode spreadsheet? For example, to compute ln(1), Excel or Calc formula is =ln(1), what would it be in Org-Mode? The result should ...
0
votes
1answer
26 views

How to properly align org table with mixed English-Bengali script?

I am unable to tidy up this table, so that last column is properly aligned, as the other two: |-----------+----------------+------------| | English | Bengali s. | Bengali w. | |-----------+------...
0
votes
0answers
12 views

Org mode tables with Devanagari characters look misaligned

Here is the table: |----+-----------| | No | Name | | 1 | Mumbai | | 2 | मुंबई | | 3 | पुणे | | 4 | उस्मानाबाद | |----+-----------| With devanagari characters, the table cell ...
1
vote
1answer
34 views

orgmode - calculate difference between two remote tables

I use below code to calculate the difference between two columns from remote tables but the output is all zero! #+name: tbl1 | x | | 1 | | 2 | | 3 | #+name: tbl2 | y | | 1 | | 1 | | 1 | #+name: ...
1
vote
4answers
59 views

Merge Columns Together in Org-Mode Tables

Is there a way to merge columns together in an org-mode table? Often when I auto-create a table it will split certain fields into unnecessary columns. I would like a way to select those columns and ...
0
votes
0answers
30 views

Why is a TAB character added when using kill-rectangle and yank-rectangle to insert multiple rows into an org-mode table?

I noticed an annoying behaviour when copying multiple rows (a list) from a web page into an org-mode table, following a process inspired by Is it possible to copy /paste multiple lines of text into ...
1
vote
1answer
17 views

What parameter in orgtbl-to-latex to set column width?

I am trying to set the alignment width of columns in latex. I am using orgtbl's orgtbl-to-latex I want to override the resultant \begin{tabular}{lllll} to something like \begin{tabular}{rlccp3 cm)} ...
0
votes
1answer
22 views

How to control image sizes inside of table

I know that you can write something like: #+attr_html: :width 250 px [[./linl/to/image.jpg]] But what if I have them inside of a table like: | [[./linl/to/image.jpg]] | [[./linl/to/image2.jpg]] | ...
1
vote
2answers
98 views

Is it possible to export an org table into an interactive table?

Org-mode can nicely export tables into html customly. However, these exported tables cannot be sorted or filtered (i.e. are not interactive). Would it be possible to make these tables sortable and ...
0
votes
0answers
57 views

How can I use calc to convert in orgmode table

I am trying to use calc convert in an org mode table. The gnu manual suggests $c/$1/$cm So in my table I tried (for column formula =$c/$1/$cm also tried =$1/$c/$cm, =$1/$m/$cm etc Which produces #...
0
votes
3answers
61 views

org mode sum time from remote table with org-lookup-all

I have two tables #+NAME: tasks | name | spent | |--------+--------| | task 1 | | | task 2 | | | task 3 | | | task 4 | | | task 5 | | #+NAME: works | date ...
4
votes
2answers
96 views

How does if() work in org spreadsheets?

I got the impression from the manual that | a | | | b | | #+TBLFM: $2=if($-1==a, 1, 0) should produce "1" in the first row and "0" in the second. But instead I ...
0
votes
1answer
21 views

org table apply formula from specific row onwards

| BookmarkLevel | BookmarkPageNumber | ActualPageNumber | |---------------+--------------------+------------------| | 1 | 11 | | | 2 | ...
0
votes
1answer
24 views

disable table mode using either #+BEGIN_EXAMPLE or ‘:’ literal line , but insert latex math block $ … $

I’m trying to typeset a grammar in org markup, but want to use latex symbols in the grammar: a -> hello | $\neg$ world | universe • Now, without using #+BEGIN_EXAMPLE or : literal-line ...
0
votes
1answer
57 views

Table formulas involving percentages

I'm creating a table with percentages and calculating a simple sum of a column. The only thing left is to show the result of the formula as a percentage. Here is my MWE: | Element | $ | | E1 | ...
0
votes
1answer
13 views

Is the formula line tracking column insert properly in an org table?

I exhibit with a simple table. My org version is Org mode version 9.2.4 (9.2.4-10-g3b006f-elpa @ /Users/alanwehmann/.emacs.d/elpa/org-20190715/) | 1 | 2 | 3 | 4 | | 5 | 6 | 7 | 8 | | 9 | 10 | ...
1
vote
1answer
33 views

Pass a subset of the columns of a table to a script

I would like to pass only some columns of a table to a script: #+name: table #+RESULTS: | Col0 | Col1 | Col2 | Col3 | |-------+------+------+------| | Line1 | 1 | 2 | 3 | | Line2 | 4 | ...
0
votes
1answer
40 views

Links in Tables - fonts mess up table alignment

I would like to use links in a table to explain certain entries more in depth. | Some | random | table | entries | | More | data | and | LINK | <- misaligned * LINK target with - more ...
1
vote
1answer
39 views

Row descriptor -X leads outside table

I'm trying to calculate a new column on an org table, I'm using the following table formula: #+TBLFM: $9=if (@# > 15, ($6-@-14$6)*100000/10724599, 0) It's taking the difference on column 6 between ...
1
vote
1answer
179 views

org-mode table: how to add the left-most vertical line with column groups notation?

The documentation suggests that column groups syntax is a general way to add vertical lines in a table. For instance, the following org-mode's table snippet |--------+----------| | | Column 1 | ...
0
votes
1answer
175 views

Org-plot with gnuplot (searching for program: No such file or direcotry, aspell)

I am trying to plot simple examples in org-mode by using gnuplot. But it keeps telling me "Searching for program: No such file or directory, aspell". I installed gnuplot both to on emacs and ...
1
vote
1answer
167 views

Hide table border lines in org mode tables?

Is it possible to configure an org-mode table so that all border lines of the table are hidden when exported (e.g. to .tex, pdf and HTML)? I found a similar question in Emacs.SE but wasn't sure ...
1
vote
1answer
51 views

How to type a^b in org-mode?

In an org-mode table, I want to write 2^3, but exporting to html turns it into 23. I prefer not to use inline verbatim, and I would like to not have a space between the ^ and the other text. Is ...
1
vote
0answers
115 views

How to Change the font for org-date face in org-table context?

I like to have a variable font everywhere I can, but some things like tables in org-mode or the org-agenda itself look a little wonky that way, and I get around it by configuring specific fixed width ...
3
votes
1answer
119 views

Sort Chinese Characters in Emacs

Is there a ready-made function that sorts Chinese characters (by pinyin or stroke number) in Emacs in an org-table or line by line in regular text? If not, how should one go about writing such ...
1
vote
1answer
78 views

Org Mode - Use remote table reference in constants

In https://orgmode.org/manual/References.html remote references are mentioned. Also there are constants for a local environment of a table. I would like to retrieve the value for a constant from the ...
2
votes
1answer
218 views

How remove active date from a dynamic block using columnview

This post explains how you can setup dynamic blocks to create tables based on meeting minutes. In short, you can extract the TODOs of the minutes and put them in a table of actions like so: * ...
0
votes
0answers
23 views

Calculating weighted average in orgmode table [duplicate]

In the following table | Item | Weight | Grade | |--------+--------+-------| | Quizes | .15 | 3 | | Exam 1 | .3 | 5 | | Exam 2 | .5 | 4 | |--------+--------+-------| | Total ...
0
votes
0answers
36 views

How to insert quotations in Org tables?

In org mode, how does one insert a quotation in a table cell? I know that #+BEGIN_QUOTE ... #+END_QUOTE is the way to go outside a table, but I can't find a way to use it inside a table cell.
1
vote
1answer
39 views

Org-mode tables exported as latex arrays within eqnarray environment, how?

If I have constructed a blocked array using an org-mode table, I can easily export the table as, e.g., a pmatrix array as presented below. However, the pmatrix is exported within a math environment (\[...
2
votes
0answers
49 views

org-table: hide grid lines

I like how org-mode allows me to quickly create and edit tables. However, I do not like the table's appearance and I would like to modify it. Customizing the face only lets me change foreground and ...
1
vote
1answer
188 views

Org mode table export latex with title (upper) and notes (lower)

I would like to create the following LaTeX type table by using the standard org-mode functions. The LaTeX code is the following: \begin{table}[!h] \centering \caption{Results} \label{tab} \begin{...
1
vote
1answer
35 views

Perform calculations in orgtbl with the LaTeX syntax?

This is an orgtbl table #+begin_src emacs-lisp :results none (setq calc-language 'latex) (calc-radians-mode) #+end_src #+attr_latex: :mode math |----------+-----+----------| | Fonction | var | ...
0
votes
1answer
66 views

Org table date arithmetic with Lisp expressions

It's easy to do date arithmetic using org-mode table formulas. For example, if I enter this table: | [2020-01-01] | | | [2020-02-01] | | | [2020-03-01] | | #+TBLFM: $2=$1+1 ...and then do C-c C-c ...
1
vote
2answers
88 views

Cumulative Column in Org Table

I would like to create a table with Coronavirus case counts for the state of Utah in the United States. I have a table with two columns: a date column and a column of total new cases for that day in ...
2
votes
1answer
70 views

Hide org-table rows outside certain date ranges?

Excel tables lets us show just the rows that have "July 2018" in a specific column, and hide the rest. Or to show "21st August 2017-30th August 2017, and also July 2018, and also all of 2019", and ...
0
votes
0answers
26 views

Custom org-refile of a table entry similar to Capture

My question concerns the refiling of table entry. I keep my cheatsheets for different kind of things in a table format. Let's suppose, that each heading has exactly one table. * My table 1 ...
1
vote
1answer
24 views

Set org-table tab-key behavior to insert row when above a footer/hline

I've been experimenting with/learning org-mode's table features and spreadsheet-like formulae. If I include a totals-type footer row in a table and precede it with a border (hline), then I can simply ...
0
votes
0answers
143 views

Time-formatted output from org-table date- and time calculation?

I have an org-table for my timesheets. Part of it looks this: | Start | End | End - Start | | <2020-03-05 10:00> | <2020-03-05 Thu 14:30> | 0.1875 | #+...
1
vote
0answers
49 views

using org table as yasnippet input

I'm using yasnippets to create code blocks in org mode to document and execute DevOps activities. To improve productivity, it would be nice to have a possibility to create org tables with rows of ...
1
vote
2answers
255 views

calculate the sum of the muplication of 2 columns in org table

I have a org table: | a | b | c | |---+---+---| | 1 | 2 | i | | 3 | 4 | j | |---+---+---| | 4 | 6 | | I want to multiply columns a and b and sum them up (except last row: 1*2+3*4) and put into the ...
0
votes
4answers
125 views

Nesting conditionals, consolidating functionality in elisp

Working in an org-mode file, I have this table #+tblname: site-charac-matrix | | glaze | orn | color | thin | |---+-------+-----+-------+------| | A | 0 | 1 | 0 | 0 | | B | 1 | 0 ...
1
vote
1answer
335 views

Org mode table- make entire column to contain checkbox

I have a table like this using Org mode (by typing |-- and then tab to complete |-- Item-- |--Notes---| | blah blah|blah blah | Now I would like to add another column just before Item and contains ...
2
votes
2answers
113 views

Org Reveal : Tabular fragments

I'm using org-reveal to make a presentation. I want to have elements in tabular form appear sequentially but in column-major order. I know you can put :frag property-markers for gradual appearance....
1
vote
1answer
43 views

Org-mode table recalculation with a remote() formula using calc?

Can I make table2 automatically recalculate a remote() formula when I modify data in table1? I have the below tables and the first table is automatically recalculated when I press TAB (thanks to the "...
0
votes
1answer
124 views

Exact steps to export to an org table to csv

Sorry if this is trivial. What are the exact step to export the following table: 1) to a buffer 2) to the file specified in properties For now if I position the cursor inside the M-x org-table-...
1
vote
0answers
26 views

Dealing with a table with too many row in org-mode

When a table gets too long, how can you deal with it? Is there any way of collapsing parts of it? Or maybe dividing it in multiple tables and still perform operations (like adding a column) on all of ...
0
votes
1answer
26 views

Applying formatting from within tables

It seems that ^c ^c applies table formatting only when point is on the formatting line (the one beginning in #+tblfm:). Is it possible to have ^c ^c apply formatting even when point is in the table ...
1
vote
1answer
76 views

Reference cells of other tables in org-mode table as plain text

I intent to copy the value of a cell and put the exact copy to the target cell and be able to update the value on referenced cell to be updated on the targeted one. Calling remote to a cell evaluate ...

1
2 3 4 5 6