介绍自定义JDataGrid电子表格版本公式中的函数?

最新推荐文章于 2025-09-07 01:02:55 发布

weixin_33730836

最新推荐文章于 2025-09-07 01:02:55 发布

阅读量93

点赞数

CC 4.0 BY-SA版权

文章标签： python

原文链接：https://my.oschina.net/javastudy/blog/27

本文介绍如何在JDataGridSpreadsheet版中编写自定义函数，包括理解Function接口及其实现方法evaluate，以及如何通过FormulaFactory注册这些函数。自定义函数默认会被归类为CUSTOM类型，并在选择函数对话框中的‘Custom’类别下列出。

2019独角兽企业重金招聘Python工程师标准>>>

How to write function in JDataGrid Spreadsheet Edition?

1. Understand the formula and function API used in JDataGrid Spreadsheet Edition?

Obviously you should understand the “Function” and it’s sub class.
The central method of Function interface is “Object evaluate(FormulaContext ctx, List args)”, the method have the “FormulaContext” and List based arguments.

Override the method “evaluate(FormulaContext ctx, List args)” and write your logic in the method body, finally return the result, you can override the AbstractFunction directly or implements the Function interface, don’t forget invoke super(name) when use AbstractFuction.

Note: The important point need to mention is you should invoke the method “CellUtils.getObject”, “CellUtils.stringValue” to get every argument’s value, this is impossible before the JDataGrid Spreedsheet Edition 2.5.0, since the CellUtils is package private, the developer need copy the “CellUtils” class before the version 2.5.0, the good news is the API now open to public after version 2.5.0.

2. Add the function to the FormulaFactory.

The FormulaFactory provides the several methods to add or remove the function.

FormulaFactory.addFunction(Function);
FormulaFactory. removeFunction(String);
FormulaFactory. getAllFunctionNames();
FormulaFactory. getFunction(String);

The function you added will be the CellFunctionType.CUSTOM by default, these functions will be lists in “Custom” category in the choose function dialog, this is a new feature in JDataGrid 2.5.0.

insert-function-dialog