running out of memory with copy and paste

[Rod]

Hi,

We are doing a lot of copying and pasting using the owc spreadsheet
component and we find that before long the script errors out.

If we copy/paste a samll number of rows then everything is ok, but fails
when we have a large number of rows.

This looks like a bug, are there any any tricks/workarounds to reset/reclaim
memory?

Thank you

 

[Alvin Bruney [MVP - ASP.NET]]

I'd imagine - and this is just a guess - that the clipboard handle is still
open after the copy. Why don't you try closing and flushing the handle after
each paste. How? hmmm, one way is to tie into one of the copy events and
then flush the clipboard by doing a copy of an empty cell. Copying the empty
cell would then flush the clipboard. That is seriously cheesy though, but it
is all i can think of at the moment.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

 

[Rod]

Thanks Alvin,

So far it seems that your suggestion works, in onve version of the browser
that i tested but not in another


IE version that does not work 6.0.2900.2180.xpsp_sp2_gdr.050301-1519
sp2

IE version that does work: 6.0.3790.1830 sp1

I'd imagine - and this is just a guess - that the clipboard handle is still
open after the copy. Why don't you try closing and flushing the handle after
each paste. How? hmmm, one way is to tie into one of the copy events and
then flush the clipboard by doing a copy of an empty cell. Copying the empty
cell would then flush the clipboard. That is seriously cheesy though, but it
is all i can think of at the moment.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

Hi,

We are doing a lot of copying and pasting using the owc spreadsheet
component and we find that before long the script errors out.

If we copy/paste a samll number of rows then everything is ok, but fails
when we have a large number of rows.

This looks like a bug, are there any any tricks/workarounds to
reset/reclaim
memory?

Thank you

 

[Alvin Bruney [Microsoft MVP]]

kinda wierd, if you think that this is a bug, i'd be more than willing to
submit it to product support on your behalf.

--
Regards
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc
--------------------------------------------------

Thanks Alvin,

So far it seems that your suggestion works, in onve version of the browser
that i tested but not in another


IE version that does not work 6.0.2900.2180.xpsp_sp2_gdr.050301-1519
sp2

IE version that does work: 6.0.3790.1830 sp1

I'd imagine - and this is just a guess - that the clipboard handle is
still
open after the copy. Why don't you try closing and flushing the handle
after
each paste. How? hmmm, one way is to tie into one of the copy events and
then flush the clipboard by doing a copy of an empty cell. Copying the
empty
cell would then flush the clipboard. That is seriously cheesy though, but
it
is all i can think of at the moment.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

Hi,

We are doing a lot of copying and pasting using the owc spreadsheet
component and we find that before long the script errors out.

If we copy/paste a samll number of rows then everything is ok, but
fails
when we have a large number of rows.

This looks like a bug, are there any any tricks/workarounds to
reset/reclaim
memory?

Thank you