for questions about Org mode's ASCII table editor. Use this tag for its spreadsheet calculations and plotting features as well.
0
votes
0answers
23 views
Import CSV into org-mode table, but preserve quotes around strings
I really like the ability to quickly go between CSV tables like this:
a, b, c
this, TRUE, 5,
that, FALSE, 8
...and org mode tables, that look like this:
| a | b | c |
| this | TRUE | 5 |
| ...
0
votes
1answer
25 views
Capturing data on .org document to table
I have a simple template in emacs .org mode .
\begin{flushright}
Name :
Phone no:
Billed amount:
Date
\end {flushright}
• Details .........
I export the document to pdf and print it. I ...
1
vote
1answer
73 views
Org table spreadsheet use column name on left hand side
I have the following table and formulas:
| | Runde | 0 | 1 | 2 | Resultat | % |
|---+-------+---+---+---+----------+------------|
| ! | name | | | | result | percentage |
| # | ...
0
votes
0answers
7 views
Save .org file from org table edit field buffer
Is there any command to save the org file from the org table edit field buffer? If not, is there any way to check if the current buffer is an org table edit field buffer?
4
votes
2answers
77 views
Can I have a single #+TBLFM for multiple org tables?
I have multiple tables like below in an org file, but all having identical #+TBLFM lines. Is it possible to have just one #+TBLFM and have all these tables use it?
#+NAME: IOC
| Rate | Units | ...
1
vote
0answers
49 views
latex inside table using table.el in org mode
I am trying to achieve multicolumn cells in org-mode tables like in Multicolumn cells in org-mode tables, but with Latex inside the cells.
* Minimal Example
+------------+-----------+-------------...
0
votes
2answers
78 views
Org-mode: How to fix table width to page width for dynamically generated tables?
I am using dynamically generated table to create a tabulated to do list with various parameters using:
#+COLUMNS: %ITEM %SCHEDULED %DEADLINE
for more info see: Org-Agenda export to dynamic Org-Table
...
2
votes
2answers
87 views
Number-separators in org-mode tables
I often paste org-mode tables numbers that are e.g. space-separated. Then I have to delete spaces before things like =$2/2 work correctly. Is there a way to change "number format", e.g. plug in a ...
2
votes
0answers
24 views
Re-apply table formulas on org-mode export
I'm using an org-mode file to do some filesystem monitoring. To that purpose I have a table in which I'm calling code blocks through org-sbe in the formulas. It looks like this:
#+NAME: part-size
#+...
0
votes
1answer
49 views
Deleting duplicates in an org-table column
I wanted to preserve the first row value while deleting all subsequent repeated values in the sequence column ($5) as in the MWE below:
| ID | M | D | P | sequence | item |
|----+---+---+--...
3
votes
0answers
26 views
Link to column entry from org-mode text
I would like to reference a specific table entry, or have it's value insert inline in an Org document. My motivation is to avoid having to change the text in case I recompute values. Dummy example:
#+...
0
votes
0answers
55 views
Org-table color entries that match a predicate
Say we have the following table:
| Student | Grade |
|---------+-------|
| Foo | 7 |
| Bar | 5.5 |
| Baz | 9 |
Is there a way to change the face color of an entry when a ...
2
votes
1answer
41 views
How do I carry over an entire column from one table to another?
I'm trying to set up a monthly budget in org mode, and carry over the balance for each category from month to month. So I'll have something like
|Category|Last |Budget|Actual|Balance|
| |Month|...
2
votes
2answers
130 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) (...
0
votes
0answers
26 views
How to do org-mode cross table formulas? [duplicate]
If I have 2 separate tables in an org-mode doc is there a way to reference fields between them?
* Table 1
|----------+------+------------+---------|
| 12/20/17 | Thing | coolidge | 158.46 |
|------...
3
votes
0answers
37 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
35 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) |
|---------+---------+---------+---------+---------+---------+--------+----------...
0
votes
0answers
43 views
How to orgtbl send radio table to receiver in another file
I have an org-mode file with a number of interrelated tables inside. A few of these tables need to be exported to LaTeX files for final formatting. The orgtbl-mode radio tables work very for tables ...
0
votes
2answers
151 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 ...
3
votes
1answer
94 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: $...
0
votes
0answers
25 views
orgtbl-to-latex force some variable in math-mode
in a LaTeX document, orgtbl-to-latex exports \pi or \infty as \(\infty\) and \(\pi\).
That is an error because the environment is already in math mode.
example
\begin{displaymath}
\begin{array}{...
5
votes
1answer
760 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
40 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
68 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.
...
0
votes
0answers
84 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
541 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
129 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
64 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 ...
2
votes
1answer
95 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....
2
votes
2answers
595 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:
+------+------------...
2
votes
0answers
142 views
Exporting Org in Landsacpe
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
424 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
70 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
23 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
30 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 |
|-----...
8
votes
1answer
731 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
114 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|
|.... ...
0
votes
0answers
16 views
org-table how to run org-table-iterate automatically in/after org-table-edit-formulas
I run org-table-edit-formulas and make a change.
When I exit I want to automatically run org-table-iterate on the table that was modified. Is this possible?
I would also like to know how to call org-...
1
vote
1answer
36 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
158 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
43 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
88 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
195 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
126 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 ...
1
vote
2answers
133 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
125 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
25 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:
| . | . | . | . | . |
| . | . | . | ...
5
votes
2answers
337 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
217 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 ...
0
votes
1answer
110 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 ...
