Rokko11 opened a new pull request, #803: URL: https://github.com/apache/poi/pull/803
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 - SHEET(name) → returns the sheet index of the referenced named sheet - Added argument validation and fallback to #NV 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
