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 <[email protected]> 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: [email protected] > 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: [email protected] 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
