orgtbl-to-latex :splice t :skip x does not radio empty first column

orgtbl-to-latex :splice t :skip x does not radio empty first column

[Charles]

I have searched "radio table", "skip" and "splice" and have attempted to 
understand some of the code in org-table.el concerning orgtbl-to-latex; 
all with no luck.
If there is an post or answer or solution that already exist please 
advise and I'll keep on looking.

I am setting up a document the format of which is required.  Different 
source files will be used. As an example:

Table to radio:

TBLNAME: SCHEDA1
#+ORGTBL: SEND SCHEDA1 orgtbl-to-latex  :splice t :skip 2
| Date | Description                            | Value | Basis | Loss |
| -------+---------------------------------------+---------+--  
-----+--------|
|          | None                                      |   0.00 |  0.00 
| 0.00 |
|          | Total Gains on sales, etc.     |            |           | 
0.00 |

#+TBLFM: @>$>=vsum(@2..-1);%.2f::$5=vsum($3-$4);%.2f

Target table much further down:

Schedule A-1
\begin{tabulary}{parameters}
Date & \multicolumn{1}{c}{Transaction} & \multicolumn{1}{c}{Proceeds} & 
\multicolumn{1}{c}{Basis} & \multicolumn{1}{c}{Gain}\\
\hline \hline
% BEGIN RECEIVE ORGTBL SCHEDA1
% END RECEIVE ORGTBL SCHEDA1
\end{tabulary}

Result after C-c C-c on SCHEDA1

\begin{tabulary}{parameters}
Date & \multicolumn{1}{c}{Transaction} & \multicolumn{1}{c}{Proceeds} & 
\multicolumn{1}{c}{Basis} & \multicolumn{1}{c}{Gain}\\
\hline \hline
% BEGIN RECEIVE ORGTBL SCHEDA1
None & 0.00 & 0.00 & 0.00 \\
Total Gains on sales, etc. & & & 0.00 \\
% END RECEIVE ORGTBL SCHEDA1
\end{tabulary}

As you will observe, the empty column is not radioed, i.e. there is no 
"&" preceding the "None" and the "Total Gains . . . ." AFAIC, it should 
be unnecessary to enter something in the original first column prior to 
sending just to have orgtbl-to-latex correctly radio what should be an 
empty column. At the moment the only hack or kludge (pardon me if I use 
these incorrectly) is to place the "&" prior to "None" and "Total" after 
conversion to LaTeX.  Again, however, this also should not be necessary 
in the first place, i.e. | | foo| bar| should yield & & foo & bar \\

Anyway,  Texworks typesets this as

Date                            Transaction            Proceeds        
Basis        Gain
---------------------------------------------------------------------------------------------- 
(the two \hlines are printed)
None                            0.00                        0.00        
         0.00
Total Gains on sales                                                    
        0.00

For reasons that are not germane, I want to radio only the "data" rows 
from the original ORGTBL, i.e. no headings or hlines since these will be 
provided in what is essentially a LaTeX template.
Also, the table cannot be omitted from the account.

Charlie Millar

Re: orgtbl-to-latex :splice t :skip x does not radio empty first column

[Charles]

First I neglected to mention that I am using Org-mode 7.8.11, Emacs 
24.0.93.1 on Windows 7.

Second my example at the end should be | | foo| bar| should yield & foo 
& bar \\

Charlie Millar

On 6/13/2012 4:57 PM, Charles wrote:
> I have searched "radio table", "skip" and "splice" and have attempted 
> to understand some of the code in org-table.el concerning 
> orgtbl-to-latex; all with no luck.
> If there is an post or answer or solution that already exist please 
> advise and I'll keep on looking.
>
> I am setting up a document the format of which is required.  Different 
> source files will be used. As an example:
>
> Table to radio:
>
> TBLNAME: SCHEDA1
> #+ORGTBL: SEND SCHEDA1 orgtbl-to-latex  :splice t :skip 2
> | Date | Description                            | Value | Basis | Loss |
> | -------+---------------------------------------+---------+--  
> -----+--------|
> |          | None                                      |   0.00 |  
> 0.00 | 0.00 |
> |          | Total Gains on sales, etc.     |            |           | 
> 0.00 |
>
> #+TBLFM: @>$>=vsum(@2..-1);%.2f::$5=vsum($3-$4);%.2f
>
> Target table much further down:
>
> Schedule A-1
> \begin{tabulary}{parameters}
> Date & \multicolumn{1}{c}{Transaction} & \multicolumn{1}{c}{Proceeds} 
> & \multicolumn{1}{c}{Basis} & \multicolumn{1}{c}{Gain}\\
> \hline \hline
> % BEGIN RECEIVE ORGTBL SCHEDA1
> % END RECEIVE ORGTBL SCHEDA1
> \end{tabulary}
>
> Result after C-c C-c on SCHEDA1
>
> \begin{tabulary}{parameters}
> Date & \multicolumn{1}{c}{Transaction} & \multicolumn{1}{c}{Proceeds} 
> & \multicolumn{1}{c}{Basis} & \multicolumn{1}{c}{Gain}\\
> \hline \hline
> % BEGIN RECEIVE ORGTBL SCHEDA1
> None & 0.00 & 0.00 & 0.00 \\
> Total Gains on sales, etc. & & & 0.00 \\
> % END RECEIVE ORGTBL SCHEDA1
> \end{tabulary}
>
> As you will observe, the empty column is not radioed, i.e. there is no 
> "&" preceding the "None" and the "Total Gains . . . ." AFAIC, it 
> should be unnecessary to enter something in the original first column 
> prior to sending just to have orgtbl-to-latex correctly radio what 
> should be an empty column. At the moment the only hack or kludge 
> (pardon me if I use these incorrectly) is to place the "&" prior to 
> "None" and "Total" after conversion to LaTeX.  Again, however, this 
> also should not be necessary in the first place, i.e. | | foo| bar| 
> should yield & & foo & bar \\
>
> Anyway,  Texworks typesets this as
>
> Date                            Transaction            Proceeds        
> Basis        Gain
> ---------------------------------------------------------------------------------------------- 
> (the two \hlines are printed)
> None                            0.00                        
> 0.00                0.00
> Total Gains on 
> sales                                                           0.00
>
> For reasons that are not germane, I want to radio only the "data" rows 
> from the original ORGTBL, i.e. no headings or hlines since these will 
> be provided in what is essentially a LaTeX template.
> Also, the table cannot be omitted from the account.
>
> Charlie Millar
>
>
>
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1424 / Virus Database: 2433/5067 - Release Date: 06/13/12
>
>