ClosedXML / ClosedXML/ClosedXML

Question about the INDIRECT function

Open
#1,690 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
5.7k
Forks
933
Avg merge
12h 14m
Merged PRs (30d)
1

Description

**Do you want to request a *feature* or report a *bug*?**
- [ ] Bug
- [ ] Feature
- [x] Question

**Version of ClosedXML**

e.g. 0.95.4

**What is the current behavior?**

I work for a software company who uses ClosedXML in our product. We have an Excel file which uses the INDIRECT function. Currently, when we try to recalculate all the formulas in a Worksheet, we get an error saying that this function isn't recognized. This is expected as [this function isn't supported yet](https://github.com/closedxml/closedxml/wiki/Evaluating-Formulas).

I know this was requested before (#1413) and than an implementation was attempted (#1566). However I was wondering if supporting this function was a milestone for a future release, In other words, can we expect support of the INDIRECT function in the near-future?

Thanks in advance, and thank you for your product, it helps us a great deal.

- [ ] I attached a sample spreadsheet. (You can drag files on to this issue)

Contributor guide

Open the contributing guide

Research direction

Start by reading the formula-evaluation documentation linked in the issue, then review the prior request in #1413 and attempted implementation in #1566. Determine the expected scope for supporting Excel's INDIRECT function during worksheet recalculation; done means the function is supported and the existing limitation is resolved.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp
Domain
tooling
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
15/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.