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. Image for the cookie policy date
WEBINAR  Visualize Customer Survey Reports Using Our React 3D Circular Charts Control —Thursday, May 02, 10:00 A.M. ET REGISTER NOW
close icon
  1. Home
  2. Forum
  3. WinForms
  4. Formula not work (2)

Formula not work (2)

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

3 Replies
AD Administrator Syncfusion Team October 5, 2004 09:23 AM UTC

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 >

BV Bruce Van Horn November 20, 2004 04:39 AM UTC

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 >>

AD Administrator Syncfusion Team November 23, 2004 02:45 PM UTC

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 >>>

Loader.
Live Chat Icon For mobile
Up arrow icon