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

formula function and validate #701

Closed
ZhangYi96 opened this issue Sep 8, 2020 · 1 comment
Closed

formula function and validate #701

ZhangYi96 opened this issue Sep 8, 2020 · 1 comment
Labels
enhancement New feature or request

Comments

@ZhangYi96
Copy link

ZhangYi96 commented Sep 8, 2020

Can formulaFuncs support AND and OR methods?
I need :

  1. calculate AND , OR and Date
  2. When I input the wrong formula, it should have returned an error but a panic

Input

1. AND(1=1,2=2)
2. OR(1=2,2=2)
3. Date(2020,10,01)
4. AND(1=1),

Output

1. true
2. true
3. 2020/10/01
4. error
@xuri xuri added the enhancement New feature or request label Sep 9, 2020
@xuri xuri closed this as completed in 577b308 Oct 16, 2020
@xuri
Copy link
Member

xuri commented Oct 16, 2020

Thanks for your issue, I have just init new formula function AND and OR, and I'll add DATE support later.

xuri added a commit that referenced this issue Oct 16, 2020
xuri added a commit that referenced this issue Oct 16, 2020
EugeneAndrosovPaser pushed a commit to ceearrashee/excelize that referenced this issue Nov 14, 2020
… lexer panic on retrieving the top token type
jenbonzhang pushed a commit to jenbonzhang/excelize that referenced this issue Oct 22, 2023
… lexer panic on retrieving the top token type
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants