Formula Control

 Product NameQuantityPrice UnitPriceEF
1Computer5$500$2,500  
2Smartphone2$300$600  
3Calculator3$20$60  
4      
5      
6      
7      
8      
9      
10      
   


 Category  Value  Formula
 Total quantity: 10  SUM([FpSpread1]Sheet1!B:B)
 Total price: $ 3160  SUM([FpSpread1]Sheet1!D:D)
 Total price with VAT (10%): $ 3476  [lblTotalPrice]*1.1

Following are steps to use a FormulaExtender:
1. Add a FormulaExtender control into page.
2. Add one or more entry into FormulaExtender control, each entry is used for a control with specific formula.
3. When page is loaded, the value of formula will be filled into text of control.
4. If value in formula range is changed, value of target control will be recalculated automatically.
Example of an entry:
- ControlID="lblTotalQuantity"
- Formula="SUM([FpSpread1]Sheet1!B:B)"


Documentation