https://bz.apache.org/bugzilla/show_bug.cgi?id=66181
--- Comment #5 from Miłosz Rembisz <[email protected]> --- Hi, I believe this change broke other related behaviour - referencing blank cell. Having empty cell A1 I whould expect formula "=VALUE(A1)" to evaluate to zero, instead it now returns "#VALUE!". Interestingly enough, chaining reference (empty A1, B1 = "=A1", C1 = "=VALUE(B1)") works well. I don't know if this behaviour (value on reference to empty cell evaluating to zero) is desired - I could confirm that LibreOffice and Excel 365 does that. I've created pull request https://github.com/apache/poi/pull/397 to illustrate the issue (and potential fix). -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
