[O] Org spreadsheet formula range destination and per-cell placement for Lisp

[Paul Michael Reilly]

I am in the throes of setting up an Org mode spreadsheet for an
invoicing/status/planning tool and came across this fabulous thread: *[O]
org table calc and lisp for hh:mm
timetable
 *at http://lists.gnu.org/archive/html/emacs-orgmode/2011-03/msg00972.htmlwhich
provided me much of what I need.  So thanks to all involved for that
excellent piece of work.

The one problem I am having trouble grasping is in how to use Emacs Lisp to
generate a range of values automagically.  I have no trouble with a single
cell using Lisp and passing in a rectangular region to process or in
setting up a region using the Org table/spreadsheet/calc support described
in the various Google accessible documentation.

What I am trying to do at a high level is setup a table with rows of
actions spanning a start and stop time.  Each action row has a bill-to
category column.  In the table, as part of a Lisp based formula, I want to
process these action rows and build a list of "bill-to : total time"
summary values and then place these summaries in a range in the table, so a
fragment of the table might look like:

... | Client1 | Client2 | Commute | ...
... |  12.50  |  22.00  |  10.5| ...

where the numbers (hours)  have been summed by filtering the task rows by
clients.  Hope that's clear.

So there are essentially two issues for me:  the first is understanding how
to associate a range destination for a Lisp based formula result, which I
think can be done, I just do not understand how to do it yet, and second,
probably an enhancement request, is to figure out how to pass a list of
cell addresses to a List form (along with other data) and have the form
compute and store values to those cells.  The latter would a sort of holy
grail, at least for me.

Thanks,

-pmr

[Orgmode] Preventing line breaks in (HTML) published description lists

[Paul Michael Reilly]

I added a plain list to my file:

...
  - term1 :: this means something
  - term2 :: this means something else
  - term3 :: and something different still
...

fully expecting the term and the description rendered in HTML to be on 
the same line as is shown in the Latex published Org Mode manual.  But 
the items were rendered as:


...
  term1
  this means something
  term2
  this means something else
  term3
  and something different still
...

I suspect this might be an HTML artifact, nevertheless, how would I 
convince org-mode to arrange for the HTML rendering to attempt to keep 
the terms and descriptions on the same line?  An example or reference 
would be much appreciated.


Thanks,

-pmr



___
Emacs-orgmode mailing list
Remember: use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode

[Orgmode] Re: Preventing line breaks in (HTML) published description lists

[Paul Michael Reilly]

On 07/05/2009 09:33 AM, Bernt Hansen wrote:

Paul Michael Reilly  writes:

   

I added a plain list to my file:

...
   - term1 :: this means something
   - term2 :: this means something else
   - term3 :: and something different still
...

fully expecting the term and the description rendered in HTML to be on
the same line as is shown in the Latex published Org Mode manual.  But
the items were rendered as:

...
   term1
   this means something
   term2
   this means something else
   term3
   and something different still
...

I suspect this might be an HTML artifact, nevertheless, how would I
convince org-mode to arrange for the HTML rendering to attempt to keep
the terms and descriptions on the same line?  An example or reference
would be much appreciated.

Thanks,
 


Adding this seems to work:

#+STYLE:dt {clear: left; float: left; width: 4em; 
}

-Bernt
   
Well it's a start but does have some side effects.  For example with 
each new entry it becomes more and more apparent that the term and the 
description are off center, i.e. the skew becomes more pronounced.  But 
your solution is much better than mine :-) and gives me a place to 
explore and become smarter, always a good thing!


Thanks again,

-pmr

___
Emacs-orgmode mailing list
Remember: use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode

Re: [Orgmode] Preventing line breaks in (HTML) published description lists

[Paul Michael Reilly]

On 07/06/2009 06:46 AM, Sebastian Rose wrote:

Paul Michael Reilly  writes:
   

I added a plain list to my file:

...
   - term1 :: this means something
   - term2 :: this means something else
   - term3 :: and something different still
...

fully expecting the term and the description rendered in HTML to be on the same
line as is shown in the Latex published Org Mode manual.  But the items were
rendered as:

...
   term1
   this means something
   term2
   this means something else
   term3
   and something different still
...

I suspect this might be an HTML artifact, nevertheless, how would I convince
org-mode to arrange for the HTML rendering to attempt to keep the terms and
descriptions on the same line?  An example or reference would be much
appreciated.
 



Don't use a definition list at all:

- *term1* this means something
- *term2* this means something else
- *term3* and something different still



Sebastian
   
FWIW, this solution is better than using a CSS style based solution but 
it had the nit that the bullet (o) is present in the output (of course) 
where the description list had no bullet.


After playing around with this a bit I decided that your point, don't 
use a description list, is well taken.   I wound up using a simple table 
instead and got very satisfying results.


Thanks,

-pmr

___
Emacs-orgmode mailing list
Remember: use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode