https://bugs.documentfoundation.org/show_bug.cgi?id=172997
--- Comment #1 from Celelibi <[email protected]> --- I forgot to add two things: 1) Common Subexpression Elimination (https://en.wikipedia.org/wiki/Common_subexpression_elimination) is a pretty common compilation optimization technique. It detects identical subexpression and computes them only once. If applied correctly, it could really tame down the growth of the compiled expression. Its size would be at most the sum of the size of all the Named Expressions, instead of being exponential in that. 2) There's a simple workaround for the genuine case of Err:512. Just put the named expression somewhere in the spreadsheet, and reuse *that* one instead of the name. For some reason, the expression compilation stops at named cells or ranges and another mechanism propagate the value change through the cells. -- You are receiving this mail because: You are the assignee for the bug.
