Re: [O] Disable fontification when exporting tables

[Nicolas Goaziou]

Hello,

Amos Bird <address@hidden> 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