Re: [libreoffice-users] calc autofill

On Sun, 10 Sep 2017 14:10:34 +0200
Philip Jackson <philip.jackson@nordnet.fr> wrote:

> On 10/09/17 11:09, Gary Collins wrote:
> > Hi
> > Ive noticed what appears to be an anomaly when using autofill (hope
> > thats the right word) in calc 5.2.2.2 in ubuntu 16.10
> >
> > To illustrate, open a new spreadsheet and enter 1 in A1 and in C1,
> > and "A1" in D1 and F1.
> >
> > Select range A1:F1 and fill down to row 2.
> >
> > Then A2, C2 contain 2 and D2, F2 contain "A2"; note the strings
> > have been "incremented" as well as the numbers.
> >
> >
> > Undo the fill, hide columns B and E, select range A1:F1 and fill
> > down to row 2.
> >
> > Now A2, C2 contain 2 as expected but D2, F2 contain "A1"; the
> > strings have not been "incremented.
> >
> > Does anyone else experience this? It seems véry strange to me but
> > perhaps there is a good reason for it?  
>
> Yes, I can reproduce that with Calc 5.1.6.2

FWIW, I can reproduce it with 5.3.3.2 also

> and depending on what is
> highlighted when I unhide the columns, the ongoing autofill is very
> variable.
>
> Can't say I've noticed that before but then it doesn't fall within the
> type of spreadsheet jobs I do.
>
> Philip


-- 
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