bg wrote:
On Mon, 2007-08-27 at 09:00, Dan Lewis wrote:
On Monday August 27 2007 09:42 am, bg wrote:
This may be a Base feature only, but seems like Calc should
have a means of doing it. I want to increment a numerical field
(all in the same column as it happens) containing whole numbers,
varying from 0 to 99 - and increment them by one.
Does this require writing a macro? I've searched extensively though the
help pages and can find nothing, so far, that might do it.
Running OOo 2.0 under Fedora Core2
Yeah, I know. A little behind. But Core2 seems to still have most
everything I need :-)
Thanks,
Brewster Gillett
Highlight the 100 cells you want to number. Then use
Edit > Fill > Series to open the Fill Series window. Enter your Start
value, End value, and Increment. Click OK. That should do it. It works for
a row of cells just as it does for a column.
bg:
It doesn't seem to work, and maybe I was unclear on the objective.
I'm looking at about a 440-row sheet of names and addresses - one
entry per row. The columns are of course name, phone, email and
so forth. One of those columns tracks how many times each of the
440 people has received the periodic mass emailing. The reason I do
that is because once they've had a given number of mailings without
response, I drop them from the list.
When I send a notice, I send it to all 440. So that means each time
I send one out, I need to increment *every one* of the whole numbers
in that column by *one*, and one only. The numbers that exist
already in the columns will range from 1 to 5, typically. And
all I want to do is increment *each* of those numbers by one.
In other words, where a column presently contains a "3",
the global increment I perform should change it to a "4".
The sequence you recommend does not do that. On the first try, it
changed the data in that column to reflect the spreadsheet's line
numbers. I found that mondo bizarre! On the second try, it
keyed on the first row's "3" and changed *all* rows to read "3".
Part of the difficulty I'm having with that is that it is
non-obvious what is meant in the "Fill Series" window by
"Direction", and by "Series type", nor does the "Time unit"
section appear to bear on what I am attempting. Ditto the
"Start value" and "End value" - I can't see how those could
apply to the specific function I am trying to perform.
Side question for you, as I know you're one of the most
knowledgeable people on the list - the Office Help Search
(the only one I can find that produces a dropdown with a
search term window) doesn't seem to be hooked to anything - not only
did it not find "Fill", but it didn't even find "Edit".
I'm conditioned to always RTFM before yelling for help,
but it's a little tougher when the Help Search function doesn't
seem to want to work for me:-)
Thanks,
Brewster Gillett
Hi Brewster,
A macro could do both jobs for you; increment the quantity and delete the
maxed-out rows. I would flag them and use the mail merge options to ignore those
rows, but I never throw anything away (check my basement). A simpler method
would be to fill a column with the formula =g1+1 (given that the count is in
column 'g'. After each mailing, copy that column and use 'edit / paste special'
with 'formulas' unchecked and 'numbers' checked to update the count.
tc
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
