Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

書き込み時に数式を設定できるようにする #83

Closed
mygreen opened this issue Jul 31, 2016 · 1 comment
Closed

書き込み時に数式を設定できるようにする #83

mygreen opened this issue Jul 31, 2016 · 1 comment
Milestone

Comments

@mygreen
Copy link
Owner

mygreen commented Jul 31, 2016

書き込み時に数式を設定できるようにする。

public class SampleSheet {

     // 数式を直接指定する場合
     @XlsCell(address="A1")
     @XlsFormula("TODAY()")
     private Date day;

     // 数式を取得するメソッドから取得する場合
     @XlsCell(address="B1")
     @XlsFormula(methodName="getSumFormula")
     private Integer sum;

     public String getSumFormula(Point point) {
         int rowNumber = point.y + 1;
         return String.format("SUM(D%d:F%d)", rowNumber, rowNumber);
     }
}
@mygreen
Copy link
Owner Author

mygreen commented Aug 30, 2016

fix 1.5

@mygreen mygreen closed this as completed Aug 30, 2016
@mygreen mygreen added this to the 1.5 milestone Sep 1, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant