On Tue, 2005-10-04 at 21:22 +0100, Paul Smith wrote: > On 10/4/05, Jonathon Coombes <[EMAIL PROTECTED]> wrote: > > > > you can find the option you are looking for here: Edit I Fill I Series I > > > > ... > > > > >> Is there some automatic way of filling down a column with > > > > >> > > > > >> a > > > > >> b > > > > >> c > > > > >> d > > > > >> e > > > > >> f > > > > >> . > > > > >> . > > > > >> . > > > > >> z > > > > >> > > > > > > > > > > I forgot to specify that I am referring to Calc. > > > > > > Thanks, Tina, but apparently it only works for numbers and not for > > > letters. > > > > Have a look in the help under "Sort Lists" for non-numerical fills. > > That is funny: in my Fill Series dialog, there is no AutoFill option, > contrarily to what the Help asserts. (Running OOo 1.9.125.) Therefore, > your suggestions do not work.
My suggestion does work, but I do not use the AutoFill my self. Make sure you have a sort list defined for the alphabet sequence. Once that is defined (Tools -> Options -> OOo Calc -> Sort Lists) you can start your sequence a,b,c etc and then simply drag it out to get the rest. Regards Jonathon -- OOo Tips: http://mindmeld.cybersite.com.au/tips.rss OOo Knowledgebase: http://mindmeld.cybersite.com.au Training4Linux: http://www.training4linux.com Cybersite Consulting: http://www.cybersite.com.au --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
