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