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: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

form spreadsheet and CalcQuick

Thread ID:

Created:

Updated:

Platform:

Replies:

149303 Nov 21,2019 08:18 AM UTC Nov 22,2019 10:48 AM UTC WinForms 1
loading
Tags: Spreadsheet
Gregory Pe
Asked On November 21, 2019 08:18 AM UTC

Hi,
1.
can you in textBox1 - Enter an algebraic expression:
put a reference to spreadsheet
to perform calculations similar to sqrt (2) * 2 + [A1] - [B1] after pressing button1
2.
as in spreadsheet, run the field to run the excel function
so that they can be used in spreadsheet
3. How to spreadsheet save and read the file on disk as.xlsx

Regards,
Gregory


Attachment: test_spreadsheet3_742399a5.rar

Arulpriya Ramalingam [Syncfusion]
Replied On November 22, 2019 10:48 AM UTC

 
Thank you for using Syncfusion products. 
 
can you in textBox1 - Enter an algebraic expression: 
put a reference to spreadsheet 
to perform calculations similar to sqrt (2) * 2 + [A1] - [B1] after pressing button1 
Spreadsheet allows user to update cellvalue at runtime with formula. SetCellValue() method can be used to set the formula for sheets. Please refer to below code and UG link. 
 
Example code 
 
//update formula at runtime. 
spreadsheet1.ActiveGrid.SetCellValue(spreadsheet1.ActiveSheet["C1"], "="+this.textBox1.Text); 
 
as in spreadsheet, run the field to run the excel function 
so that they can be used in spreadsheet 
Spreadsheet supports to import/Open/Save an excel workbook at runtime using UI interface and code behind. Please refer below UG for further reference. 
 
How to spreadsheet save and read the file on disk as.xlsx 
 
 
If we misunderstood your scenario, please get back to us with simple screenshot that demonstrates your requirement. 
 
Regards, 
Arulpriya 


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

This page will automatically be redirected to the 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

Live Chat Icon For mobile
Live Chat Icon