tucker-adkison commented on PR #1046: URL: https://github.com/apache/poi/pull/1046#issuecomment-4254843558
> Any docs to back up that this is a standard that we should support? And is there a reason to recalc? Poi will never have good support for edge case functions and the XML files in xlsx have cached eval results that poi uses. To clarify, this change is not trying to evaluate __xludf.DUMMYFUNCTION in POI. Google Sheets can emit formulas like __xludf.DUMMYFUNCTION(...) for functions Excel does not support, but it also stores the computed cached value in the XLSX. My change uses that cached value rather than failing on the unsupported formula itself. So the benefit here is better interoperability with Google Sheets-generated XLSX files, without requiring POI to implement evaluation for those functions because those functions are not supported by Excel’s formula engine. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
