Where did my formulas go?

Question

My scenario...
1. Read in template.xls.
2. Write data to worksheet within template.xls
3. Calculate
4. workbook.Saveas("newfilename.xls")
5. Open newfilename.xls in Excel
6. calculated cells contain the right numbers but the formulas have gone?

Is this by design?

Administrator · Answer

This is by design. After a calculation, the value of a formla is returned. If you want to save the formulas back out, then you will have to reset them. Here is a little sample showing one way to do this.

http://www.syncfusion.com/Support/user/uploads/Calculate_Excel_db444299.zip

Brian J. Burnett · Answer

you don''t happen to have this in vb for us old timers?

>This is by design. After a calculation, the value of a formla is returned. If you want to save the formulas back out, then you will have to reset them. Here is a little sample showing one way to do this.
>
>http://www.syncfusion.com/Support/user/uploads/Calculate_Excel_db444299.zip
>

Administrator · Answer

Here is a VB prject.

http://www.syncfusion.com/Support/user/uploads/Calculate_Excel_VB_ef1872af.zip