recalculate excel formulas

[krasman]

hi,

i have an excel file with two sheets: sheet1 and sheet2. let's say that
sheet1 cell A1 has a value. in sheet2, cell A1 there's a formula, something
like Sheet1!A1 + 10. so, if i put 10 in sheet1, sheet2 should have 20. in
excel 2007 this is a basic formula, and it works perfectly. however, i want
to do the same thing using open xml sdk 2.0. i can insert values in sheet1,
cell A1, but the sdk doesn't recalculate the value of sheet2, A1. using
mycell.CellValue.Remove(), the formula is updated when i open excel. but i
need do do this directly using sdk and not excel. something like:

my function()
insert value in sheet1, A1
do some processing
get value from sheet2, A1 -> this gives the wrong value
more processing
end function

can you help me?

thanks

kras

[Neil Smith [MVP Digital Media]]

Hi krasman - you're in the wrong newsgroup ;-)

This one is for XML (the tag-based, HTML like thing) and you meant to
post in I imagine microsoft.public.xls (rather than the similar group
microsoft.public.xsl which is a processing language for XML files)

HTH
Cheers - Neil

On Tue, 28 Apr 2009 20:04:32 +0100, "krasman" <kra...@hotmail.com>
wrote:

------------------------------------------------
Digital Media MVP : 2004-2009
http://mvp.support.microsoft.com/mvpfaqs

[kt bott]

"krasman" <kra...@hotmail.com> wrote in message
news:uMKvrQDy...@TK2MSFTNGP02.phx.gbl...