one thing to be aware of with POI and functions, if you force a full recalculation on a spreadsheet that contains functions that are still "not yet implemented", the recalculation will fail.
i ran across this some years ago, and the work-around (in that case) was to do targeted recalculations rather than forcing the whole worksheet to recalculate. the POI support for spreadsheet functions is pretty robust but last i saw, it is not exhaustive. Stanton Fisque principal technologist latticeware.com portland, oregon > On Dec 16, 2023, at 21:06 PM, bugzi...@apache.org wrote: > > https://bz.apache.org/bugzilla/show_bug.cgi?id=68305 > > --- Comment #2 from Haider <ali.haider.s...@gmail.com> --- > Thank you for the test case in r1914511. We're encountering an issue in our > application, which allows users to modify Excel files stored on S3 via a > front-end interface, as well as through MS Online and SpreadJS. The problem > arises during formula recalculation in sheets with names containing > apostrophes, resulting in an 'Invalid sheetIndex: -1' error. It's not entirely > clear if the error is due to modifications made through MS Online/SpreadJS or > another factor. > > To provide more context, our POI service receives the Excel file URL and the > specific cell that needs to be updated. We locate and update the cell in the > workbook and then initiate formula evaluation. Despite the formulas appearing > correct in our logs, POI consistently returns the 'sheetIndex: -1' error. We > would greatly appreciate any insights or suggestions for alternative > approaches > to this problem. > > -- > You are receiving this mail because: > You are the assignee for the bug. > --------------------------------------------------------------------- > To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org > For additional commands, e-mail: dev-h...@poi.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
