From mboxrd@z Thu Jan 1 00:00:00 1970 From: Nicolas Goaziou Subject: Re: Disable fontification when exporting tables Date: Sat, 30 Sep 2017 09:36:39 +0200 Message-ID: <87ing0ljso.fsf@nicolasgoaziou.fr> References: <8737785ytb.fsf@gmail.com> <874lrmodvo.fsf@nicolasgoaziou.fr> <87bmlus1ci.fsf@gmail.com> <878tgxmh1q.fsf@nicolasgoaziou.fr> <87a81drnsv.fsf@gmail.com> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:32960) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1dyCKM-000413-1R for emacs-orgmode@gnu.org; Sat, 30 Sep 2017 03:36:47 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1dyCKI-0008UO-UF for emacs-orgmode@gnu.org; Sat, 30 Sep 2017 03:36:46 -0400 Received: from relay3-d.mail.gandi.net ([217.70.183.195]:50626) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1dyCKI-0008To-O8 for emacs-orgmode@gnu.org; Sat, 30 Sep 2017 03:36:42 -0400 In-Reply-To: <87a81drnsv.fsf@gmail.com> (Amos Bird's message of "Sat, 30 Sep 2017 09:13:36 +0800") 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: Amos Bird Cc: "emacs-orgmode@gnu.org" Hello, Amos Bird writes: >> - 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 | OK. >> - to what back-end? > > ODT and HTML OK. >> - what is the exact problem? > > I'd like to export this table with *:nil ^:nil options while exporting other subtrees with *:t ^:t. This is not my question. You are explaining me how you are trying to proceed. I want to know what it the problem you are trying to solve. Anyway, it seems you are conflating fontification in the Org buffer and export. I guess there is no issue related to export in this thread. > I tried surrounding the table with example block and src block but > both look bad after exportation. Of course. I didn't know you were exporting an Org table. However, you could add verbatim markup =SELECT cab_type, count(*) FROM trips_log GROUP BY cab_type;= but, again, since I don't know exactly what the issue is, I may be wide of the mark. > characters when exporting. I never suggested that. > 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. Maybe Org mode is not the appropriate mode for the task? Regards, -- Nicolas Goaziou