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.

Sign up for GitHub

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

Jump to bottom

MaxNumOperands in Excel2007 is 255 #1209

Closed
TimLee88 opened this issue Nov 7, 2023 · 1 comment · Fixed by #1211
Closed

MaxNumOperands in Excel2007 is 255 #1209

TimLee88 opened this issue Nov 7, 2023 · 1 comment · Fixed by #1211
Labels
bug

Comments

@TimLee88
Copy link
Contributor

TimLee88 commented Nov 7, 2023 •
edited
Loading

NPOI Version

2.6.2

File Type

  • [*] XLSX

Issue Description

Property MaxNumOperands in Excel 2007 is 255
https://github.com/nissl-lab/npoi/blob/master/main/SS/Formula/Functions/MultiOperandNumericFunction.cs#L118
image

在下图这个函数中，如果operand超过30个就报错了，Excel2007中，应为 255
image

请参考apache poi
image
@TimLee88 TimLee88 added the bug label Nov 7, 2023
@Bykiev
Copy link
Collaborator

Bykiev commented Nov 7, 2023 •
edited
Loading

Nice catch, the value 30 is for Excel 97. Apache POI returns the value for Excel 2007:
https://github.com/apache/poi/blob/76b1a6fee4c78ec334fbdd729ae5c9d2957ae9c5/poi/src/main/java/org/apache/poi/ss/formula/functions/MultiOperandNumericFunction.java#L58C36-L58C36

Would you like to contribute?

This was referenced Nov 8, 2023
Closed
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Update MultiOperandNumericFunction.cs TimLee88/npoi
2 participants
@Bykiev @TimLee88