Problematic borders with embedded Excel worksheet

[di...@thecontractorsgroup.com]

Hi All!

I've created an invoice form with several tables and an Excel worksheet
embedded in one of the tables to allow for calculations.

I've set up the table containing the spreadsheet to have invisible
borders and then I've (tried) to set up the spreadsheet to have visible
borders where I need them.

I can get one border on the embedded worksheet to be visible but none
of the other three will become visible no matter how many times I try.

I don't know what to do to make it work. Is it possible to upload the
document here so someone can look at it for me? Or maybe someone is
already familiar with the trouble and can help?
Thank you so very much!!
Diane Dennis

[John McGhie]

Hi Diane:

Word can only display what you do in Excel, unless you paste the item in as
a Word table.

Word's table formatting is more sophisticated than Excel's, there are things
you can do in a Word table you can't do in Excel (and, of course,
vice-versa). Some of the things you can do in Excel (rotated text is one)
will not work in Word.

I suspect that you need to make the changes to the borders in Excel, then
re-embed them.

Hope this helps

On 15/1/05 3:07 PM, in article
1105758297.9...@z14g2000cwz.googlegroups.com,
"di...@thecontractorsgroup.com" <di...@thecontractorsgroup.com> wrote:

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <jo...@mcghie.name>
Consultant Technical Writer
Sydney, Australia +61 4 1209 1410

[di...@thecontractorsgroup.com]

Hi John!

Thank you for your help! :)

I understand that the changes need to be made in the Excel worksheet,
saved and then re-embedded in the Word document...

I've tried again and again and again and I'm now suspecting that it may
be a problem with the Excel rather than Word so please excuse me if it
turns out that I'm in the wrong forum here...

Here's a very primitive drawing of what the embedded excel sheet should
look like:

________________________
|___|_____|____|____|____|
|___|_____|____|____|____|
|___|_____|____|____|____|
|____|____|
|____|____|
|____|____|
---> | | | <---

The problem is the very bottom (currently invisible) horizontal border
line (indicated by the arrows). Every other border shows but no matter
how many times I tell Excel to "make that bottom border visible" it
doesn't work. I even changed the border to be a double-line to see if
that would work but it wouldn't.

Should I jump into the Excel forum for help on this?

Thank you again John!
Diane Dennis

[John McGhie]

Hi Diane:

You should certainly visit the Excel group, however our two finest Excel
exponents also frequent this rowdy barroom, so they have probably seen your
post.

I suspect you are running into a rendering bug in Word, and that your only
solution may be to add a blank row under the line you want to be visible.

I'd be interested to see what the Excel guys have to say.

Cheers

On 16/1/05 9:57 AM, in article
1105829840....@z14g2000cwz.googlegroups.com,

[di...@thecontractorsgroup.com]

Hi John!

Too funny, I actually tried that too... unfortunately it didn't do the
trick, although that could mean simply that I didn't add the line right
or didn't do something else right... ;)

Actually, I added an extra row to the Excel sheet and then hid it but
that didn't work so then I added a second row to the table in Word but
that didn't fix it either...

I'm still suspecting that the trouble is in Excel because when I do a
print preview of the spreadsheet in Excel it has all borders except
that bottom one... Same thing when I do a print preview of the form in
Word (although that part makes sense if the original trouble is in
Excel :)...

Oh, and to clarify something, that picture I "drew" of the form didn't
exactly come out the way I wanted it to, I should have previewed before
posting. It left out a bunch of spaces, the shorter rows on the bottom
(there's four but the last row doesn't have the elusive bottom border)
should be below the longer rows as it shows but also, it should be
aligned to the right instead of to the left. I guess typing lots of
spaces doesn't register in the posting...

Thank you again John for your help and maybe we'll find a fine Excel
exponent willing to have a seat in the barstool between us and join the
discussion... Drinks are on me... ;)

Have a great weekend!
Diane

[Bill Weylock]

Diane -


Maybe you solved this already. Hope so.

I’m not an Excel expert, but I’ve run into quirky behavior importing charts and such. Against a deadline, I believe I was successful at sidestepping the issue by putting a border around the picture space in Word. Could you work around it that way, perhaps – bordering the table cell that contains the embedded spreadsheet?



Best,


 - Bill

Panther 10.3.6
Office 2004
Windows XP Pro SP2
Office 2003