We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Where did my formulas go?

Thread ID:

Created:

Updated:

Platform:

Replies:

38552 Dec 14,2005 10:34 PM UTC Dec 15,2005 05:06 PM UTC WinForms 3
loading
Tags: Calculate
Brian J. Burnett
Asked On December 14, 2005 10:34 PM UTC

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 [Syncfusion]
Replied On December 15, 2005 01:10 AM UTC

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
Replied On December 15, 2005 08:05 AM UTC

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 [Syncfusion]
Replied On December 15, 2005 05:06 PM UTC

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

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;