-
Notifications
You must be signed in to change notification settings - Fork 907
Open
Labels
formulaMissing function, feature/bug in CalcEngineMissing function, feature/bug in CalcEngine
Description
Read and complete the full issue template
Do not randomly delete sections. They are here for a reason.
Do you want to request a feature or report a bug?
- Bug
- Feature
- Question
Did you test against the latest CI build?
- Yes
- No
If you answered No, please test with the latest development build first.
Version of ClosedXML
e.g. 0.95.3
What is the current behavior?
Returns that the TINV function is not implemented
What is the expected behavior or new feature?
That the TINV function runs successfully and the expected behavior is the same as the link: https://support.microsoft.com/en-us/office/tinv-function-a7c85b9d-90f5-41fe-9ca5-1cd2f3e1ed7c
Is this a regression from the previous version?
No.
Reproducibility
Set TINV function on any cell to reproduce the problem
Code to reproduce problem:
using (var workbook = new XLWorkbook())
{
var worksheet = workbook.Worksheets.Add("Sample Sheet");
worksheet.Cell("A1").Value = "0.05464";
worksheet.Cell("A2").Value = "60";
worksheet.Cell("B1").FormulaA1 = "=TINV(A1,A2)";
return worksheet.Cell("B1").Value.ToString(); // Should return 1,960041187
}- I attached a sample spreadsheet. (You can drag files on to this issue)
Metadata
Metadata
Assignees
Labels
formulaMissing function, feature/bug in CalcEngineMissing function, feature/bug in CalcEngine