Saturday, March 9, 2013

yogi_On Replicating A Pattern In A Google Spreadsheet -- spreadsheet locale United States


                                          Google Spreadsheet   Post  #1073
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Mar 9, 2013
user Veryblacklabel :(http://productforums.google.com/forum/?zx=nbznyz1cryoz#!category-topic/docs/spreadsheets/pFYzfJkLScA)
Auto-fill in spreadsheet not working
Chrome/XP

Hey girls and guys,

I'm trying to use the 'Auto-fill' in a spreadsheet but Auto-fill does not recognize a pattern. Doesn't matter if I set language in Dutch or English or if I fill in the words in Dutch or English. A very simple pattern:
Monday
Tuesday
Wednesday

or

January
February
March

Just copies the words instead of continuing the series.

Greetings,

Johny
--------------------------------------------------------------------------------------------------------------------
in the following discussion, I talk about the need to establish a pattern by selecting entries in a minimum of two cells ... however for the pattern to be successfully replicated it needs to have been stored by Google internally for the related spreadsheet locale


now let me present here a spreadsheet with the locale as netherlands -- you will notice that not all the patterns that could be replicated in the spreadsheet with United states as the locale, can be replicated in the spreadsheet with Netherlands as the locale