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

SetCellFormula("T.INV(0.99,100)*126+36/2") report error #1273

Closed
2 of 5 tasks
Denny0503 opened this issue Feb 23, 2024 · 2 comments · Fixed by #1345
Closed
2 of 5 tasks

SetCellFormula("T.INV(0.99,100)*126+36/2") report error #1273

Denny0503 opened this issue Feb 23, 2024 · 2 comments · Fixed by #1345
Labels
enhancement formula help-wanted
Milestone
NPOI 2.8.0

Comments

@Denny0503
Copy link

Denny0503 commented Feb 23, 2024 •
edited

NPOI Version

V2.6.2.0

File Type

  • XLSX
  • XLS
  • DOCX
  • XLSM
  • OTHER

Upload the Excel File

Please attach your original Excel File to help us reproduce the issue

Reproduce Steps

Issue Description

How can I SetCellFormula("T.INV(0.99,100)*126+36/2")? It throw exception :

Dotted range (full row or column) expression "T.INV" must have exactly 2 dots.
@Denny0503 Denny0503 added the bug label Feb 23, 2024
@Denny0503 Denny0503 changed the title SetCellFormula("T.INV(0.99,100)") report error SetCellFormula("T.INV(0.99,100)*126+36/2") report error Feb 23, 2024
@Bykiev
Copy link
Collaborator

Bykiev commented Feb 25, 2024

Unfortunately, TINV function is not implemented in NPOI. You can contribute to NPOI or register a custom function (here is a sample with Apache POI, should be similar with NPOI: https://stackoverflow.com/a/60520916/8388835)

@tonyqus tonyqus added enhancement and removed bug labels Feb 25, 2024
@tonyqus tonyqus added this to the NPOI vNext milestone Feb 25, 2024
@tonyqus
Copy link
Member

tonyqus commented Apr 15, 2024

Microsoft Doc on T.INV function

@tonyqus tonyqus modified the milestones: NPOI vNext, NPOI 2.8.0 May 3, 2024
@dcjxdd123 dcjxdd123 mentioned this issue May 11, 2024
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement formula help-wanted
Projects
None yet
Milestone
NPOI 2.8.0
Development

Successfully merging a pull request may close this issue.

Implement T.INV Function dcjxdd123/xddnpoi
3 participants
@tonyqus @Bykiev @Denny0503