On Wed, 2006-02-15 at 10:52 +0200, Vincent de Klerk wrote: > Hi, > > Part of my work requires me to create table content that I import into > a dB that I built for Clients or for updating our company's dB. Some > of the data columns are sequences of alphanumeric codes, e.g.. Product > Numbers. By example, the sequences normally start with say aa, ab, ac, > ad, ...., zx, zy and zz but, I have found that Calc only repeats the > sequence typed and the Auto Fill feature tells me that the sequence is > invalid. > > Has someone found a workaround for the fill function in OOo 2.0 that > can recognise and complete the sequence by drag handle? > > I would like to continue using OOo and support OOo but, until I find a > solution to the Auto Fill I will be using M$ Excel for the tables as I > am not coding the codes by hand. > > Kind Regards, > I think "TOOLS > OPTIONS > OpenOffice.org Calc > SORT LISTS" may be what you are looking for. It allows you to create a custom list to be completed using the drag handle. To try a default list, type sun in A1 of a blank sheet and drag down.
The help reference says "Only text can be used for sort lists,no numbers." This is not correct, alpha-numeric values can be used, they are just treated as text values. Barrie --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
