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

nissl-lab / npoi

a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.

Apache License 2.0

5.67k stars 1.43k forks source link

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

Closed Denny0503 closed 4 months ago

Denny0503 commented 6 months ago

NPOI Version

V2.6.2.0

File Type

[x] XLSX
[x] 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.

Bykiev commented 6 months ago

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 commented 5 months ago

Microsoft Doc on T.INV function