I was confused by the Calc behaviour. This is probably not a bug, but I'd like to discuss ways to reduce confusion. How to reproduce ---------------- 1. Create a new Cal table 2. Fill cells B1, B2 and B3 with the value 1 3. Into the cell B4, enter the formula SUM(B1:B3) 4. Scroll the table down so that the first visible row is 2. 5. Go to the cell B4 and start to edit it, e.g. by pressing F2. I now see a ractangle around the area in the formula. The rectangle only surrounds cells up to B2 (since B1 is not visible). It also has "handles" at the corners. The presence of the handles creates the impressions that the rectangle sorrounds *the whole* formula range. This has confused me because I was not sure what happens if I just hit the Enter key (without having edited the formula). Will the old range be kept? Or will it be set to B2:B3, i.e. the one surrounded by the "complete" rectangle?
Created attachment 179176 [details] Confusing handles The confusing handles are marked red.
Reproducible in: Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 678446780446ae568ee8b1b814158c54ea5e393f CPU threads: 8; OS: Linux 5.13; UI render: default; VCL: gtk3
Also in Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: f3aab159f1c1e00c25e6b4ca1e50813bc343f4f3 CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
Well spotted, the handles not only give a false impression but also cannot be used to extend the range. Might be an easyhack.