https://bugs.documentfoundation.org/show_bug.cgi?id=143816
AndreasHengst <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- OS|Windows (All) |All Version|7.1.5.2 release |5.3.2.2 release Hardware|x86-64 (AMD64) |All --- Comment #7 from AndreasHengst <[email protected]> --- I'm not convinced it's a bug, but inconsistent behavior is revealed. Too tricky for me to decide. A better title is "Bug?? Dragging formulae drags value as well" Either this is 1) a bug or 2) it's expected/necessary behavior. At first I thought that bringing the original cell value along might be an optimization, but a recalculation always needs to be done, so why copy the value? Perhaps in case recalculation is disabled? (found no such disabling setting in Calc)(just recalc the copied cell instead of all) I was able to reproduce PROVIDED I first enable [x]Iterations in WINDOWS: Tools > Options > LibreOffice Calc > Calculate > Iterative References. MAC: LibreOffice > Preferences > LibreOffice Calc > Calculate > I was able to reproduce behavior using a very simple sheet. Drag A1 to the right. A B C 1 30 20 1 // Formulas =max(A1:A3) =max(B1:B3) =max(C1:C3) 2 30 20 1 // just numbers 3 30 20 1 // just numbers Version: 7.3.0.3 (x64) / LibreOffice Community Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded Also on MacOS ver 7.1.0.3, and 5.3.2.2 so Changed "Hardware" designation from x86+windows to All+All. In the original post Step 4: "Press F9..." the formulas in H2 and I2 are evaluating correctly because 48 IS the max of 48 and some smaller values. In the original post Step 5: ... *that* might be a bug. 'Type into here' is possibly inconsistent with 'drag into here' result. -- You are receiving this mail because: You are the assignee for the bug.
