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.
284
questions
6
votes
2answers
1k views
Multi-line org mode formula definitions
Org tables are great! But sometimes, for non-trivial cases, the formulas get a little unwieldy. E.g.:
#+TBLFM: @III+1$3..@IIII-1$>='(let ((l (-non-nil (mapcar* (lambda (w v) (when (equal w $2) (...
3
votes
1answer
78 views
org table lisp concat semi-colon issue
I am not sure how to describe this problem so I am giving some example
Without Semi-colon
| John | Snow | John Snow |
| John | Doe | John Doe |
| Mery | Jane | Mery Jane |
#+TBLFM: $3='(concat $1 "...
1
vote
1answer
66 views
Is there a simple way to "drop" scores from a mean function in org-mode?
I have an org table:
| Student | Score 1 | Score 2 | Score 3 | Score 4 | Score 5 | Mean | Mean (Lowest Two Dropped) |
|---------+---------+---------+---------+---------+---------+--------+----------...
1
vote
2answers
727 views
org mode table formatting problem
I'm on Windows 7 using emacs version GNU Emacs 24.5.1 (i686-pc-mingw32) of 2015-04-11 on LEG570.
When I create tables with org-mode, I end up having something like this.
.
I searched and found ...
6
votes
1answer
697 views
Org-Mode: Using Source Code Blocks in Table Formulas
I would like to use source code blocks in org-mode table formulas using something similar to:
#+NAME: square
#+BEGIN_SRC python :var x=0
return x**2
#+END_SRC
| 1 | 1 |
| 2 | 4 |
| 3 | 9 |
#+TBLFM: $...
25
votes
3answers
15k views
Wrap cell content in an org mode table
I have a table like this:
| Verse No | Verse |
| | <10> |
| 1 | line1 li=> |
| 2 | line2 li=> |
I would like to view it as
| Verse No | Verse |
| ...
1
vote
1answer
154 views
evaluation of calc formulas in orgtbl?
in calc mode, 'subst (2 * x, x, 5)' is evaluated to 10, but in an orgtbl table the formula is evaluated incompletely to '2 5'.
How to force evaluation into orgtbl-mode?
Here is my example:
|-----+----...
0
votes
1answer
189 views
Get Org Link Description From Table Column of Links
I have an org table and I want to take an existing column of org links of the form:
[[http://blah.com/blah/blah/foo][foo]]
And create an adjacent column containing only the description - i.e. foo.
...
2
votes
0answers
512 views
Plotting a chart from org table
org mode is very good in plotting table. But is there any way of creating line plot from the table directly in org mode?
3
votes
2answers
2k views
`org-mode` doesn't align column bars properly
When I make tables in org-mode, if the column value in the next row is longer, after pressing TAB, the new vertical alignment of "|" gets a bit distorted. This used to work fine before, it also works ...
0
votes
1answer
258 views
org-mode table editor behaves strangely
With cursor in row 2, col 3
| a | b | c |
| 1 | 2 | 3 _|
Pressing <TAB> creates a new row:
| a | b | c |
| 1 | 2 | 3 |
| | | |
Type more than one character and press tab. Vertical ...
3
votes
0answers
332 views
Managing large volume tabular data
I have an index of digital media (books, movies, etc.) containing name, author, year, pages, etc. which I maintain in an Org file as a table.
I preferred Org mode because I had a lot of stuff in my ...
4
votes
1answer
2k views
Preventing Org-Mode PDF Tables from Running Off the Page
Consider the following long org-mode table.
#+TBLNAME: Bitcoin
#+PLOT: title:"Bitcoin Return in 1,2, and 10 Years" ind:1 deps:(3 5 7) type:2d with:histograms set:"yrange [0:]" set:"style fill solid 1....
11
votes
2answers
3k views
Org mode: Using todo-items or checkboxes in tables
I have several items that I need to perform the same tasks on. To get an overview, I wanted to use a table, where the columns would show me how many are done, something like this:
+------+------------...
3
votes
1answer
2k views
Exporting Org in Landscape
I have an org document I'd like to export to PDF - with several wide tables columns in it - so much so that it makes sense to export the whole document in A4 landscape to keep the orientation ...
2
votes
2answers
2k views
Quick calculation in org-mode table
I used to think that you can just type =13*57 into an org-mode table's cell, hit Tab or Ret, and have it enter the result for you. Today, I learned that this isn't true the hard way as I used this a ...
2
votes
1answer
190 views
Org-mode Table, No export Latex column
Is there a way to have a column of a table not export, specifically in latex? I want to have an extra column for personal notes but when I export I don't want the table there.
1
vote
0answers
30 views
Disabling the special meaning of either `+` and/or `|`
I came across a case where strike-through and table interfere with the proper operation of org-links (which, in my case are org-ref citations). Here is a minimal example:
+-+
|cite:VemulaMO2016c-Path-...
1
vote
1answer
93 views
Get unique names from table colum
I have one table (TBL1), I want to generate another table with unique items from TBL1.
Currently, I can do it with elisp as below but I think it's too complicate.
#+NAME: TBL1
| Item | Amount |
|-----...
13
votes
1answer
6k views
What is the difference between sh and shell for org-babel?
I'm experimenting with sourcing data from org-mode into my shell scripts and I've run across a weirdness:
#+tblname: simple-table
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
#+name: work-with-simple-list-shell
#+...
0
votes
0answers
215 views
Org-table and multiple plots
Is it possible to have several plots related to one Org table? I have noticed that
#+plot: ... file:"file1.png"
#+plot: ... file:"file2.png"
#+plot: ... file:"file3.png"
.
.
.
|col1|...|colN|
|.... ...
1
vote
1answer
82 views
Elisp how to tell if my cursor is inside an org-table?
I have some code that activates hydras based on modes.
I can do the following for org-mode:
(when (eq major-mode 'org-mode)
(hydra-org-nav/body))
I would like to see if I'm in an org-table and ...
2
votes
1answer
301 views
display lines from org-table on org-agenda
I'm wondering if it is possible to display lines from an org table on my agenda.
Suppose I have an org file with the following content:
* expense
| <2017-08-17 15:11> | 13.00 | barber | :care:...
2
votes
1answer
106 views
Why did cell in org table turn into elisp statement and column TBLFM?
I've been using org-mode everyday at work for 3 years and recommend that everyone to do the same.
But today, I unintentionally triggered a column function which replaced the cell value with an elisp ...
1
vote
1answer
181 views
Using org-lookup-last to look up values in a table
I have two tables. One table has a column ($2) of unsigned integers (#+NAME: ATTRIBUTES). One table is a lookup table (#+NAME: ATTR-LOOKUP) which takes each value from Column $2 in ATTRIBUTES, and ...
0
votes
2answers
541 views
Org-mode cross references disrupted by ATTR_LATEX?
I have a couple of tables in the following runnable, complete, self-contained example, and I can successfully "forward-reference" them by name in the text:
Table [[tab:line-word-byte-count]] tells us ...
2
votes
2answers
736 views
org-babel problem printing separator rows to org-mode table
I found here in the org manual how to output from an org-babel source-code block to an org-mode table, namely through something like
#+header :results output table
I have had some trouble getting org-...
2
votes
2answers
316 views
How to feed range from org-table filled with strings to code-block via tblfm?
Following Situation:
I would like to calculate some fields from an org-table filled with strings.
There are many tables which all could share the same lisp-code.
The lisp-code is rather complex and ...
0
votes
2answers
456 views
how to get reference to other tables working with field references?
I'd like to create a summary table for tables of months (months are just one possible use of the summary table).
The months have some informations and a count column.
The summary count of every month ...
1
vote
1answer
58 views
Running elisp conversion function in an Org table returns an error
For a table I would like to convert the first column from decimal numbers to binary.
The table looks so far like this:
| . | . | . | . | . |
| . | . | . | ...
4
votes
2answers
956 views
org mode - add formula to generate delta column
How can I get below result with org table formula? The number of rows maybe too many, so doing it line by line is not good way.
For example:
@1$2 = @1$1 - @1$1
@2$2 = @2$1 - @1$1
@3$2 = @3$1 - @2$1
...
2
votes
1answer
688 views
Function to paste text as a orgmode table
I'm wondering if anyone knows of a way to have a function (that I can bind to a key) that pastes the current text in the clipboard as a formatted org table?
Also as a bonus (since this is used to ...
2
votes
1answer
854 views
Insert column in org-mode moves the content
I am trying to insert a column in a table in org-mode and I get the content moved.
For example, I have this table:
| Name | Age |
|--------+-----|
| Tarzan | 40 |
| Jane | 39 |
Now I want to ...
11
votes
1answer
3k views
Org tables: Wrap all fields in column to a given size
In org it is possible to set a column width like follows:
|---+------------------------------| |---+----------------|
| | | | | <14>...
1
vote
1answer
320 views
Exporting a single column of an org-table
I want to export (not sure if that's the right word) a single column of an org-table as text, with the elements separated by commas. Eg if the table is
| x | y |
|----+----|
| 0 | 1 |
| 2 | 3 |
...
2
votes
0answers
992 views
The org-mode table alignment issue in right-to-left languages
I really enjoy writing bidirectional text in org-mode using Emacs as it supports the rt-to-left direction out of the box. However, when it comes to org tables alignment things become very unorganized.
...
6
votes
1answer
2k views
Add cell background colors to org-mode table in pdf export
I'd like to be able to select a specific cell in an org-mode table and add a background color to that cell for a pdf export. Such that
| This Cell is formatted normally | This cell is greyed a bit|
|...
1
vote
0answers
479 views
How to fold a cell of table in org mode?
In an org-mode table, I have a cell with a long line of text. How do I fold that line/cell so that its column won't be too wide on the screen?
4
votes
1answer
1k views
How to return an org mode table with headings and hline from Ruby
I have the same question as this question except that I don't see how to do so other than in elisp. I am using Ruby, but I suppose the question applies to other languages as well. If I return an ...
0
votes
1answer
281 views
Is there any way to use just year and month as timestamp in org-mode?
Specifically, I'd like to sort a column in a table in org-mode. However, the column only has year and month information, like 2016-02 or May 2016. It can't sort for now as it's not recognised as ...
4
votes
1answer
163 views
How to <return> in a org table?
Instead of
| | some value |
|-- +--------------------|
| a | aaaaaaaa |
|---+--------------------|
| b | bbbbbbb bbbbbbbbb |
|---+--------------------|
I want
| | some ...
2
votes
1answer
291 views
Automatically turn on hl-line-mode inside org-mode tables
Based on this answer my question is whether there is a (simple) way to automatically turn on hl-line-mode whenever the cursor is within an org-mode table in an org-mode file.
I tried to find a hook ...
2
votes
0answers
183 views
Links inside org-mode tables are not typeset in monospaced font
While the default is a proportional font, I told org-mode to use a monospaced font in tables:
(add-hook 'org-mode-hook (lambda () (variable-pitch-mode t)))
(with-eval-after-load 'org
(set-face-...
5
votes
2answers
6k views
How to have the sum of a column (with computed data) in the first row?
In org-mode is it possible to generate a table, where there is a column which contains a value computed from values in the other columns and which contains the sum of these values?
More specifically, ...
7
votes
3answers
4k views
How to select (and copy) a column of an org table *without* rectangle selection?
It seems to me that the normal way to copy a column of an org table is by rectangle selection (see here). That is, first the column is selected by marking all of it by hand, and then it is copied with ...
2
votes
1answer
189 views
Why is org-table-calc-current-TBLFM throwing Wrong type argument: integer-or-marker-p Error?
Why does my code generate the error when used with org-table?
No error message when code used outside of org-table
#+NAME: get-country-or-area-name
#+HEADER: :var iso-alpha2-code="ca"
#+HEADER: :...
2
votes
2answers
325 views
Changing HTML Table Formatting When Exporting from R
I am generating several tables in R and then exporting them to HTML(5). For instance:
#+BEGIN_SRC R :session *R-org* :results output raw :exports results
df <- data.frame(x=0.110, y=0.132)
...
1
vote
1answer
196 views
org-mode table layout
hi i'm new to emacs and i'm really amazed about the org-mode. But i have some problems with the tables.
i want a nice looking table but i get always a strange format
example:
But i want it like ...
4
votes
1answer
1k views
How to convert org-table to list?
I've this table:
|H1 |H2 |H3 |
|------+------+------|
|text11|text12|text13|
|text21|text22|text23|
|... |... |... |
|textN1|textN2|textN3|
|--------------------|
and i want this list:...
3
votes
2answers
469 views
Org-mode: export table columns in verbatim mode
In an org-file, I have a table where I want one column to be exported verbatim:
| Date | Rating | Comment |
|------------+--------+------------|
| 2016-07-01 | *** | so so |
| 2016-...
