Thread ID: |
Created: |
Updated: |
Platform: |
Replies: |
149303 | Nov 21,2019 08:18 AM UTC | Nov 22,2019 10:48 AM UTC | WinForms | 1 |
![]() |
Tags: Spreadsheet |
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 |
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.
This page will automatically be redirected to the sign-in page in 10 seconds.