[Orgmode] no SPACE allowed in new node/item name created during refiling
Hello Carsten, A SPACE is not allowed in the name when creating a new node/item while refiling, is it a bug, restriction or configuration issue? Regards -- Manish ___ 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
Re: [Orgmode] Re: refiling
On Thu, Jan 14, 2010 at 1:10 AM, Richard Riley wrote: [...] > > Also thanks to the others - I used manish' funtion to toggle category > appearance and I changed my categories to be more "Pretty Printing" for > the agenda e.g > > :CATEGORY:The XyZ Project > The function is credit to Manuel Hermengildo. -- Manish ___ 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
[Orgmode] org-entry-get bugs etc.
I ran into a bug in which org-entry-get returns the wrong value. It brought up some other points. 1) org-entry-get of "TODO" returns the wrong value when there is a lower case version of a todo kw on a headline. Example: * neowhen I have "NEOWHEN" as a todo kw. What it returns is "neowhen". What I think it should return is the value for a blank state. Currently, this value is nil. 2) This is the 5th bug that I have reported of this type. In all 5 cases, the lower case version of a todo kw at the beginning of a headline caused incorrect behavior. This suggests separate matches. At least as a possibility. This in turn suggests to me that it might be possible to refactor org. By this I mean create a wrapper to do the matching and call that wrapper in all of those places. I wish I could help here, but I cannot. 3) For the user, I think it is more convenient to use org-entry-get for metadata than to parse manually. This is a useful function. 4) Perhaps Lisp keywords can be allowed instead of strings for speed. For example, (org-entry-get point-or-marker :todo) Instead of: (org-entry-get point-or-marker "TODO") I don't know if it would be significant. 5) This isn't directly related, but the value for a blank state is currently nil, not "". I have not thought about this deeply, but as nil is not a string, it is a special case (i.e. the only state that is not a string). In my experience, special cases in return values cause complicated code, because calling code needs to special-case the special case instead of merely composing, funcalling, or applying. Perhaps it's too late to change that. Or perhaps there is a special reason to use nil. But seems worth mentioning just in case it triggers an idea. Thanks. Samuel -- Q: How many CDC "scientists" does it take to change a lightbulb? A: You only think it's dark. [CDC has denied ME/CFS for 25 years] = Retrovirus: http://www.wpinstitute.org/xmrv/xmrv_qa.html ___ 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
[Orgmode] Error when exporting to LaTeX
Hi all, Here a problem when exporting such a file: --8<---cut here---start->8--- #+MACRO: sp1 \rule{0.52cm}{0.7pt} #+MACRO: rest {\leavevmode \leaders \hrule height 0.7pt\hfill} \\ \clearpage{} Nombre de la escuela de idiomas: {{{rest}}} Nombre y apellidos del estudiante: {{{rest}}} Nombre y apellidos del profesor o de la profesora: {{{rest}}} Día(s) de la semana que tiene clase y de qué hora a qué hora: --8<---cut here---end--->8--- The `rest' macro is for filling the rest of the current line with an horizontal rule. It needs to be enclosed between accolades. Though, it wrongly gets translated into: --8<---cut here---start->8--- \clearpage{} Nombre de la escuela de idiomas: {\leavevmode \leaders \hrule height 0.7pt\hfill\} \\ Nombre y apellidos del estudiante: {\leavevmode \leaders \hrule height 0.7pt\hfill\} \\ Nombre y apellidos del profesor o de la profesora: {\leavevmode \leaders \hrule height 0.7pt\hfill\} \\ Día(s) de la semana que tiene clase y de qué hora a qué hora: --8<---cut here---end--->8--- Notice the backslash in front of the final accolade. Any help? Best regards, Seb -- Sébastien Vauban ___ 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
[Orgmode] Re: Help with a custom block agenda
Matt Lundin writes: >> block agenda however, I only want to see those which are unscheduled, >> not WAITING, not STARTED as I've already listed those items above - it's >> this section where I want to see all the FOCUS actions which I haven't >> addressed yet. > > Does the following work? > > (setq org-agenda-custom-commands >'(("a" "Custom block Agenda" > ((agenda "") >(todo "STARTED") >(tags "FOCUS/!-STARTED-WAITING" >((org-agenda-todo-ignore-scheduled t) > ("d" todo "DONE" > ((org-agenda-todo-ignore-scheduled nil) >(org-agenda-todo-ignore-with-date nil) >(org-agenda-todo-ignore-deadlines nil))) > ("p" "Project list" tags "project") > ("f" "FOCUS list" tags-todo "FOCUS") > )) THanks Matt, that very nearly works, it certainly gets rid of the WAITING and STARTED, but I can still see the scheduled items - the org-agenda-todo-ignore-scheduled bit doesn't seem to have any effect. It's odd, given that the same syntax later in the list seems to have the desired effect. Any thoughts? Thanks Paul ___ 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
[Orgmode] Re: refiling
John Rakestraw writes: >> Richard Riley writes: > >> That is fine and as expected. My point is more that I am unable to >> file to linux.org/general since it has elements filed there. It offers >> me to select an actual existing org item as opposed to letting me >> store the rewritten item to linux.org/general. > > Not sure I understand you here, so this might not be helpful. However, > when I do what I think you're trying to do, hitting the space bar after > "linux.org/general" is in the mini-buffer allows me to save directly to > "linux.org/general." This assumes that :level and/or :maxlevel are set > appropriately in the org-refile-targets variable. That was it John. Thanks. Possibly a default key of c-j would be nice too to "create at this level". Also thanks to the others - I used manish' funtion to toggle category appearance and I changed my categories to be more "Pretty Printing" for the agenda e.g :CATEGORY:The XyZ Project regards r. -- Google Talk : rileyrg...@googlemail.com http://www.google.com/talk ___ 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
Re: [Orgmode] Re: org-babel-R and windows ?
"d.tchin" writes: > Dan Davison stats.ox.ac.uk> writes: >> The org-babel default is to invoke R as an external shell command, and I >> think this is what is causing the problem. It requires that the emacs >> function shell-command can use the string "R" to invoke an R process, >> i.e. the R installation and the shell path must be such that this is the >> case. > > Thank you for the information and explanation. > It seems that the problem comes from the windows shell. > > I try the following : I explicitely told emacs to use bash > with the following instructions : > (setq explicit-shell-file-name "C:/msys/1.0/bin/bash.exe") > (setq shell-file-name explicit-shell-file-name) > > It works with bash. Thanks for that, I've stored your solution in the org-babel development repo with a view to modifying our code so that these probloems are minimised in the future, and we'll also make sure the documentation addresses this. Dan > > >> >> #+srcname:trial >> #+begin_src R :session org-babel-R-session >>c(4,5,6,7,8,9) >> #+end_src > > The "session" way works too. > > Thank you. > > > > > > > ___ > 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 ___ 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
Re: [Orgmode] Re: refiling
> Richard Riley writes: > That is fine and as expected. My point is more that I am unable to > file to linux.org/general since it has elements filed there. It offers > me to select an actual existing org item as opposed to letting me > store the rewritten item to linux.org/general. Not sure I understand you here, so this might not be helpful. However, when I do what I think you're trying to do, hitting the space bar after "linux.org/general" is in the mini-buffer allows me to save directly to "linux.org/general." This assumes that :level and/or :maxlevel are set appropriately in the org-refile-targets variable. -- John Rakestraw ___ 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
[Orgmode] Re: Help with a custom block agenda
Hi Paul, Paul Mead writes: > I want the option to have TODO items with the tag "FOCUS" listed in both > the custom block agenda, and as a list in its own right. In the custom > block agenda however, I only want to see those which are unscheduled, > not WAITING, not STARTED as I've already listed those items above - it's > this section where I want to see all the FOCUS actions which I haven't > addressed yet. Does the following work? --8<---cut here---start->8--- (setq org-agenda-custom-commands '(("a" "Custom block Agenda" ((agenda "") (todo "STARTED") (tags "FOCUS/!-STARTED-WAITING" ((org-agenda-todo-ignore-scheduled t) ("d" todo "DONE" ((org-agenda-todo-ignore-scheduled nil) (org-agenda-todo-ignore-with-date nil) (org-agenda-todo-ignore-deadlines nil))) ("p" "Project list" tags "project") ("f" "FOCUS list" tags-todo "FOCUS") )) --8<---cut here---end--->8--- Best, Matt ___ 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
[Orgmode] Re: refiling
Matt Lundin writes: >> if I refile from elsewhere, it picks ALL items at a level to refile to when >> I select >> linux.org. >> >> e.g linux.org/general, linux.org/debian, linux.org/test >> >> If I then select "general" it also prompts for me now to select "learn >> org mode". Is this because of some hangover from me using org-mode? In >> other words I cant refile to linux.org/debian. > > Refile completion follows the hierarchy of your outline. Thus, once you > have limited the results to linux.org/general, org-refile will only > offer you subtrees belonging to "general." If you want more flexible That is fine and as expected. My point is more that I am unable to file to linux.org/general since it has elements filed there. It offers me to select an actual existing org item as opposed to letting me store the rewritten item to linux.org/general. > completion, you can fiddle around with the variables > org-refile-use-outline-path, org-completion-use-ido, > and org-outline-path-complete-in-steps. > Thanks for the reply. -- Google Talk : rileyrg...@googlemail.com http://www.google.com/talk ___ 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
[Orgmode] Re: refiling
Hi Richard, Richard Riley writes: > Two major issues for me to get my head around. > > 1) Tags v Categories. Its not entirely obvious to me what categories are > for. Are they like a more specialised tag? Categories are primarily for visibility in the agenda. I use them to remind myself what project or "area of responsibility" an item belongs to. If I label a particular project with the category "article", I can easily identify tasks belonging to that project. E.g., tasks from the following project... , | * PROJECT Write article :PROJECT: | :PROPERTIES: | :CATEGORY: article | :END: | ** TODO Do some online research :computer: |SCHEDULED: <2010-01-13 Wed> | ** TODO Outline article :rwb: |SCHEDULED: <2010-01-13 Wed> ` ...appear as follows in the agenda: , | Day-agenda (W02): | Wednesday 13 January 2010 | article:Scheduled: TODO Do some online research :computer: | article:Scheduled: TODO Outline article :rwb: ` Thanks to the category, I can see what project the otherwise cryptic "Do some online research" belongs to. > 2) Refiling. Lets says I have something like this in linux.org:- > > * general:general: > #+CATEGORY: general > ** learn org mode :emacs:org: > blah blah > * debian:debian: > #+CATEGORY: debian > * test This syntax for categories has been deprecated. Better to use properties, as in the example above. > > if I refile from elsewhere, it picks ALL items at a level to refile to when I > select > linux.org. > > e.g linux.org/general, linux.org/debian, linux.org/test > > If I then select "general" it also prompts for me now to select "learn > org mode". Is this because of some hangover from me using org-mode? In > other words I cant refile to linux.org/debian. Refile completion follows the hierarchy of your outline. Thus, once you have limited the results to linux.org/general, org-refile will only offer you subtrees belonging to "general." If you want more flexible completion, you can fiddle around with the variables org-refile-use-outline-path, org-completion-use-ido, and org-outline-path-complete-in-steps. Best, Matt ___ 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
[Orgmode] Re: refiling
Manish writes: > On Wed, Jan 13, 2010 at 10:00 PM, Richard Riley wrote: >> >> I'm a bit rusty so please excuse any stupid questions. >> >> I decided to clear up my org files which are, frankly, a mess. >> >> Two major issues for me to get my head around. >> >> 1) Tags v Categories. Its not entirely obvious to me what categories are >> for. Are they like a more specialised tag? > > To me they are a means to provide some more context only. But I do > not use them at all - I hide them using the excellent > my-org-agenda-toggle-list-category function courtesy Manuel > Hermengildo (http://article.gmane.org/gmane.emacs.orgmode/10909). > >> Useful , but the comments seem to be misleading in that the file names are not shown regardless of toggle state. Or is file name used as a more general category when no specific category is put it? Which is another cloudy issue for me - file name and category. e.g I have a file "linux.org". In it I have a category "General". But in the agenda this is not specific enough e,g I will see another General item from "Emacs" category "General". possibly all down to reformatting the output. I'm not sure I am clear about what categories are. ___ 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
Re: [Orgmode] refiling
On Wed, Jan 13, 2010 at 10:00 PM, Richard Riley wrote: > > I'm a bit rusty so please excuse any stupid questions. > > I decided to clear up my org files which are, frankly, a mess. > > Two major issues for me to get my head around. > > 1) Tags v Categories. Its not entirely obvious to me what categories are > for. Are they like a more specialised tag? To me they are a means to provide some more context only. But I do not use them at all - I hide them using the excellent my-org-agenda-toggle-list-category function courtesy Manuel Hermengildo (http://article.gmane.org/gmane.emacs.orgmode/10909). > > 2) Refiling. Lets says I have something like this in linux.org:- > > * general:general: > #+CATEGORY: general > ** learn org mode :emacs:org: > blah blah > * debian:debian: > #+CATEGORY: debian > > * test > > if I refile from elsewhere, it picks ALL items at a level to refile to when I > select > linux.org. > > e.g linux.org/general, linux.org/debian, linux.org/test > > If I then select "general" it also prompts for me now to select "learn > org mode". Is this because of some hangover from me using org-mode? In > other words I cant refile to linux.org/debian. Not sure.. may be looking at varible org-refile-allow-creating-parent-nodes would help. HTH -- Manish ___ 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
[Orgmode] Help with a custom block agenda
Hi all I wonder if anyone can guide me in amending my block agenda? currently I have: (setq org-agenda-custom-commands '(("a" "Custom block Agenda" ((agenda "") (todo "STARTED") (tags-todo "FOCUS"))) ("d" todo "DONE" ((org-agenda-todo-ignore-scheduled nil) (org-agenda-todo-ignore-with-date nil) (org-agenda-todo-ignore-deadlines nil))) ("p" "Project list" tags "project") ("f" "FOCUS list" tags-todo "FOCUS") )) I want the option to have TODO items with the tag "FOCUS" listed in both the custom block agenda, and as a list in its own right. In the custom block agenda however, I only want to see those which are unscheduled, not WAITING, not STARTED as I've already listed those items above - it's this section where I want to see all the FOCUS actions which I haven't addressed yet. I hope you are getting my drift here! Any ideas? Thanks Paul ___ 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
[Orgmode] Re: refiling
> If I then select "general" it also prompts for me now to select "learn > org mode". Is this because of some hangover from me using org-mode? In That should read "ido-mode". Sorry. > other words I cant refile to linux.org/debian. > ___ 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
[Orgmode] refiling
I'm a bit rusty so please excuse any stupid questions. I decided to clear up my org files which are, frankly, a mess. Two major issues for me to get my head around. 1) Tags v Categories. Its not entirely obvious to me what categories are for. Are they like a more specialised tag? 2) Refiling. Lets says I have something like this in linux.org:- * general:general: #+CATEGORY: general ** learn org mode :emacs:org: blah blah * debian:debian: #+CATEGORY: debian * test if I refile from elsewhere, it picks ALL items at a level to refile to when I select linux.org. e.g linux.org/general, linux.org/debian, linux.org/test If I then select "general" it also prompts for me now to select "learn org mode". Is this because of some hangover from me using org-mode? In other words I cant refile to linux.org/debian. Wise words appreciated to put me back on track. ___ 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
Re: [Orgmode] [babel] Bug in output PDF with source blocks of unknown language
Hi Sébastien, Sébastien Vauban writes: [...] > * Bug > > You see that when the language is unknown to Org-babel (=Delphi= in this > example), it gets ignored during export, and gets replaced by the previous > code block!! > > So, the current workaround is to take whatever other language know to Babel > (here: =perl=) for the export to (at least) output the right code in the > generated document (even if not correctly highlighted). > Oh, that certainly is a problem! Thanks for reporting I'll take a look. For reference it's being tracked as a bug on our development page here http://eschulte.github.com/babel-dev/TODO-on-export-babel-overwrites-unrecognized-source-blocks.html > > * Other problem > > The selected language must also be known by =listings=... Hence, =R= cannot > be chosen for language; generating otherwise an error when compiling the > LaTeX document. > This should be an easier fix. It is possible to add listings alias by adding an entry to the `org-src-lang-modes' variable. ,[org-src-lang-modes] | org-src-lang-modes is a variable defined in `org-src.el'. | Its value is | (("ocaml" . tuareg) | ("elisp" . emacs-lisp) | ("ditaa" . artist) | ("asymptote" . asy) | ("dot" . fundamental)) | | | Documentation: | Alist mapping languages to their major mode. | The key is the language name, the value is the string that should | be inserted as the name of the major mode. For many languages this is | simple, but for language where this is not the case, this variable | provides a way to simplify things on the user side. | For example, there is no ocaml-mode in Emacs, but the mode to use is | `tuareg-mode'. | | You can customize this variable. ` Best -- Eric > > Best regards, > Seb > > PS- I'll answer your posts shortly (Noweb vs Babel, and incompatibility with > Org-special-blocks). Have had no time up to now... I look forward to your reply when you do have time (no rush) -- notice I've made a slight change to the look of the source names when exported to LaTeX. ___ 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
[Orgmode] [babel] Bug in output PDF with source blocks of unknown language
Hi Eric and Dan, --8<---cut here---start->8--- #+TITLE: Bug in output PDF with source blocks of unknown language #+AUTHOR:Seb Vauban #+EMAIL: n...@one.com #+DATE: 2010-01-13 #+DESCRIPTION: #+KEYWORDS: #+LANGUAGE: en_US * Context Here is a perfectly outputted block of code: #+SRCNAME: srcModifyDBPFI.sql #+BEGIN_SRC sql :tangle srcModifyDBPFI.sql -- add column `rolEngagDateFin' (if column does not exist yet) IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'rol' AND COLUMN_NAME = 'rolEngagDateFin') BEGIN ALTER TABLE rol ADD rolEngagDateFin smalldatetime NULL END GO #+END_SRC Here is an Excel formula (using highlighting of Delphi, being quite similar -- but *unknown to Babel*): #+BEGIN_SRC Delphi (frmDateFin+1)+(frmNbrSem+frmDureeVA*0)*7-1 #+END_SRC and its simplified version: #+BEGIN_SRC perl frmDateFin+(frmNbrSem*7) #+END_SRC * Bug You see that when the language is unknown to Org-babel (=Delphi= in this example), it gets ignored during export, and gets replaced by the previous code block!! So, the current workaround is to take whatever other language know to Babel (here: =perl=) for the export to (at least) output the right code in the generated document (even if not correctly highlighted). * Other problem The selected language must also be known by =listings=... Hence, =R= cannot be chosen for language; generating otherwise an error when compiling the LaTeX document. --8<---cut here---end--->8--- Best regards, Seb PS- I'll answer your posts shortly (Noweb vs Babel, and incompatibility with Org-special-blocks). Have had no time up to now... -- Sébastien Vauban ___ 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
[Orgmode] Re: hitting tab on last number item in list hides next paragraph
Hi Carsten, Carsten Dominik wrote: > On Jan 13, 2010, at 3:11 PM, Sébastien Vauban wrote: >> Eric S Fraga wrote: >>> Carsten Dominik wrote: On Jan 12, 2010, at 3:20 PM, Eric S Fraga wrote: > > with the attached file, if I position the cursor on the 3rd numbered > entry in the first list and hit tab, the following single sentence > paragraph is hidden. This seems somewhat non-intuitive to me or have I > misunderstood something. My impression was that indentation was used to > identify continuing elements in a list or paragraph. Even adding more > blank lines between that 3rd entry and the sentence doesn't make any > difference. > > This is not critical by any means! Just a curious behaviour. Yes, this is a shortcoming of list cycling which I cannot fix. Folding a list item will always fold to the next item and not recognize the end of the item as given by indentation. If you find it too confusing, turn off `org-cycle-include-plain- lists'. >>> >>> I may just do that as I don't often want to hide list entries actually. >> >> I'll do that as well, as I'm always caught when trying to indent correctly >> a list item... >> >> But, indeed, this is a very tiny detail. > > Well, we could consider changing the defualt value for that variable.. I guess it could make sense, yes. BTW, having updated that var for me (right now, in my `.emacs' file), it's OK for properly indenting the first list item, but the others don't move when TABbing. Any reason? Best regards, Seb -- Sébastien Vauban ___ 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
Re: [Orgmode] Re: hitting tab on last number item in list hides next paragraph
On Jan 13, 2010, at 3:11 PM, Sébastien Vauban wrote: Hi Eric and Carsten, Eric S Fraga wrote: Carsten Dominik wrote: On Jan 12, 2010, at 3:20 PM, Eric S Fraga wrote: with the attached file, if I position the cursor on the 3rd numbered entry in the first list and hit tab, the following single sentence paragraph is hidden. This seems somewhat non-intuitive to me or have I misunderstood something. My impression was that indentation was used to identify continuing elements in a list or paragraph. Even adding more blank lines between that 3rd entry and the sentence doesn't make any difference. This is not critical by any means! Just a curious behaviour. Yes, this is a shortcoming of list cycling which I cannot fix. Folding a list item will always fold to the next item and not recognize the end of the item as given by indentation. If you find it too confusing, turn off `org-cycle-include-plain- lists'. I may just do that as I don't often want to hide list entries actually. I'll do that as well, as I'm always caught when trying to indent correctly a list item... But, indeed, this is a very tiny detail. Well, we could consider changing the defualt value for that variable.. - Carsten Thanks, Seb -- Sébastien Vauban ___ 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 - Carsten ___ 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
[Orgmode] Re: hitting tab on last number item in list hides next paragraph
Hi Eric and Carsten, Eric S Fraga wrote: > Carsten Dominik wrote: >> On Jan 12, 2010, at 3:20 PM, Eric S Fraga wrote: >>> >>> with the attached file, if I position the cursor on the 3rd numbered entry >>> in the first list and hit tab, the following single sentence paragraph is >>> hidden. This seems somewhat non-intuitive to me or have I misunderstood >>> something. My impression was that indentation was used to identify >>> continuing elements in a list or paragraph. Even adding more blank lines >>> between that 3rd entry and the sentence doesn't make any difference. >>> >>> This is not critical by any means! Just a curious behaviour. >> >> Yes, this is a shortcoming of list cycling which I cannot fix. Folding a >> list item will always fold to the next item and not recognize the end of >> the item as given by indentation. >> >> If you find it too confusing, turn off `org-cycle-include-plain-lists'. > > I may just do that as I don't often want to hide list entries actually. I'll do that as well, as I'm always caught when trying to indent correctly a list item... But, indeed, this is a very tiny detail. Thanks, Seb -- Sébastien Vauban ___ 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
Re: [Orgmode] [Q]How to use multi-clocks simultaneously?
On Jan 13, 2010, at 2:50 PM, Edmond Halley wrote: Hi, all I am new to orgmode. I wonder whether I can clock the time for multi- task. For example, I have two tasks: A, B. I issue `C-c C-x C-i' on the header of A. It shows like this. * Task ** A xx CLOCK: [2010-01-12 Wed. 21:35] ** B xx But when I issue the same command `C-c C-x C-i' on the header of B. It shows: * Task ** A xx CLOCK: [2010-01-13 Wed. 21:35]--[2010-01-13 Wed. 21:35] => 0:00 ** B xx CLOCK: [2020-01-13 Wed. 21:35] The second time using `org-clock-in' will first clock-out the previous running clock, then start a new one. Though it's instinct that when you time one task, you will keep on working until you finish it. You won't switch to another task when it's timing. How can I use two clock separately for two different tasks? Now, I manually inster those ending timestamp and re-calc the time interver. You cannot, there is only a single clock in Org and you can only add time to a single task. - Carsten Thanks a lot! ___ 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 - Carsten ___ 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
[Orgmode] [Q]How to use multi-clocks simultaneously?
Hi, all I am new to orgmode. I wonder whether I can clock the time for multi-task. For example, I have two tasks: A, B. I issue `C-c C-x C-i' on the header of A. It shows like this. * Task ** A xx CLOCK: [2010-01-12 Wed. 21:35] ** B xx But when I issue the same command `C-c C-x C-i' on the header of B. It shows: * Task ** A xx CLOCK: [2010-01-13 Wed. 21:35]--[2010-01-13 Wed. 21:35] => 0:00 ** B xx CLOCK: [2020-01-13 Wed. 21:35] The second time using `org-clock-in' will first clock-out the previous running clock, then start a new one. Though it's instinct that when you time one task, you will keep on working until you finish it. You won't switch to another task when it's timing. How can I use two clock separately for two different tasks? Now, I manually inster those ending timestamp and re-calc the time interver. Thanks a lot! ___ 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
Re: [Orgmode] hitting tab on last number item in list hides next paragraph
At Wed, 13 Jan 2010 14:18:51 +0100, Carsten Dominik wrote: > > > On Jan 12, 2010, at 3:20 PM, Eric S Fraga wrote: > > > Carsten et al., > > > > with the attached file, if I position the cursor on the 3rd numbered > > entry in the first list and hit tab, the following single sentence > > paragraph is hidden. This seems somewhat non-intuitive to me or have > > I misunderstood something. My impression was that indentation was > > used to identify continuing elements in a list or paragraph. Even > > adding more blank lines between that 3rd entry and the sentence > > doesn't make any difference. > > > > This is not critical by any means! Just a curious behaviour. > > Hi Eric, > > > Yes, this is a shortcoming of list cycling which I cannot fix. > Folding a list item will always fold to the next item and not > recognize the end of the item as given by indentation. Okay, that's perfectly fine. Like I said, not critical at all and you've satisfied my curiosity ;-) > If you find it too confusing, turn off `org-cycle-include-plain-lists'. I may just do that as I don't often want to hide list entries actually. Thanks, eric ___ 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
Re: [Orgmode] hitting tab on last number item in list hides next paragraph
On Jan 12, 2010, at 3:20 PM, Eric S Fraga wrote: Carsten et al., with the attached file, if I position the cursor on the 3rd numbered entry in the first list and hit tab, the following single sentence paragraph is hidden. This seems somewhat non-intuitive to me or have I misunderstood something. My impression was that indentation was used to identify continuing elements in a list or paragraph. Even adding more blank lines between that 3rd entry and the sentence doesn't make any difference. This is not critical by any means! Just a curious behaviour. Hi Eric, Yes, this is a shortcoming of list cycling which I cannot fix. Folding a list item will always fold to the next item and not recognize the end of the item as given by indentation. If you find it too confusing, turn off `org-cycle-include-plain-lists'. - Carsten I am using org 6.34a from git repository as of half an hour ago. Thanks, eric ===File ~/s/test/test.org=== #+TITLE: test file for org mode #+DESCRIPTION: used for bug reports * A headline 1. a numbered list 2. the second entry 3. and another hopefully a new paragraph which separates the lists 1. another numbered list 2. and the second entry 3. and the third and last entry ___ 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 - Carsten ___ 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
Fwd: [Orgmode] Exporting Column view Estimate
Begin forwarded message: From: Carsten Dominik Date: January 12, 2010 6:20:58 PM GMT+01:00 To: Dustin Hoffman Subject: Re: [Orgmode] Exporting Column view Estimate Hi Dustin, On Jan 12, 2010, at 4:37 PM, Dustin Hoffman wrote: Yup, my name really is Dustin Hoffman. Sorry for hooking on to it - I am sure that does get annoying very quickly. When I view this attached file in column mode, it shows the estimates and sums them up for me. When I export to text (ctrl c-e A) I would like to be able to output the estimate table as shown in column-mode. Does this help? Yes. Check you section 7.5.3 of the manual - you need to capture the column view into a table - which is actually a nicer overview than the tree would probably be. Hope this helps. - Carsten On Tue, Jan 12, 2010 at 2:52 AM, Carsten Dominik > wrote: Hi Dustin (Dustin Hoffman? really??? :-) On Jan 11, 2010, at 8:41 PM, Dustin Hoffman wrote: I would like to export an estimate in column view via the text exporter. When I export the file now, none of the hour estimates or summation of estimates is displayed. I am not sure is anyone understands what you are talking about - I certainly don't. Please try to explain again, maybe with an example... ? - Carsten - Carsten - Carsten ___ 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
Re: [Orgmode] Re: org-table and formulas
Thanks for your help Carsten, Stephan and Sébastien. I'm going to take a look at your suggestions and see what I can do. Alan On January 13, 2010 06:59:54 am Carsten Dominik wrote: > Hi Alan, > > I think what you would have to do is to build a lisp function that > creates the full reference by string manipulation, and then calls org- > table-get-remote-range directly to retrieve the result. > > That function returns a string or a list of strings, so conversion > might be needed depending on how you use the result. > > - Carsten > > On Jan 13, 2010, at 12:14 PM, Alan Boudreault wrote: > > Hi Sébastien and thank you for your answer. > > > > The problem with that technique is that I'll have to name ALL the > > cell for ALL the colomn. Here's an example of my table: > > > > #+TBLNAME: FOOD > > > > | Name| Brand | Amounts (g) | Calories | Protein > > | Carbohydrate | Fat | > > |-+---+-+--+- > > > > +--+--| > > > > | Poitrine Poulet | KirkLand | 100 | 100 > > | 24 |0 |1 | > > | Capeli d'angelo| Primo | 85 | 300 | > > > > 10 | 63 |1 | > > > > | Couscous | Clic | 62 | 220 > > | 8 | 46 |1 | > > | Fromage Cottage | Sealtest | 125 | 100 | 15 > > |8 |1 | > > | Ficello | Black Diamond | 21 | 60 > > | 6 |0 |4 | > > | Concombre cru| | 100 | 15 | > > > > 0.65 | 3.63 | 0.11 | > > > > | Clementine cru| | 100 | 47 | > > > > 0.85 |12.02 | 0.15 | > > > > In the table 2, I would like to be able to just set a column to ie. > > 2 (for "Poitrine Poulet"), then I'll be able to get all the info of > > the different columns I need to do my calculs. I see there is also a > > "_" option for row name, but I'm unsure on how to specify the column > > desired with that name and how to get it evaluated if I need to > > concat something... > > > > regards, > > Alan > > > > Sébastien Vauban wrote: > >> Hi Alan, > >> > >> Alan Boudreault wrote: > >>> Here's what I'm trying to do (without success) in my spreadsheet: > >>> > >>> I have a first table : > >>> > >>> #+TBLNAME: table1 > >>> > >>> | ... |... | |...|... > >>> > >>> and a second table: > >>> > >>> #+TBLNAME: table2 > >>> > >>> | line_reference | ... |... | |...|... > >>> > >>> The line_reference is the line number to get some information in > >>> the table1. > >>> So in a cell of the table2, I tried a formula like: remote(table1,@ > >>> $1$3) ($1 > >>> = the line_reference) which of course, didn't work. > >>> > >>> then I tried to use elisp: remote(table1,'(concat "@" $1 > >>> "$3")') but no > >>> success anyway. > >>> > >>> after all, I decided to merge my 2 tables because it looks like I > >>> can use > >>> elisp inside a org function (remote). The last tried formula was: > >>> '(concat > >>> "@" $1 "$3")' ,($1 = the line_reference). The problem of this > >>> formula is > >>> only that I got the string "@2$3" inside the cell and it's not > >>> evaluated as > >>> a formula. > >>> > >>> Could anyone give me some hint to get done what I'm trying to do? > >> > >> What I do, which works: > >> > >> - give a name to the cell in table1 > >> - reference it (in table2) by its name > >> > >> > >> #+TBLNAME: Eau > >> > >> | | Date | Relevé m3 | Consommation | Prix TVAC | > >> | > >> |---+--+---+--+---| > >> | > >> | | [2009-11-15 Sun] | 2072.6263 | 0. | 0.00 | > >> | | [2009-11-22 Sun] | 2074.1774 | 1.5511 | 1.55 | > >> | | [2009-11-29 Sun] | 2076.0834 | 1.9060 | 1.91 | > >> | | [2009-12-06 Sun] | 2077.6757 | 1.5923 | 1.59 | > >> | | [2009-12-13 Sun] | 2079.2140 | 1.5383 | 1.54 | > >> | | [2009-12-20 Sun] | 2081.4222 | 2.2082 | 2.21 | > >> | | [2009-12-27 Sun] | 2083.2146 | 1.7924 | 1.79 | > >> | | [2010-01-03 Sun] | 2085.4916 | 2.2770 | 2.28 | > >> | | [2010-01-10 Sun] | 2087.4283 | 1.9367 | 1.94 | > >> | > >> | ^ | | | | Eau | > >> > >> #+TBLFM: $...@+0$-1-@-1$-1;%.4f::$5=$4*1;%.2f::@2$4=0;%.4f > >> > >> | Énergie | Prix TVAC | > >> |-+---| > >> | Eau | 1.94 | > >> | Gaz |156.81 | > >> | Électricité | 11.64 | > >> |-+---| > >> | Total |170.39 | > >> > >> #+TBLFM: @2$2=remote(Eau,$Eau)::@3$2=remote(Gaz, > >> $Gaz)::@4$2=remote(Elec,$Elec)::@5$2=vsum(@-...@-ii);%.2f > >> > >> Best regards, > >> Seb > > > > ___ > > Emacs-orgmode mailing list > > Please use `Reply All' to send replies to the list. > > Emacs-
Re: [Orgmode] Re: org-table and formulas
Hi Alan, I think what you would have to do is to build a lisp function that creates the full reference by string manipulation, and then calls org- table-get-remote-range directly to retrieve the result. That function returns a string or a list of strings, so conversion might be needed depending on how you use the result. - Carsten On Jan 13, 2010, at 12:14 PM, Alan Boudreault wrote: Hi Sébastien and thank you for your answer. The problem with that technique is that I'll have to name ALL the cell for ALL the colomn. Here's an example of my table: #+TBLNAME: FOOD | Name| Brand | Amounts (g) | Calories | Protein | Carbohydrate | Fat | |-+---+-+--+- +--+--| | Poitrine Poulet | KirkLand | 100 | 100 | 24 |0 |1 | | Capeli d'angelo| Primo | 85 | 300 | 10 | 63 |1 | | Couscous | Clic | 62 | 220 | 8 | 46 |1 | | Fromage Cottage | Sealtest | 125 | 100 | 15 |8 |1 | | Ficello | Black Diamond | 21 | 60 | 6 |0 |4 | | Concombre cru| | 100 | 15 | 0.65 | 3.63 | 0.11 | | Clementine cru| | 100 | 47 | 0.85 |12.02 | 0.15 | In the table 2, I would like to be able to just set a column to ie. 2 (for "Poitrine Poulet"), then I'll be able to get all the info of the different columns I need to do my calculs. I see there is also a "_" option for row name, but I'm unsure on how to specify the column desired with that name and how to get it evaluated if I need to concat something... regards, Alan Sébastien Vauban wrote: Hi Alan, Alan Boudreault wrote: Here's what I'm trying to do (without success) in my spreadsheet: I have a first table : #+TBLNAME: table1 | ... |... | |...|... and a second table: #+TBLNAME: table2 | line_reference | ... |... | |...|... The line_reference is the line number to get some information in the table1. So in a cell of the table2, I tried a formula like: remote(table1,@ $1$3) ($1 = the line_reference) which of course, didn't work. then I tried to use elisp: remote(table1,'(concat "@" $1 "$3")') but no success anyway. after all, I decided to merge my 2 tables because it looks like I can use elisp inside a org function (remote). The last tried formula was: '(concat "@" $1 "$3")' ,($1 = the line_reference). The problem of this formula is only that I got the string "@2$3" inside the cell and it's not evaluated as a formula. Could anyone give me some hint to get done what I'm trying to do? What I do, which works: - give a name to the cell in table1 - reference it (in table2) by its name #+TBLNAME: Eau | | Date | Relevé m3 | Consommation | Prix TVAC | |---+--+---+--+---| | | [2009-11-15 Sun] | 2072.6263 | 0. | 0.00 | | | [2009-11-22 Sun] | 2074.1774 | 1.5511 | 1.55 | | | [2009-11-29 Sun] | 2076.0834 | 1.9060 | 1.91 | | | [2009-12-06 Sun] | 2077.6757 | 1.5923 | 1.59 | | | [2009-12-13 Sun] | 2079.2140 | 1.5383 | 1.54 | | | [2009-12-20 Sun] | 2081.4222 | 2.2082 | 2.21 | | | [2009-12-27 Sun] | 2083.2146 | 1.7924 | 1.79 | | | [2010-01-03 Sun] | 2085.4916 | 2.2770 | 2.28 | | | [2010-01-10 Sun] | 2087.4283 | 1.9367 | 1.94 | | ^ | | | | Eau | #+TBLFM: $...@+0$-1-@-1$-1;%.4f::$5=$4*1;%.2f::@2$4=0;%.4f | Énergie | Prix TVAC | |-+---| | Eau | 1.94 | | Gaz |156.81 | | Électricité | 11.64 | |-+---| | Total |170.39 | #+TBLFM: @2$2=remote(Eau,$Eau)::@3$2=remote(Gaz, $Gaz)::@4$2=remote(Elec,$Elec)::@5$2=vsum(@-...@-ii);%.2f Best regards, Seb -- Alan Boudreault Mapgears http://www.mapgears.com/ ___ 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 - Carsten ___ 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
Re: [Orgmode] Re: org-table and formulas
Hi Alan, seems what you're looking for is some relational database functionality, which is not possible with org spreadsheets :-( Find a possible solution for your problem in the attached org file. You will need org-babel to execute the source blocks. hth, Stephan Also sprach Alan Boudreault: > Hi Sébastien and thank you for your answer. > > The problem with that technique is that I'll have to name ALL the cell > for ALL the colomn. Here's an example of my table: > > #+TBLNAME: FOOD > | Name| Brand | Amounts (g) | Calories | Protein | > Carbohydrate | Fat | > > |-+---+-+--+-+--+--| > > | Poitrine Poulet | KirkLand | 100 | 100 | > 24 |0 |1 | > | Capeli d'angelo| Primo | 85 | 300 | 10 > | 63 |1 | > | Couscous | Clic | 62 | 220 > | 8 | 46 |1 | > | Fromage Cottage | Sealtest | 125 | 100 | 15 > |8 |1 | > | Ficello | Black Diamond | 21 | 60 > | 6 |0 |4 | > | Concombre cru| | 100 | 15 |0.65 > | 3.63 | 0.11 | > | Clementine cru| | 100 | 47 |0.85 > |12.02 | 0.15 | > > In the table 2, I would like to be able to just set a column to ie. 2 > (for "Poitrine Poulet"), then I'll be able to get all the info of the > different columns I need to do my calculs. I see there is also a "_" > option for row name, but I'm unsure on how to specify the column desired > with that name and how to get it evaluated if I need to concat something... > > regards, > Alan > > Sébastien Vauban wrote: >> Hi Alan, >> >> Alan Boudreault wrote: >> >>> Here's what I'm trying to do (without success) in my spreadsheet: >>> >>> I have a first table : >>> >>> #+TBLNAME: table1 >>> | ... |... | |...|... >>> >>> and a second table: >>> >>> #+TBLNAME: table2 >>> | line_reference | ... |... | |...|... >>> >>> The line_reference is the line number to get some information in the >>> table1. >>> So in a cell of the table2, I tried a formula like: >>> remote(table1,@$1$3) ($1 >>> = the line_reference) which of course, didn't work. >>> >>> then I tried to use elisp: remote(table1,'(concat "@" $1 "$3")') >>> but no >>> success anyway. >>> >>> after all, I decided to merge my 2 tables because it looks like I can >>> use >>> elisp inside a org function (remote). The last tried formula was: >>> '(concat >>> "@" $1 "$3")' ,($1 = the line_reference). The problem of this formula is >>> only that I got the string "@2$3" inside the cell and it's not >>> evaluated as >>> a formula. >>> >>> Could anyone give me some hint to get done what I'm trying to do? >>> >> >> What I do, which works: >> >> - give a name to the cell in table1 >> - reference it (in table2) by its name >> >> >> #+TBLNAME: Eau >> | | Date | Relevé m3 | Consommation | Prix TVAC | >> |---+--+---+--+---| >> | | [2009-11-15 Sun] | 2072.6263 | 0. | 0.00 | >> | | [2009-11-22 Sun] | 2074.1774 | 1.5511 | 1.55 | >> | | [2009-11-29 Sun] | 2076.0834 | 1.9060 | 1.91 | >> | | [2009-12-06 Sun] | 2077.6757 | 1.5923 | 1.59 | >> | | [2009-12-13 Sun] | 2079.2140 | 1.5383 | 1.54 | >> | | [2009-12-20 Sun] | 2081.4222 | 2.2082 | 2.21 | >> | | [2009-12-27 Sun] | 2083.2146 | 1.7924 | 1.79 | >> | | [2010-01-03 Sun] | 2085.4916 | 2.2770 | 2.28 | >> | | [2010-01-10 Sun] | 2087.4283 | 1.9367 | 1.94 | >> | ^ | | | | Eau | >> #+TBLFM: $...@+0$-1-@-1$-1;%.4f::$5=$4*1;%.2f::@2$4=0;%.4f >> >> >> | Énergie | Prix TVAC | >> |-+---| >> | Eau | 1.94 | >> | Gaz |156.81 | >> | Électricité | 11.64 | >> |-+---| >> | Total |170.39 | >> #+TBLFM: >> @2$2=remote(Eau,$Eau)::@3$2=remote(Gaz,$Gaz)::@4$2=remote(Elec,$Elec)::@5$2=vsum(@-...@-ii);%.2f >> >> >> Best regards, >> Seb >> >> > > * select from where To execute the source blocks load org-babel and hit "C-c C-C" with point inside the block. The following function implements a simple SELECT-FROM-WHERE clause for remote org-tables: #+srcname: my-select-from-where #+begin_src emacs-lisp :tangle no :results silent (require 'org-babel-ref) (defun my-select-from-where (select-column table-name where-column where-entry) "Get an entry of a remote table with #+TBLNAME: `table-name' using a simple where clause: SELECT select-column FROM table-name WHERE where-column = where-entry `select-column' and `where-column' are zero-based indices (first column has i
Re: [Orgmode] Re: org-table and formulas
Hi Sébastien and thank you for your answer. The problem with that technique is that I'll have to name ALL the cell for ALL the colomn. Here's an example of my table: #+TBLNAME: FOOD | Name| Brand | Amounts (g) | Calories | Protein | Carbohydrate | Fat | |-+---+-+--+-+--+--| | Poitrine Poulet | KirkLand | 100 | 100 | 24 |0 |1 | | Capeli d'angelo| Primo | 85 | 300 | 10 | 63 |1 | | Couscous | Clic | 62 | 220 | 8 | 46 |1 | | Fromage Cottage | Sealtest | 125 | 100 | 15 |8 |1 | | Ficello | Black Diamond | 21 | 60 | 6 |0 |4 | | Concombre cru| | 100 | 15 |0.65 | 3.63 | 0.11 | | Clementine cru| | 100 | 47 |0.85 |12.02 | 0.15 | In the table 2, I would like to be able to just set a column to ie. 2 (for "Poitrine Poulet"), then I'll be able to get all the info of the different columns I need to do my calculs. I see there is also a "_" option for row name, but I'm unsure on how to specify the column desired with that name and how to get it evaluated if I need to concat something... regards, Alan Sébastien Vauban wrote: Hi Alan, Alan Boudreault wrote: Here's what I'm trying to do (without success) in my spreadsheet: I have a first table : #+TBLNAME: table1 | ... |... | |...|... and a second table: #+TBLNAME: table2 | line_reference | ... |... | |...|... The line_reference is the line number to get some information in the table1. So in a cell of the table2, I tried a formula like: remote(table1,@$1$3) ($1 = the line_reference) which of course, didn't work. then I tried to use elisp: remote(table1,'(concat "@" $1 "$3")') but no success anyway. after all, I decided to merge my 2 tables because it looks like I can use elisp inside a org function (remote). The last tried formula was: '(concat "@" $1 "$3")' ,($1 = the line_reference). The problem of this formula is only that I got the string "@2$3" inside the cell and it's not evaluated as a formula. Could anyone give me some hint to get done what I'm trying to do? What I do, which works: - give a name to the cell in table1 - reference it (in table2) by its name #+TBLNAME: Eau | | Date | Relevé m3 | Consommation | Prix TVAC | |---+--+---+--+---| | | [2009-11-15 Sun] | 2072.6263 | 0. | 0.00 | | | [2009-11-22 Sun] | 2074.1774 | 1.5511 | 1.55 | | | [2009-11-29 Sun] | 2076.0834 | 1.9060 | 1.91 | | | [2009-12-06 Sun] | 2077.6757 | 1.5923 | 1.59 | | | [2009-12-13 Sun] | 2079.2140 | 1.5383 | 1.54 | | | [2009-12-20 Sun] | 2081.4222 | 2.2082 | 2.21 | | | [2009-12-27 Sun] | 2083.2146 | 1.7924 | 1.79 | | | [2010-01-03 Sun] | 2085.4916 | 2.2770 | 2.28 | | | [2010-01-10 Sun] | 2087.4283 | 1.9367 | 1.94 | | ^ | | | | Eau | #+TBLFM: $...@+0$-1-@-1$-1;%.4f::$5=$4*1;%.2f::@2$4=0;%.4f | Énergie | Prix TVAC | |-+---| | Eau | 1.94 | | Gaz |156.81 | | Électricité | 11.64 | |-+---| | Total |170.39 | #+TBLFM: @2$2=remote(Eau,$Eau)::@3$2=remote(Gaz,$Gaz)::@4$2=remote(Elec,$Elec)::@5$2=vsum(@-...@-ii);%.2f Best regards, Seb -- Alan Boudreault Mapgears http://www.mapgears.com/ ___ 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
Re: [Orgmode] footnote export fails if footnote indented
On Jan 12, 2010, at 10:37 PM, Dan Davison wrote: If you hit on a footnote definition, it indents it away from column 1, to align with its heading. However, the footnote definition needs to start in column 1 in order for the footnote to be correctly exported. It would be nice if the footnote exported correctly even when indented (or if that's problematic, then a less preferable solution would be having not indent it). Hi Dan, here is a patch that allows footnote definitions to be detached from the left margin. However, I am not sure if it breaks anything else - so extensive testing would be necessary... Also, renumbering footnotes etc will put them back at the margin currently. I am not sure how that should be handled otherwise - Carsten footnote-detach.patch Description: Binary data ___ 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
[Orgmode] Re: org-table and formulas
Hi Alan, Alan Boudreault wrote: > > Here's what I'm trying to do (without success) in my spreadsheet: > > I have a first table : > > #+TBLNAME: table1 > | ... |... | |...|... > > and a second table: > > #+TBLNAME: table2 > | line_reference | ... |... | |...|... > > The line_reference is the line number to get some information in the table1. > So in a cell of the table2, I tried a formula like: remote(table1,@$1$3) ($1 > = the line_reference) which of course, didn't work. > > then I tried to use elisp: remote(table1,'(concat "@" $1 "$3")') but no > success anyway. > > after all, I decided to merge my 2 tables because it looks like I can use > elisp inside a org function (remote). The last tried formula was: '(concat > "@" $1 "$3")' ,($1 = the line_reference). The problem of this formula is > only that I got the string "@2$3" inside the cell and it's not evaluated as > a formula. > > Could anyone give me some hint to get done what I'm trying to do? What I do, which works: - give a name to the cell in table1 - reference it (in table2) by its name #+TBLNAME: Eau | | Date | Relevé m3 | Consommation | Prix TVAC | |---+--+---+--+---| | | [2009-11-15 Sun] | 2072.6263 | 0. | 0.00 | | | [2009-11-22 Sun] | 2074.1774 | 1.5511 | 1.55 | | | [2009-11-29 Sun] | 2076.0834 | 1.9060 | 1.91 | | | [2009-12-06 Sun] | 2077.6757 | 1.5923 | 1.59 | | | [2009-12-13 Sun] | 2079.2140 | 1.5383 | 1.54 | | | [2009-12-20 Sun] | 2081.4222 | 2.2082 | 2.21 | | | [2009-12-27 Sun] | 2083.2146 | 1.7924 | 1.79 | | | [2010-01-03 Sun] | 2085.4916 | 2.2770 | 2.28 | | | [2010-01-10 Sun] | 2087.4283 | 1.9367 | 1.94 | | ^ | | | | Eau | #+TBLFM: $...@+0$-1-@-1$-1;%.4f::$5=$4*1;%.2f::@2$4=0;%.4f | Énergie | Prix TVAC | |-+---| | Eau | 1.94 | | Gaz |156.81 | | Électricité | 11.64 | |-+---| | Total |170.39 | #+TBLFM: @2$2=remote(Eau,$Eau)::@3$2=remote(Gaz,$Gaz)::@4$2=remote(Elec,$Elec)::@5$2=vsum(@-...@-ii);%.2f Best regards, Seb -- Sébastien Vauban ___ 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
[Orgmode] Re: Update ispell-dictionary to text language
Hi Benjamin, Benjamin Andresen wrote: > Sébastien Vauban writes: >> >> Here my proposal (and my very first self-written chunk of ELisp code) for >> switching to the right language for ispell, upon reading the contents of >> the meta-tag `LANGUAGE'. > > I think using File Variables are better for this. For no particular reason > except they are standardized and don't require any additional code in Org > Mode. > (info "(emacs)Specifying File Variables") > # -*- ispell-local-dictionary: "german" -*- I know them, even use them in directories (see `.dir-locals.el'), instead of files. --8<---cut here---start->8--- ((org-mode . ((ispell-local-dictionary . "american") (time-stamp-format . "%:y-%02m-%02d") (time-stamp-start . "^#\\+DATE: +") (time-stamp-end . "$" --8<---cut here---end--->8--- BUT there is a *language specification* in the Org template: --8<---cut here---start->8--- #+TITLE: Scorpios.org #+AUTHOR:Seb Vauban #+EMAIL: n...@one.com #+DATE: 2010-01-13 Wed #+DESCRIPTION: #+KEYWORDS: #+LANGUAGE: en --8<---cut here---end--->8--- ^^ AND it is *used by Org* (at least for the HTML export, and for LaTeX as well I think -- or, in any case, it should use it). Thus, I try to avoid declaring which language is used in the buffer at two different spots, because we can change one and forget to change the other. Therefore, I would like to keep only one language declaration (the one of the Org template, in this case), and get Emacs follow it. Does this make sense? Best regards, Seb -- Sébastien Vauban ___ 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
[Orgmode] Re: org-babel-R and windows ?
Dan Davison stats.ox.ac.uk> writes: > The org-babel default is to invoke R as an external shell command, and I > think this is what is causing the problem. It requires that the emacs > function shell-command can use the string "R" to invoke an R process, > i.e. the R installation and the shell path must be such that this is the > case. Thank you for the information and explanation. It seems that the problem comes from the windows shell. I try the following : I explicitely told emacs to use bash with the following instructions : (setq explicit-shell-file-name "C:/msys/1.0/bin/bash.exe") (setq shell-file-name explicit-shell-file-name) It works with bash. > > #+srcname:trial > #+begin_src R :session org-babel-R-session >c(4,5,6,7,8,9) > #+end_src The "session" way works too. Thank you. ___ 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