OWC11.Spreadsheet copy error on Server 2003

[Erich Ahlers]

Hi
The followng code works 100% on Windows 2000 server running IIS5 or when IIS
6 runs in 5 compatability mode, but creates and error in IIS6 default mode.

CType(mySheet.Columns(ColNum), OWC11.Range).Copy()

I have followed the "solution" Nick Palmer has published, but with no
success. Surely there must be a solution to this problem.
Any input appreciated.

Erich

 

[Josh Sale]

I work with Nick but I don't think he monitors this news group regularly. I
can tell you that we ultimately rewrote our code to avoid using the Copy
method.

josh

 

[Alvin Bruney [MVP]]

thansk for the update

--
________________________
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

 

[Erich Ahlers]

Hi Josh

Thats unfortunate, as I am using the copy method for replicating columns
across. This means a substantial amount of code needs to be developed to
replicate formats, formulas, etc across my sheet, cell by cell.

Come on Microsoft, you cannot merely change the implementation and then walk
away without assisting the developers!

I challenge any Microsoft engineer to show us here how "easy" a column
replication can be done without making use of copy to the clipboard.

 

[Josh Sale]

Agreed. We feel the same way!

josh