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