tucker-adkison commented on PR #1046: URL: https://github.com/apache/poi/pull/1046#issuecomment-4256281690
> -1 from me without proper docs. And you can use POI's methods to register your own workaround without us adding anything to POI. I could not find a formal spec that names __xludf.DUMMYFUNCTION itself. What I did find is formal OOXML documentation that formula cells may store a cached last-calculated result in <v>, and POI already documents using cached formula results when evaluation cannot be completed. The justification here is not to add this Google function, but more to keep the cache value when recalculation is unable to evaluate the cell OOXML spec: https://learn.microsoft.com/en-us/office/open-xml/spreadsheet/working-with-formulas POI Documentation: https://poi.apache.org/components/spreadsheet/eval.html Microsoft Q&A: https://learn.microsoft.com/en-us/answers/questions/4986422/xludf-dummy-funtion -- 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]
