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.
269
questions
0
votes
2answers
34 views
Using elisp code with table formula problem
I've got these working
#+NAME: expogrowth1
| 1 | 2 |
| 2 | 4 |
| 3 | 8 |
| 4 | 16 |
| 5 | 32 |
| 6 | 64 |
| 7 | 128 |
| 8 | 256 |
#+TBLFM: @2$2..@$2> = @-1$2*2
and
#+NAME: expogrowth2
| 1 ...
0
votes
1answer
16 views
Populate table row with rate changes with one formula
I've got this Exhibit A in brute force for a rate that is halved after 10 minutes
#+NAME: ratetable
| 0 min | 10 min | 20 min | 30 min | 40 min | 50 min |
| 20.0 | 10. | 5. | 2.5 | 1.25 | ...
1
vote
1answer
18 views
Use variable in reference with remote in Org-table
I have one table called GRADING containing names and points entered by hand, and another table (FOO) containing the grading scheme. Is there a simple formula which allows to lookup the number of ...
2
votes
1answer
66 views
How to delete a single column cell in an org-mode table?
In Excel etc it is possible to delete a cell in a column and have the cells below it "shift up" without affecting the content of the other columns. I haven't found a command for this in org-...
0
votes
1answer
20 views
Export all org-tables from batch mode
How can I export all the tables in org-mode file similar to that.
* May
:PROPERTIES:
:TABLE_EXPORT_FILE: ~/Desktop/may.csv
:TABLE_EXPORT_FORMAT: orgtbl-to-csv
:END:
|One|Two|
|---+---|
* June
:...
0
votes
0answers
14 views
How to export tables in a xltabular environment to TEX/PDF without xltabular being nested in a “table” environment?
My goal is to have a table,
which can be customized with tabularX (width == textwidth),
can break over multiple pages
and is able to have zebra stripes (xcolor).
I tried many packages, even the (...
0
votes
0answers
36 views
org-mode table as function
I have the following question regarding org-mode tables:
I have the following simplified org-mode table with:
A,B as arguments or parameters
and C1, C2 results or return values.
#TBLNAME: function
| ...
0
votes
1answer
86 views
How to calculate time durations in tables?
How to calculate time durations in tables?
Subtraction of numerical vectors works directly:
| day | t1 | t2 | differences |
|------------------+----------+----------+----------...
1
vote
3answers
150 views
How do I copy the content of a cell in org-mode table?
Is there a command to copy the content of a cell in a single keystroke?
When I have cursor at [x] (see below), I have to do: M-a (goes to the beginning of the cell), C-<SPC>, M-e (goes to the ...
0
votes
1answer
21 views
Table-capture doesn't handle new line
I'm trying to table-capture this in an org file
2 3 5 7 11 13 17 19 23 29
31 37 41 43 47 53 59 61 67 71
73 79 83 89 97 101 103 107 109 113
127 131 137 139 149 151 157 163 167 173
179 181 191 193 197 ...
0
votes
0answers
37 views
Move a row of a table.el table
I have this org-mode table, which apparently is a table.el table:
+-----+------+
| Test|Foobar|
+-----+------+
| | |
+-----+------+
When I hit Tab in any cell, emacs tells me: Use ‘C-c '’ to ...
1
vote
1answer
58 views
Generate a new table out of old one with sorting
Here is a table where scores are calculated at last row with a formula. How to generate a new table TotalResults with 1 and last columns? Can we even sort the last column in the process?
#+TBLNAME: ...
0
votes
0answers
24 views
How to Implement Column Wrap in org-mode Tables Programmatically
Note: This question is not well suited for standard emacs StackExchange format but I believe the discourse and exchange of techniques would be valuable for the community because the wrapping cells ...
0
votes
0answers
21 views
formatting a org-table formula result
I would like to calculate the time in this table:
| Start | End | Sum | Second Sum |
|-----------------------+-----------------------+-----------+------------|
|...
3
votes
1answer
51 views
Is there a command (and ideally a key binding) to navigate to the top (or bottom) of an org table?
I have read Built-in Table Editor, and searched apropos-function org table for top, bottom, beginning, and end. I found org-table-beginning-of-field, but not anything like org-table-beginning-of-table....
0
votes
1answer
26 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
55 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
33 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
16 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
41 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
88 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
24 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
26 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
194 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
88 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
101 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
108 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
22 views
org table apply formula from specific row onwards
| BookmarkLevel | BookmarkPageNumber | ActualPageNumber |
|---------------+--------------------+------------------|
| 1 | 11 | |
| 2 | ...
0
votes
1answer
25 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
91 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
15 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
38 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
56 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
49 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
367 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 |
...
1
vote
1answer
364 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
314 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
59 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 ...
2
votes
0answers
207 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
132 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
110 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
227 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
31 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
37 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
52 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
55 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
327 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
39 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
81 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 ...
