https://bugs.documentfoundation.org/show_bug.cgi?id=174180
--- Comment #11 from (retired member) <[email protected]> --- (In reply to raal from comment #7) > Tested with Version: 27.2.0.0.alpha0+ (X86_64) > Build ID: f27c26b40c5d0fae5c83fbb5c90611f33fcb70c5 > CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3 > Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US > Calc: threaded > > and =LET(x;10;LET(y;20;x+y)) returns 30. =LET(x;10;LET(y;2*x;y+5)) returns > 25. > > Seems to be fixed with dev version. Please could you test it with > dev version? Especially with your complex spreadsheets. You can download it > here: > http://dev-builds.libreoffice.org/daily/master/ > Thank you Thank you kindly for this! My complex spreadsheet works as indicated on at least three levels of LET, although I did notice a few changes in the results for certain unrelated cases, including a trickling effect on an error. A simple example (which I perfectly understand could be handled differently, but it shows what I'm talking about): =LET(a;A1;b;1/a;if(a=0;0;b)) —> resulted in a value of 0 in v26.8.1.1, but returns #DIV/0! in the Dev. Just let me know if something should be addressed with this. -- You are receiving this mail because: You are the assignee for the bug.
