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

 

[kt bott]

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