form spreadsheet and CalcQuick

[Gregory Pe]

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]

Hi Gregory, 

 

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);    UG link: https://help.syncfusion.com/windowsforms/spreadsheet/working-with-spreadsheet#setting-the-value-or-formula-to-a-cell
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.    UG link: https://help.syncfusion.com/windowsforms/spreadsheet/getting-started#opening-an-existing-excel-workbook
How to spreadsheet save and read the file on disk as.xlsx

 

Sample link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/test_spreadsheet31833956248  

 

If we misunderstood your scenario, please get back to us with simple screenshot that demonstrates your requirement. 

 

Regards, 

Arulpriya