[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: Using dsum across sheets



On Sun, 2004-01-25 at 15:35, Mike Perry wrote:
> Thus spake Andreas J. Guelzow (aguelzow taliesin ca):
> 
> > On Sun, 2004-01-25 at 14:07, Mike Perry wrote:
> > > Ugh... So there's no hack that can be done to get the elements in this
> > > row into a column then (maybe via Lookup, et al)? I just have to keep
> > > it in a row? That's not so nice..
> > > 
> > > I'm not averse to writing a python plugin or something to get this done,
> > > but I'd need a hint on the right direction I'd want to head in with
> > > that.
> > 
> > I must have missed the beginning of this thread, but what exactly are
> > you trying to accomplish?
> 
> The beginning of the thread has appeard on the archives:
> http://mail.gnome.org/archives/gnumeric-list/2004-January/msg00058.html

I guess replacing sleep with helping a dog having puppies did affect my
thinking... 


> I've run into another problem, though. It seems as though there is no
> Time type that can easily represent large amounts of elapsed time..
> Something that could do days, hours, minutes would be nice. Or maybe
> even a way to lift the 0-23 restriction on the hours portion of hh:mm?

[h]:mm should do it

> 
> 
> Oh, and one more question, instead of saying JobTranspose!$A1$1:$Z$3, is
> there a shortand to select the whole table in a range?

you could define a name to refer to that table and then use the name
instead.

Andreas
-- 
Prof. Dr. Andreas J. Guelzow
Dept. of Mathematical & Computing Sciences
Concordia University College of Alberta

Attachment: signature.asc
Description: This is a digitally signed message part



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]