[Orgmode] no SPACE allowed in new node/item name created during refiling

2010-01-13 Thread Manish
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

2010-01-13 Thread Manish
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.

2010-01-13 Thread Samuel Wales
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

2010-01-13 Thread Sébastien Vauban
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

2010-01-13 Thread Paul Mead
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

2010-01-13 Thread Richard Riley
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 ?

2010-01-13 Thread Dan Davison
"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

2010-01-13 Thread John Rakestraw
> 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

2010-01-13 Thread Matt Lundin
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

2010-01-13 Thread Richard Riley
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

2010-01-13 Thread Matt Lundin
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

2010-01-13 Thread Richard Riley
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

2010-01-13 Thread Manish
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

2010-01-13 Thread Paul Mead
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

2010-01-13 Thread Richard Riley


> 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

2010-01-13 Thread Richard Riley

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

2010-01-13 Thread Eric Schulte
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

2010-01-13 Thread Sébastien Vauban
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

2010-01-13 Thread Sébastien Vauban
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

2010-01-13 Thread Carsten Dominik


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

2010-01-13 Thread Sébastien Vauban
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?

2010-01-13 Thread Carsten Dominik


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?

2010-01-13 Thread Edmond Halley
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

2010-01-13 Thread Eric S Fraga
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

2010-01-13 Thread Carsten Dominik


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

2010-01-13 Thread Carsten Dominik



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

2010-01-13 Thread Alan Boudreault
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

2010-01-13 Thread Carsten Dominik

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

2010-01-13 Thread Stephan Schmitt
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

2010-01-13 Thread 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

  



--
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

2010-01-13 Thread Carsten Dominik


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

2010-01-13 Thread Sébastien Vauban
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

2010-01-13 Thread Sébastien Vauban
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 ?

2010-01-13 Thread d . tchin
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