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.
Unfortunately, activation email could not send to your email. Please try again.

Formula not work (2)

Thread ID:

Created:

Updated:

Platform:

Replies:

19816 Oct 4,2004 08:12 PM Nov 23,2004 09:45 AM Windows Forms 3
loading
Tags: XlsIO
Vu Dang Quang
Asked On October 4, 2004 08:12 PM

Hi! Stephen Can you tell me how to make excel refresh value after saving without using Excel automation. For example: I''''ve file excel name is "Test.xls". In this file i have A10 range is : "=SUM(A1:A9)". I''''ve opened "Test.xls" using RWExcel component and change value of A9 and called save method. I''''ve open it again and get value of A10. But the value hasn''''t changed. If I''''ve using Microsoft Excel open it before reopen it in RWExcel component. It works ok. Thanks. vdquang

Administrator [Syncfusion]
Replied On October 5, 2004 05:23 AM

Hi vdquang, 1) Lets assume that the value in A10 is the sum of A1:A9. A10 = SUM(A1:A9) A10 = 100 [Current Value] 2) Text.xls is opened using ExcelRW and the value of A9 is changed to 20. 3) At this point ExcelRW replaces the value of A9 but the value of A10 is still not changed since it would have to be opened using MS Excel for the calculation to take place and the value to be refreshed. 4) This is where Essential Calculate would do the job, it would calculate the value of A10 without the help of MS Excel and update the value in A10 to be 120. In other words Essential Calculate would allow you to refresh value without the need for opening the spreadsheet in MS Excel. Please let me know if you have any questions. Thanks, Stephen. >Hi! Stephen > >Can you tell me how to make excel refresh value after saving without using Excel automation. > >For example: >I''''ve file excel name is "Test.xls". In this file i have A10 range is : "=SUM(A1:A9)". >I''''ve opened "Test.xls" using RWExcel component and change value of A9 and called save method. >I''''ve open it again and get value of A10. But the value hasn''''t changed. > >If I''''ve using Microsoft Excel open it before reopen it in RWExcel component. It works ok. > > >Thanks. >vdquang >

Bruce Van Horn
Replied On November 19, 2004 11:39 PM

OK, so now we know we need the calculation engine, but could you complete the answer by showing us how to update the calculation using the other tool? Thanks! >Hi vdquang, > >1) Lets assume that the value in A10 is the sum of A1:A9. > >A10 = SUM(A1:A9) >A10 = 100 [Current Value] > >2) Text.xls is opened using ExcelRW and the value of A9 is changed to 20. > >3) At this point ExcelRW replaces the value of A9 but the value of A10 is still not changed since it would have to be opened using MS Excel for the calculation to take place and the value to be refreshed. > >4) This is where Essential Calculate would do the job, it would calculate the value of A10 without the help of MS Excel and update the value in A10 to be 120. In other words Essential Calculate would allow you to refresh value without the need for opening the spreadsheet in MS Excel. > >Please let me know if you have any questions. > >Thanks, > >Stephen. > >>Hi! Stephen >> >>Can you tell me how to make excel refresh value after saving without using Excel automation. >> >>For example: >>I''''ve file excel name is "Test.xls". In this file i have A10 range is : "=SUM(A1:A9)". >>I''''ve opened "Test.xls" using RWExcel component and change value of A9 and called save method. >>I''''ve open it again and get value of A10. But the value hasn''''t changed. >> >>If I''''ve using Microsoft Excel open it before reopen it in RWExcel component. It works ok. >> >> >>Thanks. >>vdquang >>

Administrator [Syncfusion]
Replied On November 23, 2004 09:45 AM

Hi Bruce, Sorry for the delay in responding. I will post a sample shortly. Thank you for your patience. Best regards, Stephen. >OK, so now we know we need the calculation engine, but could you complete the answer by showing us how to update the calculation using the other tool? Thanks! > >>Hi vdquang, >> >>1) Lets assume that the value in A10 is the sum of A1:A9. >> >>A10 = SUM(A1:A9) >>A10 = 100 [Current Value] >> >>2) Text.xls is opened using ExcelRW and the value of A9 is changed to 20. >> >>3) At this point ExcelRW replaces the value of A9 but the value of A10 is still not changed since it would have to be opened using MS Excel for the calculation to take place and the value to be refreshed. >> >>4) This is where Essential Calculate would do the job, it would calculate the value of A10 without the help of MS Excel and update the value in A10 to be 120. In other words Essential Calculate would allow you to refresh value without the need for opening the spreadsheet in MS Excel. >> >>Please let me know if you have any questions. >> >>Thanks, >> >>Stephen. >> >>>Hi! Stephen >>> >>>Can you tell me how to make excel refresh value after saving without using Excel automation. >>> >>>For example: >>>I''''ve file excel name is "Test.xls". In this file i have A10 range is : "=SUM(A1:A9)". >>>I''''ve opened "Test.xls" using RWExcel component and change value of A9 and called save method. >>>I''''ve open it again and get value of A10. But the value hasn''''t changed. >>> >>>If I''''ve using Microsoft Excel open it before reopen it in RWExcel component. It works ok. >>> >>> >>>Thanks. >>>vdquang >>>

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.

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.

;