Skip to content

Implement TINV function #1911

@Brunolcg

Description

@Brunolcg

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

No one assigned

    Labels

    formulaMissing function, feature/bug in CalcEngine

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions