OWC10 spreadsheet performance

[Raj]

i have a complex spreadsheet with calcuation, i save it in XML spreadsheet
using 2002 excel, the xml file is 2 mb. Now when i calculate using owc10
component system takes approx 8 seconds to process it, is there any way i can
decrease this time.

thanks
raj

 

[Alvin Bruney [Microsoft MVP]]

One thing you can do is tailor the calculation to affect only the required
range instead of the entire spreadsheet. That reduces the expense of the
calculation engine.

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

 

[raj]

how do we do that ???

One thing you can do is tailor the calculation to affect only the required
range instead of the entire spreadsheet. That reduces the expense of the
calculation engine.

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

i have a complex spreadsheet with calcuation, i save it in XML spreadsheet
using 2002 excel, the xml file is 2 mb. Now when i calculate using owc10
component system takes approx 8 seconds to process it, is there any way i
can
decrease this time.

thanks
raj