https://bugs.documentfoundation.org/show_bug.cgi?id=148242
--- Comment #1 from fml2 <[email protected]> --- 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? -- You are receiving this mail because: You are the assignee for the bug.
