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
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 ...