Re: "Fill down" and numeric integration

[Jean Bréfort <jean brefort normalesup org>]

Le mardi 13 février 2007 à 13:43 -0700, Adam Ginsburg a écrit :
> Thanks, but there doesn't seem to be an option to fill in the same
> fashion I'm talking about.  I have formulas with sometimes multiple
> cell references, and dragging the bottom corner fills them alright,
> but the "Edit:Fill:Series" menu only provides options for incremental
> fill.  Am I just missing options?  I thought I tried everything.  It
> seems that the "Enter into cells:" option might have something useful
> in it, but it currently says "Values" and is greyed out so I can't
> change the option, and I can't figure out how to enable that menu.

You can fill with arithùetic or geometric progressions (something as 1,
2, 4, 8,...)
The combo box is used for other data operations, try a command in
Tools/Statistical Analysis. In the series case, it was not judget useful
to enter formulas (as =previous+increment) 

> BTW, you're right, it's simple enough to do numeric integration on my own.
>
> Thanks,
> Adam
>
> On 2/13/07, Jean Bréfort <jean brefort normalesup org> wrote:
> > Le lundi 12 février 2007 à 10:24 -0800, keflavich a écrit :
> > > I have two mostly separate questions that google and many forum searches were
> > > unable to provide the answer for.
> > >
> > > First, is there any equivalent to the XL "fill down" and "fill right"
> > > commands in Gnumeric?  I know you can drag the lower right corner of a box
> > > to fill, but that's a huge pain when I'm working with thousands of cells,
> > > most of which are off screen.  Dragging a selection box has also had
> > > unpredictable effects at times (e.g. scrolling 4000 cells then stopping).
> >
> > you have a menu for that: Edit/Fill/Series
> >
> > > Second, is there any way to do numeric integration in Gnumeric?  Are there
> > > any plugins to do integrals?  I'm guessing not, since I couldn't find any,
> > > but maybe I don't know where to look.
> >
> > Not that I know, but it should be easy to add one (or several). Anyway,
> > you should be able to do that with the existing functions.
> >
> > Regards,
> > Jean
-- 
Jean Bréfort <jean brefort normalesup org>