From mboxrd@z Thu Jan 1 00:00:00 1970 From: Amos Bird Subject: Re: Disable fontification when exporting tables Date: Sat, 30 Sep 2017 09:13:36 +0800 Message-ID: <87a81drnsv.fsf@gmail.com> References: <8737785ytb.fsf@gmail.com> <874lrmodvo.fsf@nicolasgoaziou.fr> <87bmlus1ci.fsf@gmail.com> <878tgxmh1q.fsf@nicolasgoaziou.fr> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=-=-=" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:41339) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1dy6Lh-0003xu-Tn for emacs-orgmode@gnu.org; Fri, 29 Sep 2017 21:13:48 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1dy6Le-0002cy-Su for emacs-orgmode@gnu.org; Fri, 29 Sep 2017 21:13:45 -0400 Received: from mail-pg0-x22c.google.com ([2607:f8b0:400e:c05::22c]:56496) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1dy6Le-0002cs-JR for emacs-orgmode@gnu.org; Fri, 29 Sep 2017 21:13:42 -0400 Received: by mail-pg0-x22c.google.com with SMTP id 7so610232pgd.13 for ; Fri, 29 Sep 2017 18:13:42 -0700 (PDT) In-reply-to: <878tgxmh1q.fsf@nicolasgoaziou.fr> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: "Emacs-orgmode" To: Nicolas Goaziou Cc: "emacs-orgmode@gnu.org" --=-=-= Content-Type: text/plain #+OPTIONS: latex:t toc:nil H:3 Hi, > - what are you trying to export? an Org table like this: #+BEGIN_EXAMPLE | QueryID | SQL Text | Query Time (Seconds) | Query Time Hot (Seconds) | |---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+--------------------------| | Q0 | SELECT cab_type, count(*) FROM trips_log GROUP BY cab_type; | 10.14 | 11.57 | | Q1 | SELECT passenger_count, avg(total_amount) FROM trips_log GROUP BY passenger_count; | 12.00 | 6.27 | | Q2 | SELECT passenger_count, toYear(pickup_datetime) AS year, count(*) FROM trips_log GROUP BY passenger_count, year; | 10.45 | 7.23 | | Q3 | SELECT passenger_count, toYear(pickup_datetime) AS year, round(trip_distance) AS distance, count(*) FROM trips_log GROUP BY passenger_count, year, distance ORDER BY year, count(*) DESC; | 13.03 | 10.80 | #+END_EXAMPLE > - to what back-end? ODT and HTML > - what is the exact problem? I'd like to export this table with *:nil ^:nil options while exporting other subtrees with *:t ^:t. I tried surrounding the table with example block and src block but both look bad after exportation. I added <10> to the SQL column but it doesn't help quoting the * and _ characters when exporting. #+BEGIN_EXAMPLE I also tried changing _ to \under{} and * to \asc{} but it doesn't look well in the Org buffer. I did turn on org-toggle-pretty-entities but it changes the appearance of other subtrees which I don't want to. #+END_EXAMPLE regards, Nicolas Goaziou writes: > Hello, > > Amos Bird writes: > >> I've tried the example block but it doesn't export well. >> >> img-2017-09-29-100634.png > > You didn't specify you were trying to export an Org table in the first > place. You need to give as much information as possible if you want to > have useful answers. > > So, let's start again: > > - what are you trying to export? > - to what back-end? > - what is the exact problem? > > Regards, -- Amos Bird amosbird@gmail.com --=-=-= Content-Type: multipart/related; boundary="==-=-=" --==-=-= Content-Type: text/html

Hi,

> - what are you trying to export?

an Org table like this:

| QueryID | SQL Text                                                                                                                                                                                  | Query Time (Seconds) | Query Time Hot (Seconds) |
|---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+--------------------------|
| Q0      | SELECT cab_type, count(*) FROM trips_log GROUP BY cab_type;                                                                                                                               |                10.14 |                    11.57 |
| Q1      | SELECT passenger_count, avg(total_amount) FROM trips_log GROUP BY passenger_count;                                                                                                        |                12.00 |                     6.27 |
| Q2      | SELECT passenger_count, toYear(pickup_datetime) AS year, count(*) FROM trips_log GROUP BY passenger_count, year;                                                                          |                10.45 |                     7.23 |
| Q3      | SELECT passenger_count, toYear(pickup_datetime) AS year, round(trip_distance) AS distance, count(*) FROM trips_log GROUP BY passenger_count, year, distance ORDER BY year, count(*) DESC; |                13.03 |                    10.80 |

> - to what back-end?

ODT and HTML

> - what is the exact problem?

I'd like to export this table with *:nil ^:nil options while exporting other subtrees with *:t ^:t.

I tried surrounding the table with example block and src block but both look bad after exportation.

I added <10> to the SQL column but it doesn't help quoting the * and _ characters when exporting.

I also tried changing _ to \under{} and * to \asc{} but it doesn't look well in the Org buffer.

I did turn on org-toggle-pretty-entities but it changes the appearance of other subtrees which I don't want to.

regards,

Nicolas Goaziou <mail@nicolasgoaziou.fr> writes:

> Hello,
>
> Amos Bird <amosbird@gmail.com> writes:
>
>> I've tried the example block but it doesn't export well.
>>
>> img-2017-09-29-100634.png
>
> You didn't specify you were trying to export an Org table in the first
> place. You need to give as much information as possible if you want to
> have useful answers.
>
> So, let's start again:
>
> - what are you trying to export?
> - to what back-end?
> - what is the exact problem?
>
> Regards,

–
Amos Bird
amosbird@gmail.com

--==-=-=-- --=-=-=--