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

None of solutions in the forums are working for retrieving formulas for a selected Sheet.

Thread ID:

Created:

Updated:

Platform:

Replies:

75576 Jul 30,2008 10:44 PM UTC Aug 1,2008 04:26 AM UTC WinForms 2
loading
Tags: GridControl
Administrator [Syncfusion]
Asked On July 30, 2008 10:44 PM UTC

Hi,
After so many emails going back and forth i was not able to get a working solution for my requirement.

To make you more clear with the issue im attaching a sample program.

Please do the following in the Test App.

Step1: Add a formula say "D1*2" in the Sheet named "Testing" under the FormulaCell Column.

Step2 : Add a formula say "D1*2" in the Sheet named "Testing1" under the FormulaCell Column.

Step3 : Add a formula say "D1*5" in the Sheet named "Testing1" under the FormulaCell Column.

Step 4: Select item "Testing" from the DropDown box

Now on clicking the "Get Formula Cells" button im expecting all the formulas in the selected sheet that is the "Testing" sheet.

Step 5: Select item "Testing1" from the DropDown box

Now on clicking the "Get Formula Cells" button im expecting all the formulas in the selected sheet that is the "Testing1" sheet.

Please check my comments in the "Get Formula Cells" Button Click handler code.

Regards,
Sreekesh NK



ToSyncFusion_FormulaRetrieval_623b1777.zip

Administrator [Syncfusion]
Replied On July 31, 2008 09:07 AM UTC

Here is your sample back with the code added to show the requested formulas in the output window.

I did make one change to your code. I assume you want to be able to refer to the second sheet from within the first sheet and vice versa. If so, when you register the sheets, you need to use the same sheetid. Only those sheets with the same sheetid are known to each other.



ToSyncFusion_FormulaRetrieval_7550a10e.zip

Administrator [Syncfusion]
Replied On August 1, 2008 04:26 AM UTC

Hi Clay Burch,

Thank You for the help,
the code is now workiing fine.

Thanks,
Sreekesh NK

>Here is your sample back with the code added to show the requested formulas in the output window.

I did make one change to your code. I assume you want to be able to refer to the second sheet from within the first sheet and vice versa. If so, when you register the sheets, you need to use the same sheetid. Only those sheets with the same sheetid are known to each other.



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

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

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

;