mike scott wrote:
On 9 Dec 2005 at 10:41, CarlP wrote:
WinXP Home, OO 2, Athlon 1.7GHz
Folks, I've yet to get any help on this, and it'll make or break my
ability to use OO for our organization. BTW, I'm a staff of one
part-timer, and I've burned a lot of time on this already.
My problem is with hiding or collapsing certain address lines when there
is no data in that field. I've read a ton about how to do this (using
the Hidden Paragraph function with a "not" or "!" or "NEQ" condition)
but the "hidden" line remains hidden whether or not there is data in the
field on that line. So it seems like hiding works, but the condition
does not. There's no other info on that line (e.g. no other fields, no
other text, no spaces, etc.).
I'm no expert, but if no-one else has replied........
I've just tried making a trivial mail-merge document, which I assume is
where you're coming from. I've put one database field from my address
list on each line, and made each line a separate /section/ ( select
line, then Insert|Section). I've used format|section to set each
section to be hidden with a condition like
Addresses.Sheet1.Address2 eq ""
This appears to have the required effect - at least, if I run the
mailmerge wizard and preview for each record, lines come and go in a
reasonable way.
OTOH, I commented quite a few months ago on this list that I felt this
was all long-winded, opaque and inflexible. Didn't have much effect
though :-)
Is this the sort of thing you're doing?
OK, Mike, I've tried this and I'm afraid I'm doing something wrong here.
I add merge fields to the document, then highlight a given line and
add a section break. This adds a new line to the document between the
first line and the second, which has the section break. Next, I select
Hide in the section formatting dialog and add the condition
tempdata.Sheet1.Bus/Org eq "" and have also tried not
(tempdata.Sheet1.Bus/Org). Neither works; when I do this, the section
with the field I'm trying to hide doesn't hide even when there's no data
in the field.
What's more, I end up with extra blank lines where I've added section
breaks but not put any conditions on them. Odd. Any suggestions about
what I might be doing wrong here? Anyone care to send me a sample file
and data source so I can see what you've done?
Thanks,
Carl
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
