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.
255
questions
1
vote
1answer
46 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
879 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
575 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
604 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 ...
9
votes
1answer
2k 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
300 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 |
...
1
vote
0answers
805 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
412 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
877 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
253 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
142 views
How to <return> in a org table?
Instead of
| | some value |
|-- +--------------------|
| a | aaaaaaaa |
|---+--------------------|
| b | bbbbbbb bbbbbbbbb |
|---+--------------------|
I want
| | some ...
2
votes
1answer
262 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
159 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-...
4
votes
2answers
5k 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
3k 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
166 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
318 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
180 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
940 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
409 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-...
0
votes
1answer
310 views
Tab in org-mode table generates “Variable binding depth exceeds max-specpdl-size.”
Pressing TAB in an org-mode table (existing, or trying to create a new one) results in an error:
"Variable binding depth exceeds max-specpdl-size."
Debug provides the following:
Debugger entered--...
3
votes
1answer
1k views
How to export org tables with cells on multiple lines?
In my org file i have the following table:
#+CAPTION: ŠŠ°Š³Š¾Š»Š¾Š²Š¾Šŗ ŠæŠ°ŠŗŠµŃŠ°
| ā | Š Š°Š·Š¼ŠµŃ | Тип | ŠŠ½Š°Ńение |
| | (байŃ) | | |
|---+--------+----------+----...
4
votes
1answer
950 views
Org-table running total column formula
Is it possible to write an org table colmun formula which calculates the running total of some other column? Here is a simple example of the idea: The table
| 1 | |
| 2 | |
| 5 | |
| 10 | |...
2
votes
0answers
260 views
Add org-mode clocktable column that is the product of a constant and the Time column
Here's a snippet from an optimistic org-mode file
#+CONSTANTS: rate=100000.0
#+BEGIN: clocktable :maxlevel 2 :scope file :narrow 60! :header "#+NAME: billed #+attr_latex: :align l|r|r|r|r :...
4
votes
3answers
1k views
Conditionally calculate the sum of a column depending on a fields value in another cell of the same row
In orgmode, I do have a table like the following to track my overall working time a day. It is not important for which tasks or projects or even which client I spent my time on, just if I was in ...
2
votes
2answers
326 views
TBLFM insert new row with current time
I want to insert a new row at line 2 in a table (preferably using TBLFM), and I want it to be prefilled with the current date (col 1) and time (col 2).
How do I insert a new row (something like #+...
3
votes
1answer
995 views
Org Mode - Reference Remote Table From a Different File
I'm trying to figure out how to reference a cell from a table that is located in a different file. I know I can use remote(tablename, @1$1) to reference a remote table within the same file. Is there a ...
1
vote
0answers
930 views
TAB key is not working in my Org-mode table
I'm customizing my emacs using literate programming within org-mode. So far, It is going Ok, except that the org table align is not working properly if I press the <TAB> key... even worst, the ...
2
votes
2answers
366 views
Long tables in emacs org do not export correctly through latex-pdf
I want to export two long tables (each 6X179). I tried to export with latex-->PDF using #+ATTR_LATEX: :float sidewaystable attribute. But what I get is this result, I get just three pages pdf file (...
2
votes
2answers
971 views
Copying and pasting org tables misaligned?
I have a table in Org mode that looks as shown below
| S.No. | Template | V800A | V800B |
|-------+----------------+-------+-------|
| 1. | IFD03B | 17 | 8 |
| 2. | Calcs ...
3
votes
1answer
213 views
How to delete org-mode table separator | quickly?
If I have the following text:
Name Score
Bob 87
Ted 99
Mary 78
I know C-c | will covert it to org table. But how can I do the other way around?
If I have a org table already, how can I ...
5
votes
1answer
715 views
org mode table formatting issue
Using a simple keyboard macro, I copied the Font Awesome Cheat Sheet into an org table. However, I experience some weird inconsistencies when it comes to the formatting - see the picture below:
Any ...
12
votes
1answer
2k views
Org-table: is it possible to have automatic line wrapping inside org-tables?
Org-table has a very convenient property, it expands the width of a table column if needed to show all your text in a cell. Alternatively, you can set a fixed width for a table column and let your ...
5
votes
2answers
300 views
Auto-update org tables before each export
I am looking for a solution (a function) that evaluates all the tables in the org file/buffer. I should be then simply able to add that to the local value of before-save-hook in org-mode.
Currently, ...
3
votes
1answer
839 views
Is there a python tool for parsing org-mode tables?
I often use python scripts to parse information stored in many of my org tables. To get python to read these tables I have a script that exports specific tables from a specified org document to csv. I ...
1
vote
2answers
182 views
orgtbl-aggregate: how to handle periods (.) in column header names
I'm new to org mode and have been using Orgtbl Aggregate for tables. I import space-separated files as org tables, add an hline to make the first row into a header, name them with #+NAME (aside: is ...
2
votes
2answers
300 views
Concatenate ascii/org tables with some different headings
I want to concatenate two ascii tables (one below the other) that share some but not all column headings.
e.g.
Table 1
Head1 HeadA
1 a
2 b
Table 2
HeadA HeadFoo
c bar
And the result ...
2
votes
0answers
26 views
Is there a way to treat an inline picture (a link rendered as an image) as one character in org table?
Is there a way to treat an inline picture (a link rendered as an image) as one character in org table?
When I align an org table that has a small image in a field, the alignment gets really messy, ...
2
votes
1answer
85 views
Expand an org-table with clipped fields?
I learned that I can edit the whole clipped field in a new window with org-table-edit-field, but it's kind of annoying to open a new window each time I want to edit each field. How can I edit those ...
11
votes
2answers
193 views
Avoid displaying “=>” when a field is clipped in org-table?
How can I avoid displaying "=>" when a field is clipped in org-table? Those arrows dominate some narrow cells, and I can view the full field in a tool-tip window anyway, so I'd like to get rid of them....
4
votes
1answer
37 views
Change the behavior of a function when the point is in a table
How can I change the behavior of a function when the point is in an org-table? Is there a function like "table-p" that returns true when the point is in a table (like region-active-p returns true when ...
9
votes
2answers
1k views
Generating tables with headers from code block
I would like to generate tables that have headers from code blocks. Something like this:
#+BEGIN_SRC emacs-lisp :results value table :table-header | First | Second |
(identity '((a b) (c d)))
#+...
6
votes
1answer
964 views
How to make the org-mode exported table aligned in GMail?
I have a table maintained by org-mode, and I would like to copy/paste it to an email.
So this is what I was trying to do:
export to the plain text
copy/paste to the gmail
However, it just cannot ...
4
votes
2answers
3k views
How do I do simple addition in org mode?
I have heard that you can do math in org-mode through tables, but looking it up comes up with things about LaTeX and other confusing subjects.
This is what I want to do:
| | 1 | 2 | ...
11
votes
2answers
2k views
How can I filter table in org mode
For example, I want to filter table that make it shows the row which only contains "USA" string in the column 3 and 4.
0
votes
1answer
126 views
orgtbl-to-html within HTML document
I'm learning emacs now and I've run into a problem.
I would like to use orgtbl minor-mode within an HTML file and be able to update the contents of the org table as HTML code directly.
I saw an ...
2
votes
0answers
129 views
External http link not recognized as link
I have the following document:
* Test
| Links |
|-------|
| [[http://emacs.stackexchange.com/questions/ask]] |
This Link is not recognized as a Link. If I press TAB while the cursor is on the link ...
12
votes
2answers
947 views
Align columns in Org mode table with Japanese fonts
How can I mix Japanese and English in the same org-mode table (that uses fixed-width fonts)? Something like:
| m m m m m m | |
| ćÆć©ć ćć·ć¦ | |
| ļ¾ļ½°ļ¾ | ļ¾ļ½°ļ¾ |
won't align. ...
1
vote
1answer
225 views
yasnippet won't replace default values (placeholders) in org-table caption
I'm using yasnippet to create a template for org-mode tables. This works fine, and allows me to create default values (placeholders) for the column headers. The default values are highlighted by ...