>Archive Index
>microsoft.public.xml Archive Home
>Recent entries

[Thread Prev]
>Thread Next - Re: recalculate excel formulas

recalculate excel formulas

From: "krasman" <krasman@-------.--->
To: NULL
Date: 4/28/2009 8:05:00 PM

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

[Thread Prev]
>Thread Next - Re: recalculate excel formulas

>Archive Index
>microsoft.public.xml Archive Home
>Recent entries

Altova Mailing List Archives

recalculate excel formulas