ClosedXML / ClosedXML/ClosedXML
Question about the INDIRECT function
- 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
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