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]
