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 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+unsubscr...@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