I'm working with Infragistics3.Documents.Excel.v11.1 (v11.1.20111.2050)
I have a workbook with n worksheets with cells with formulas (formulas referenced to other worksheets).Can I Recalculate only one worksheet and save cell values to another worksheet of another workbook??
How can I do that?
Thanks in advance
Hello,
I have created CAS-92459-SBGFRK and submitted a product idea on your behalf.
Recalculating a worksheet only is not supported. Currently you can only recalculate the entire workbook by calling its Recalculate() method, which is only needed if the CalculationMode is not Automatic. I have forwarded this post to the Developer Support Manager to create a feature request on your behalf.
As far as your other question, I believe I have answered that here: http://community.infragistics.com/forums/p/69644/352724.aspx#352724 If that does not answer your question, please let me know and I will try to provide more information.