GrapeCity Forums

hi there,  i have some complex excel spreadsheets that i am looking to webify.  does fp spread for asp.net have the ability to convert an existing spreadsheet with its formulas and such to a web application? 

an extremely simple example.  my spreadsheet has 3 cells.  cell a1 holds a number, say a dollar amount. cell a2 holds a percent.  cell a3 displays the result of a1 * a2.  great, that's my excel file.  can i import that file using fp spread and have an excell looking web page where changing the data in cells a1 or a2 causes an ajax call to a backend component which performs the calculation and sends the result to cell a3?

 if so, is there a guide someplace that i can refer to for how to do this?

Hello,

Please find attached a sample website along with an Excel file in which the desired functionality has been achieved. Run the website and click on the “Load Excel” button to load the Excel file into the Spread.

Once loaded you can see that the Cell A3 has a formula. You can change the values in Cell A1 or A2 and as soon as you will come out of the cell then the formula value in A3 will be updated. For this to happen, Spread has a ClientAutoCalculation property which should be set to true.

The OpenExcel method which I have used is with no Flags however you can use any of the available Flags (like DataOnly, DataAndFormulasOnly etc).