Rokko11 opened a new pull request, #802:
URL: https://github.com/apache/poi/pull/802
This pull request adds support for the Excel `SHEET` function.
**Summary of changes:**
- Implemented `org.apache.poi.ss.formula.functions.Sheet` as a
`FreeRefFunction`
- Correctly resolves:
- `SHEET()` → returns the current sheet index (1-based)
- `SHEET(reference)` → returns the sheet index of the referenced cell or
area
- Added argument validation and fallback to `#VALUE!` error for invalid
inputs
**Motivation:**
Currently I get a `NotImplementedFunctionException` when an Excel file
contains the SHEET function and gets processed with POI. Since there is no
other way to hook (yet) unsupported functions into poi, I'll need to go over a
Pull Request.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
