OWC Spreadsheet ignores Top and Left settings on page?

[308gv]

Hi
I have built a small aspx page to upload data using client side Excel
OWC to a sql database. Everything works, thanks to the advice in this
group (I am about to buy Alvin's book to make future use easier
The problem is that the Excel object keeps moving itself to top left of
page regardless of what I set Top and Left to. It does display in
proper location if the page is by itself, shifts if I use the page in a
frame (My aspx app uses tabbed pages to simplify the UI).
My environment is XP SP2, ASP.NET 1.1, IE 6 using VS 2003 to build the
application.

Any hints gratefully accepted.

Gerrit

 

[308gv]

Typical, I spent a full day puzzling over this, I ask in a public forum
and bingo, within an hour I figure it out myself
The problem is due to use of smartNavigation. Once I set the page that
contains the iFrame to smartNaviagtion=False, the poblem goes away.

Gerrit

 

[308gv]

Spoke too soon, the problem goes away if I refresh the page after it is
loaded. It is wrong when first loaded so any hints still appreciated.

Gerrit

 

[Alvin Bruney [MVP]]

I was quite shocked that you reported fixing it. I can honestly say I spent
around 2 days (no exageration) trying to make this work. Long story short,
the issue got directed to the excel spreadsheet lead at Microsoft who
pledged to fix it and another related spreadsheet border bug for version 11.
Version 11? same story, no fix. That's all I can say.

The workaround is to position a div tag and write the spreadsheet into the
div tag. It should stay put.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin

 

[308gv]

Hi Alvin,
you are a life saver the <div> trick did the job.
(and your shameless author plug works, I ordered your book yesterday!)
Regards,
Gerrit