[O] Spreadsheet row formula
In the following table I am trying to implement a row formula for each cell to be a multiple of the corresponding cell in a preceding row, but several variations I tried do not work: | A| 2 | 3 | 4| | B| [4, 6, 8] | [4, 6, 8] | [4, 6, 8] | | C| [4, 6, 8] | [4, 6, 8] | [4, 6, 8] | | 2 A | 4 | 6 | 8 | #+TBLFM: @2$2..@2$4=2*@1$2..@1$4::@3$2..@3$4=2*(@1$2..@1$4) What I would like to get, without having to repeat the formula for each cell in the row is: |B|4|6|8| It seems that this should be fairly simple to do. I am using the latest git version of orgmode with emacs 24.0.50 Thanks for any suggestions.
Re: [O] Spreadsheet row formula
Hi, Sorry not to be clearer. I would like to implement the formula for only one row. So entering the first row shown below and implementing the formula with only B entered in the first column in the second row gives the rest of the second row. |A|2|3|4| |B|4|6|8| Your suggestion almost does what I want, except that it applies the formula to every row. I would like to apply different row formulas to succeeding rows. Also I was not clear about the syntax you used, does $ exclude the first column and $ indicate up to the last column? I tried to modify your formula to restrict it to the second row: @2$..@2$ = 2 * @-1 But that did not work. Thanks. On Sun, Jan 8, 2012 at 10:51 AM, Michael Brand michael.ch.br...@gmail.comwrote: Hi RCY Do you want to do this?: | A | 2 | 3 | 4 | | B | 4 | 6 | 8 | | C | 8 | 12 | 16 | #+TBLFM: @$..@$ = 2 * @-1 Michael
Re: [O] Spreadsheet row formula
Hi, That does what I want. Thanks for taking the time to explain it. I should have read the manual on relative cell references more carefully. On Sun, Jan 8, 2012 at 11:23 AM, Michael Brand michael.ch.br...@gmail.comwrote: Hi RCY On Sun, Jan 8, 2012 at 17:12, RCY re...@yahoo.com wrote: Sorry not to be clearer. I would like to implement the formula for only one row. So entering the first row shown below and implementing the formula with only B entered in the first column in the second row gives the rest of the second row. |A|2|3|4| |B|4|6|8| Your suggestion almost does what I want, except that it applies the formula to every row. I would like to apply different row formulas to succeeding rows. So you want this: | A | 2 | 3 | 4 | | B | 4 | 6 | 8 | #+TBLFM: @2$..@2$ = 2 * @-1 Also I was not clear about the syntax you used, does $ exclude the first column and $ indicate up to the last column? I tried to modify your formula to restrict it to the second row: @2$..@2$ = 2 * @-1 @ first row $ second column $ last column @ second last row [...] See also the manual here: http://orgmode.org/manual/References.html Michael
[O] Arranging BABEL source block and output figure side by side in html output
Hi, I apologize in advance if this is documented in the manual or addressed already in the mailing list but I was unable to find an answer. Is it possible to arrange a BABEL asymptote source block and the resulting output figure side by side in html output? Thanks for any help. RC
Re: [O] Arranging BABEL source block and output figure side by side in html output
On Thu, Jun 27, 2013 at 6:18 PM, Eric Schulte schulte.e...@gmail.com wrote: RCY re...@yahoo.com writes: Hi, I apologize in advance if this is documented in the manual or addressed already in the mailing list but I was unable to find an answer. Is it possible to arrange a BABEL asymptote source block and the resulting output figure side by side in html output? Thanks for any help. RC I haven't used it in some time, so it probably needs some repair, but I put together a tool for exactly this use case. http://eschulte.github.io/org-docco/org-docco.html Hope this helps, -- Eric Schulte http://cs.unm.edu/~eschulte Thanks I will look in modifying it for my use. RC
[O] Error while compiling
Hi, I tried compiling the git version on a Mac running Lion with emacs 24.3 and I get the error: make compile-dirall dirall Checking /Users/rc/elisp/org-mode/lisp... Compiling /Users/rc/elisp/org-mode/lisp/org-attach.el... In toplevel form: org-attach.el:42:1:Error: Symbol's value as variable is void: user-emacs-directory Compiling /Users/rc/elisp/org-mode/lisp/org-install.el... Compiling /Users/rc/elisp/org-mode/lisp/org-loaddefs.el... Compiling /Users/rc/elisp/org-mode/lisp/org-version.el... Compiling /Users/rc/elisp/org-mode/lisp/ox-odt.el... In toplevel form: ox-odt.el:369:1:Error: Cannot open load file: rng-loc Done (Total of 0 files compiled, 2 failed, 3 skipped) Is there a problem with the file in th git version o
[O] Error compiling file
Hi, I am trying to compile the git version on a Mac with emacs 24.3 and I get the error: make compile-dirall dirall Checking /Users/rc/elisp/org-mode/lisp... Compiling /Users/rc/elisp/org-mode/lisp/org-attach.el... In toplevel form: org-attach.el:42:1:Error: Symbol's value as variable is void: user-emacs-directory Compiling /Users/rc/elisp/org-mode/lisp/org-install.el... Compiling /Users/rc/elisp/org-mode/lisp/org-loaddefs.el... Compiling /Users/rc/elisp/org-mode/lisp/org-version.el... Compiling /Users/rc/elisp/org-mode/lisp/ox-odt.el... In toplevel form: ox-odt.el:369:1:Error: Cannot open load file: rng-loc Done (Total of 0 files compiled, 2 failed, 3 skipped) Is there a problem with the file or am I doing something wrong? Thanks, RC
[O] Booktabs in new LaTeX exporter
I am trying to use the booktabs package for tables in the new exporter, however I am unable to get \toprule, etc instead of \hrule I would appreciate any suggestions to fix this. As a minimal example, I started emacs -q, and evaluated the following: (setq org-install-dir ~/.emacs.d/src/org-mode) (add-to-list 'load-path (concat org-install-dir /contrib/lisp)) (add-to-list 'load-path (concat org-install-dir /lisp)) (require 'org-e-latex) (add-to-list 'org-e-latex-classes '(article \\documentclass[11pt]{article} \[DEFAULT-PACKAGES] \[PACKAGES] \[EXTRA] (\\section{%s} . \\section*{%s}) (\\subsection{%s} . \\subsection*{%s}) (\\subsubsection{%s} . \\subsubsection*{%s}))) -org.file--- #+LATEX_CLASS: article #+LATEX_HEADER: \usepackage{booktabs} * Test #+ATTR_LATEX: :booktabs #+CAPTION: Test table |+| | 1 | 2 | |+| | A1 | A2 | | B1 | B2 | | C1 | C2 | |+| --latex-buffer from org-export-latex-as-buffer--- % Created 2012-12-27 Thu 18:44 \documentclass[11pt]{article} \usepackage[utf8]{inputenc} \usepackage[T1]{fontenc} \usepackage{fixltx2e} \usepackage{graphicx} \usepackage{longtable} \usepackage{float} \usepackage{wrapfig} \usepackage{soul} \usepackage{textcomp} \usepackage{marvosym} \usepackage{wasysym} \usepackage{latexsym} \usepackage{amssymb} \usepackage{hyperref} \tolerance=1000 \usepackage{booktabs} \providecommand{\alert}[1]{\textbf{#1}} \title{tst} \author{RC} \date{\today} \hypersetup{ pdfkeywords={}, pdfsubject={}, pdfcreator={Emacs Org-mode version 7.9.2+}} \begin{document} \maketitle \setcounter{tocdepth}{3} \tableofcontents \vspace*{1cm} \section{Test} \label{sec-1} \begin{table}[htb] \caption{Test table} \begin{center} \begin{tabular}{ll} \hline 1 2 \\ \hline A1A2 \\ B1B2 \\ C1C2 \\ \hline \end{tabular} \end{center} \end{table} \end{document}
Re: [O] Booktabs in new LaTeX exporter
Hi, I had tried t but then removed it when it did not work and the documentation seemed to indicate that :booktabs was a toggle. I tried your suggestion to add (setq org-e-latex-tables-booktabs t) to the .emacs file but I am still getiing \hline. I did make sure to get the latest version from git and I am running emacs 24.3.50.1. Thanks. On Thu, Dec 27, 2012 at 7:17 PM, Thomas S. Dye t...@tsdye.com wrote: Aloha RCY, You can have this in your setup to enable booktabs globally: (setq org-e-latex-tables-booktabs t) Or, you can give a table this attribute: #+attr_latex: :booktabs t I think your example should work if you add the t after :booktabs. hth, Tom RCY re...@yahoo.com writes: I am trying to use the booktabs package for tables in the new exporter, however I am unable to get \toprule, etc instead of \hrule I would appreciate any suggestions to fix this. As a minimal example, I started emacs -q, and evaluated the following: (setq org-install-dir ~/.emacs.d/src/org-mode) (add-to-list 'load-path (concat org-install-dir /contrib/lisp)) (add-to-list 'load-path (concat org-install-dir /lisp)) (require 'org-e-latex) (add-to-list 'org-e-latex-classes '(article \\documentclass[11pt]{article} \[DEFAULT-PACKAGES] \[PACKAGES] \[EXTRA] (\\section{%s} . \\section*{%s}) (\\subsection{%s} . \\subsection*{%s}) (\\subsubsection{%s} . \\subsubsection*{%s}))) -org.file--- #+LATEX_CLASS: article #+LATEX_HEADER: \usepackage{booktabs} * Test #+ATTR_LATEX: :booktabs #+CAPTION: Test table |+| | 1 | 2 | |+| | A1 | A2 | | B1 | B2 | | C1 | C2 | |+| --latex-buffer from org-export-latex-as-buffer--- % Created 2012-12-27 Thu 18:44 \documentclass[11pt]{article} \usepackage[utf8]{inputenc} \usepackage[T1]{fontenc} \usepackage{fixltx2e} \usepackage{graphicx} \usepackage{longtable} \usepackage{float} \usepackage{wrapfig} \usepackage{soul} \usepackage{textcomp} \usepackage{marvosym} \usepackage{wasysym} \usepackage{latexsym} \usepackage{amssymb} \usepackage{hyperref} \tolerance=1000 \usepackage{booktabs} \providecommand{\alert}[1]{\textbf{#1}} \title{tst} \author{RC} \date{\today} \hypersetup{ pdfkeywords={}, pdfsubject={}, pdfcreator={Emacs Org-mode version 7.9.2+}} \begin{document} \maketitle \setcounter{tocdepth}{3} \tableofcontents \vspace*{1cm} \section{Test} \label{sec-1} \begin{table}[htb] \caption{Test table} \begin{center} \begin{tabular}{ll} \hline 1 2 \\ \hline A1A2 \\ B1B2 \\ C1C2 \\ \hline \end{tabular} \end{center} \end{table} \end{document} I am trying to use the booktabs package for tables in the new exporter, however I am unable to get \toprule, etc instead of \hrule I would appreciate any suggestions to fix this. As a minimal example, I started emacs -q, and evaluated the following: (setq org-install-dir ~/.emacs.d/src/org-mode) (add-to-list 'load-path (concat org-install-dir /contrib/lisp)) (add-to-list 'load-path (concat org-install-dir /lisp)) (require 'org-e-latex) (add-to-list 'org-e-latex-classes '(article \\documentclass[11pt]{article} \[DEFAULT-PACKAGES] \[PACKAGES] \[EXTRA] (\\section{%s} . \\section*{%s}) (\\subsection{%s} . \\subsection*{%s}) (\\subsubsection{%s} . \\subsubsection*{%s}))) -org.file--- #+LATEX_CLASS: article #+LATEX_HEADER: \usepackage{booktabs} * Test #+ATTR_LATEX: :booktabs #+CAPTION: Test table |+| | 1 | 2 | |+| | A1 | A2 | | B1 | B2 | | C1 | C2 | |+| --latex-buffer from org-export-latex-as-buffer--- % Created 2012-12-27 Thu 18:44 \documentclass[11pt]{article} \usepackage[utf8]{inputenc} \usepackage[T1]{fontenc} \usepackage{fixltx2e} \usepackage{graphicx} \usepackage{longtable} \usepackage{float} \usepackage{wrapfig} \usepackage{soul} \usepackage{textcomp} \usepackage{marvosym} \usepackage{wasysym} \usepackage{latexsym} \usepackage{amssymb} \usepackage{hyperref} \tolerance=1000 \usepackage{booktabs} \providecommand{\alert}[1]{\textbf{#1}} \title{tst} \author{RC} \date{\today} \hypersetup{ pdfkeywords={}, pdfsubject={}, pdfcreator={Emacs Org-mode version 7.9.2+}} \begin{document} \maketitle \setcounter{tocdepth}{3} \tableofcontents \vspace*{1cm} \section{Test} \label{sec-1} \begin{table}[htb] \caption{Test table} \begin{center} \begin{tabular}{ll} \hline 1 2 \\ \hline A1A2 \\ B1B2 \\ C1C2 \\ \hline \end{tabular} \end{center} \end{table} \end{document} -- Thomas S. Dye http://www.tsdye.com
Re: [O] Booktabs in new LaTeX exporter
Hi, Thanks for looking into this. I tried your suggestions but I am still having the problem. It seems that some but not all attributes I set are recognized. So in the example below it sets sideways table but ignores the booktabs and positioning attributes. #+LATEX_CLASS: article #+LATEX_HEADER: \usepackage{booktabs} org-file- * Test #+CAPTION: Test table #+attr_latex: :booktabs t :align |r|l| :float sidewaystable |+| | 1 | 2 | |+| | A1 | A2 | | B1 | B2 | | C1 | C2 | |+| -latex buffer- : \begin{sidewaystable}[htb] \caption{Test table} \begin{center} \begin{tabular}{ll} \hline 1 2 \\ \hline A1A2 \\ B1B2 \\ C1C2 \\ \hline \end{tabular} \end{center} \end{sidewaystable} - On Thu, Dec 27, 2012 at 8:42 PM, Thomas S. Dye t...@tsdye.com wrote: Hmm, It works like a charm here. I add booktabs like this: (add-to-list 'org-export-latex-packages-alist '( booktabs)) Also, I noticed you have \[PACKAGES]. I don't escape the opening brace: (add-to-list 'org-e-latex-classes '(koma-article \\documentclass{scrartcl} [NO-DEFAULT-PACKAGES] [PACKAGES] [EXTRA] \\let\\itemize\\compactitem \\let\\description\\compactdesc \\let\\enumerate\\compactenum \\bibliography{local} \\newcommand{\\rc}{\\textsuperscript{14}C} \\newcolumntype{Y}{{\\RaggedRight\\arraybackslash}X} (\\section{%s} . \\section*{%s}) (\\subsection{%s} . \\subsection*{%s}) (\\subsubsection{%s} . \\subsubsection*{%s}) (\\paragraph{%s} . \\paragraph*{%s}) (\\subparagraph{%s} . \\subparagraph*{%s}))) hth, Tom RCY re...@yahoo.com writes: Hi, I had tried t but then removed it when it did not work and the documentation seemed to indicate that :booktabs was a toggle. I tried your suggestion to add (setq org-e-latex-tables-booktabs t) to the .emacs file but I am still getiing \hline. I did make sure to get the latest version from git and I am running emacs 24.3.50.1. Thanks. On Thu, Dec 27, 2012 at 7:17 PM, Thomas S. Dye t...@tsdye.com wrote: Aloha RCY, You can have this in your setup to enable booktabs globally: (setq org-e-latex-tables-booktabs t) Or, you can give a table this attribute: #+attr_latex: :booktabs t I think your example should work if you add the t after :booktabs. hth, Tom RCY re...@yahoo.com writes: I am trying to use the booktabs package for tables in the new exporter, however I am unable to get \toprule, etc instead of \hrule I would appreciate any suggestions to fix this. As a minimal example, I started emacs -q, and evaluated the following: (setq org-install-dir ~/.emacs.d/src/org-mode) (add-to-list 'load-path (concat org-install-dir /contrib/lisp)) (add-to-list 'load-path (concat org-install-dir /lisp)) (require 'org-e-latex) (add-to-list 'org-e-latex-classes '(article \\documentclass[11pt]{article} \[DEFAULT-PACKAGES] \[PACKAGES] \[EXTRA] (\\section{%s} . \\section*{%s}) (\\subsection{%s} . \\subsection*{%s}) (\\subsubsection{%s} . \\subsubsection*{%s}))) -org.file--- #+LATEX_CLASS: article #+LATEX_HEADER: \usepackage{booktabs} * Test #+ATTR_LATEX: :booktabs #+CAPTION: Test table |+| | 1 | 2 | |+| | A1 | A2 | | B1 | B2 | | C1 | C2 | |+| --latex-buffer from org-export-latex-as-buffer--- % Created 2012-12-27 Thu 18:44 \documentclass[11pt]{article} \usepackage[utf8]{inputenc} \usepackage[T1]{fontenc} \usepackage{fixltx2e} \usepackage{graphicx} \usepackage{longtable} \usepackage{float} \usepackage{wrapfig} \usepackage{soul} \usepackage{textcomp} \usepackage{marvosym} \usepackage{wasysym} \usepackage{latexsym} \usepackage{amssymb} \usepackage{hyperref} \tolerance=1000 \usepackage{booktabs} \providecommand{\alert}[1]{\textbf{#1}} \title{tst} \author{RC} \date{\today} \hypersetup{ pdfkeywords={}, pdfsubject={}, pdfcreator={Emacs Org-mode version 7.9.2+}} \begin{document} \maketitle \setcounter{tocdepth}{3} \tableofcontents \vspace*{1cm} \section{Test} \label{sec-1} \begin{table}[htb] \caption{Test table} \begin{center} \begin{tabular}{ll} \hline 1 2 \\ \hline A1A2 \\ B1B2 \\ C1C2 \\ \hline \end{tabular} \end{center} \end{table} \end{document} I am trying to use the booktabs package for tables in the new exporter, however I am unable to get \toprule, etc instead of \hrule I would appreciate any suggestions to fix this. As a minimal example, I started emacs -q, and evaluated the following
Re: [O] Booktabs in new LaTeX exporter
Hi Tom, Thanks for your patience. I did finally figure out what I was doing wrong. I was using org-export-as-latex-to-buffer (which uses the default exporter) instead of org-e-latex-export-as-latex or org-e-latex-export-to-pdf. However, I am still unable to set something like ':align rr' using org-e-export-as-html; it defaults to left alignment (the latex export works fine). One of the reasons I am trying out the new exporter is to be able to use booktabs and hopefully the threeparttable package which makes inclusion of footnotes convenient (I prefer ctable but this probably requires a different approach as it is implemented as a command). Have you tried to use either of these packages? Thanks. On Fri, Dec 28, 2012 at 12:27 PM, Thomas S. Dye t...@tsdye.com wrote: Aloha RCY, Here is a (too long) working example that shows how to pass attributes. See especially :align, where you've passed a symbol instead of a string. Note that the new exporter is still in contrib and that at this stage in its life is documented in the code and in some messages and announcements that Nicolas Goaziou sent to the mailing list. It is still necessary to refer to these scattered sources to learn about the new exporter.
Re: [O] Booktabs in new LaTeX exporter
Hi Tom, I hacked together a preliminary solution that uses the booktabs and threeparttable (for footnotes) packages, based on the suggestion in section 13.2 of http://orgmode.org/worg/org-tutorials/org-latex-export.html It seems to do OK in a simple example, and I will test it some more. It does not export to html. Thanks for your help. #+LATEX_CLASS: article #+latex_header: \usepackage{booktabs,tabularx,threeparttable} * noexport :noexport: #+tblname: test-table | L | R$^1$ | X$^2$ | |---+---+---| | A | B | C | | D | E | F | | I | J | K | * do export #+name: tabularx-export #+begin_src latex :exports results :results latex :noweb yes \begin{table}[htb!] \centering \begin{threeparttable}[b] \footnotesize \caption{A table to test booktabs} \label{tab:test-table} booktabs(table=test-table,align=lrX,env=tabularx,width=0.5\\textwidth) \begin{tablenotes} \item [1] A table note ... \item [2] A second table note ... \end{tablenotes} \end{threeparttable} \end{table} #+end_src On Fri, Dec 28, 2012 at 2:06 PM, Thomas S. Dye t...@tsdye.com wrote: I think the :align attribute expects a string instead of a symbol, so :align rr is probably what you want. I don't know about the new html exporter yet, but I'd be surprised if it looks at LaTeX attributes. You might want to experiment with alignment cookies in the table to see if they do what you want: http://orgmode.org/manual/Column-width-and-alignment.html#Column-width-and-alignment I haven't used threeparttable or ctable. Org footnotes work inside tables, if you want the note to appear outside the table. Typesetting tables is hard. Let the list know if you get Org to work with either of these packages. All the best, Tom
[Orgmode] [Babel] Output of multiple variables from octave source
Hi, I would like to output multiple variables from an octave program. When I evaluate: #+srcname: test.m #+begin_src octave clear variables x=5.1; y=3*x; sprintf('x=%.1f',x) sprintf('y=%.1f',y) #+end_src I get #+results: test.m : y=15.3 Is there a way to get multiple variables output, other than something like: #+srcname: test.m #+begin_src octave clear variables x=5.1; y=3*x; sprintf('x=%.1f,\n y=%.1f',x,y) #+end_src #+results: test.m : x=5.1, y=15.3 which starts to get unwieldy for a larger number of variables. I am using the org-mode from git in Emacs 23.1. Thanks for any help. RC ___ Emacs-orgmode mailing list Please use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode
[O] Inserting property drawers and comments
Hi, I can insert a property drawer using the 'C-u C-c C-x d' key sequence. Is there a way to do so by directly calling the org-insert-property-drawer function? I get a 'Wrong type argument: commandp, org-insert-property drawer error' when I try to call it using a shortcut command. I have a similar problem with org-insert-comment and org-insert-item, but others like org-insert-link, org-insert-todo-heading, etc work fine. Thanks RC