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.

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 06:44 PM Aug 1,2008 12:26 AM Windows Forms 2
loading
Tags: GridControl
Administrator [Syncfusion]
Asked On July 30, 2008 06:44 PM

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 05:07 AM

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 12:26 AM

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.

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.

;