Various Functions in Spreadsheet"

From Documentation
m
 
(2 intermediate revisions by 2 users not shown)
Line 30: Line 30:
 
If you'd like to know more about ZK Spreadsheet, please refer to the following URLs:
 
If you'd like to know more about ZK Spreadsheet, please refer to the following URLs:
  
* [http://docs.zkoss.org/wiki/New_Features_of_ZK_Spreadsheet_0.7.0 New Features of ZK Spreadsheet 0.7.0]
+
* [[Small_Talks/2008/February/New_Features_of_ZK_Spreadsheet_0.7.0 | New Features of ZK Spreadsheet 0.7.0]]
  
* [http://docs.zkoss.org/wiki/A_Preview_of_ZK_Spreadsheet_Component A Preview of ZK Spreadsheet Component]
+
* [[Small_Talks/2007/December/A_Preview_of_ZK_Spreadsheet_Component | A Preview of ZK Spreadsheet Component]]
  
* [http://docs.zkoss.org/wiki/A_Sip_of_the_ZK_Spreadsheet_Component A Sip of the ZK Spreadsheet Component]
+
* [[Small_Talks/2007/September/A_Sip_of_the_ZK_Spreadsheet_Component | A Sip of the ZK Spreadsheet Component]]
  
* [http://docs.zkoss.org/wiki/How_to_Build_a_Rich_Excel_Report_with_ZK_Spreadsheet How to Build a Rich Excel Report with ZK Spreadsheet]
+
* [[Small_Talks/2008/April/How_to_Build_a_Rich_Excel_Report_with_ZK_Spreadsheet | How to Build a Rich Excel Report with ZK Spreadsheet]]
  
* [http://docs.zkoss.org/wiki/Use_JavaBean_in_Excel_with_ZK_Spreadsheet Use JavaBean in Excel with ZK Spreadsheet]
+
* [[Small_Talks/2008/April/Use_JavaBean_in_Excel_with_ZK_Spreadsheet | Use JavaBean in Excel with ZK Spreadsheet]]
  
* [http://docs.zkoss.org/wiki/Change_the_Style_of_Spreadsheet_within_1_Min Change the Style of Spreadsheet within 1 Min]
+
* [[Small_Talks/2008/April/Change_the_Style_of_Spreadsheet_within_1_Min | Change the Style of Spreadsheet within 1 Min]]
  
* [http://docs.zkoss.org/wiki/Integrate_ZK_Spreadsheet_with_Spring Integrate ZK Spreadsheet with Spring]
+
* [[Small_Talks/2008/May/Integrate_ZK_Spreadsheet_with_Spring | Integrate ZK Spreadsheet with Spring]]
  
* [http://docs.zkoss.org/wiki/Generate_Huge_Data_Report_in_a_Second Generate Huge Data Report in a Second]
+
* [[Small_Talks/2008/May/Generate_Huge_Data_Report_in_a_Second | Generate Huge Data Report in a Second]]
  
 
What can I say. It is such simple!
 
What can I say. It is such simple!

Latest revision as of 06:16, 7 December 2010

DocumentationSmall Talks2008MayVarious Functions in Spreadsheet
Various Functions in Spreadsheet

Author
Ivan Cheng, Engineer, Potix Corporation
Date
May 23, 2008
Version
Applicable to ZK 3.0.5 and later
Applicable to ZK Spreadsheet 1.0.0 beta2 and later


Live Demo

The following figure demonstrates a financial example.

  • PMT is about the payment for a loan, and PMT = IPMT + PPMT.
  • IPMT is about the interest payment for a given period for an investment.
  • PPMT is about the payment on the principal for a given period for an investment.
  • SLN, SYD, DB, DDB are functions using four ways to calculate depreciation.


Introduction

In this article, we will demonstrate various functions in Spreadsheet. There are many functions in Excel, and now you can use them in ZK Spreadsheet. Furthermore, instead of input by yourself, the arguments of the functions can come from web service, database, Spring bean, etc.


If you'd like to know more about ZK Spreadsheet, please refer to the following URLs:

What can I say. It is such simple!

Import Excel

sheet.zul

    <window>
    	<spreadsheet id="function" url="/function.xls" maxrow="40" maxcolumn="20" height="600px" width="908px"/>
    </window>


Download

Conclusion

ZK Team have implemented near 80% of Excel functions, and we will keep on improving it. I only list part of the functions and you can try more. They will make developers more convenient to calculate complicated functions. We expect your response to make it better, feel free to leave a message or post it to ZK forum.




Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License.