Re: [libreoffice-users] autofill in calc

Hi :)
i guess different people might expect different patterns.  Most of the ones
given in Gary's post make total sense to me.  Generally i avoid leaving it
to any spreadsheet program to try to guess what pattern i want.  Usually 3
values is enough to define a simple arithmetic progression but 4 values is
helpful to just make absolutely certain.

I think you can go into the configurations to define ones you personally
commonly use.  For example when i tried studying fractal dimensions and
chaos theory it might have been handy to have some interesting ones just to
see my lecturer raise his eyebrows.  Now i just live in permanent chaos and
never expect patterns to work out for me.
Regards from
Tom :)




On 16 September 2014 13:04, Brian Barker <b.m.barker@btinternet.com> wrote:

> At 12:25 16/09/2014 +0100, Gary Collins wrote:
>
> > I've been using autofill and noted some things, not so much bugs but
> > queries about the way it works and if it could be better.
>
> No answer to your general points, but a few comments:
>
>  9) starting with a single cell, say, 2 in B1, and extending using
> > autofill, the 2 is incremented to 23,4,5.... etc., i.e. there is an
> > assumption that the increment should be 1.
> > Strictly speaking, it should be 0, since a single value doesn't have an
> > incremental value. To obtain a column containing the same figure in all
> > cells, it is necessary to enter the same value twice into adjoining cells.
>
> Two points here:
> o It is generally bad practice to repeat the same value a number of times:
> it can be a recipe for mistakes. If you need the same value in multiple
> rows, it should appear in any necessary formula either as a constant or a
> reference to single cell elsewhere. Having it in a separate cell also makes
> it easier to modify, if that becomes necessary.
> o If you really do want to autofill cells without increment, you can do so
> by holding down Ctrl whilst dragging the fill handle.
>
> In addition, you can do cleverer things by first selecting the result
> range and then using Edit | Fill > | Series... .
>
> I trust this helps.
>
> Brian Barker
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted