Clac: Auto Fill not working
Excel has something called Concatenation. You have 2 cells that become one value. One could be a number or value which would auto-fill. Such as Johnny1 would autofill to Johnny2. You can also create a custom series such as A,B, C. You could have one cell do the series, a second cell do the names. A thrid cell would have the concatenation to make it all one word. Then you would use paste values to replace the formula with the value sot he data never changes. Is use this precedure to create unique ID. I take the persons last name (from imported list) and the last 4 digits from their Social security number to create a unique comuter ID. This doenst take very long as I import all the lists and I can do several thousand at once. Does Open office have a similar function? It would not have to take macro programming. Roxann Milby Wing B Office Admin -----Original Message----- From: Johnny Andersson [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 15, 2006 5:50 AM To: [email protected] Subject: Re: [users] Clac: Auto Fill not working Does this really work in Excel? What happens in Excel if I enter something like "Johnny" in a cell and try the autofill function? Will then the next cell contain "Johnnz"? In Calc, autofill seems to work only with numbers. A7, A8, A9, A10 and so on. Things like A1A doesn't seem to work either... I can only think of one, maybe somewhat complicated, workaround: Write your own cell function and use it to calculate the next value, let's say NEW_VALUE(OldValue;Step). When you got the cell function to work properly, then enter the first number in, let's say, A1. In A2 enter: =NEW_VALUE(A1;1) Then use autofill from A2 and down. Then A3 will contain =NEW_VALUE(A2;1) and so on. The only problem in this case will probably be to make the new function to work properly, I don't even know if you are familiar with programming macros in OOo. Johnny Den 2006-02-15 09:52:13 skrev Vincent de Klerk <[EMAIL PROTECTED]>: > 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, > > Vincent de Klerk > Director > Enje Funda Consulting (Pty) Ltd > Tel: +27 16 423 2510 > Mobile: +27 83 449 2239 > mailto:[EMAIL PROTECTED] > > > ---------------------------------------------------------------------- > ------ > ---- > The e-mail and attachments are confidential and intended only for > selected > recipients. If you have received it in error, you may not in any way > disclose or rely on the contents. You may not keep, copy or distribute > the > e-mail. Should you receive it, immediately notify the sender of the error > and delete the e-mail. Also note that this form of communication is not > secure, it can be intercepted, and may not necessarily be free of errors > and > viruses in spite of reasonable efforts to secure this medium. > > ---------------------------------------------------------------------- > ------ > ---- > > > > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.1.375 / Virus Database: 267.15.5/256 - Release Date: > 2006/02/10 -- Johnny --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
