https://bugs.documentfoundation.org/show_bug.cgi?id=47349
--- Comment #33 from Justin L <[email protected]> --- I spent some time again in comment 20's attachment 167074. I noted that the focus seems to be on the bottom left quadrant (BL). Anytime the formula building starts from here, it work. Anytime the formula building starts from a different quadrant that is fully VISIBLE in BL, it doesn't work. But, if BL doesn't have the target cell as fully visible, then the formula building works on other sheets. (BL is used for an un-split view.) For example, when this document opens, my BL sees J7..AC17 (and part of 18). TL also can see AA2, so building a formula in there works. So does TL AC18, but not TL AC17. Similarly, TR AD14 works, but not TR AC14. (Adding another sheet with a split in it complicates things, BTW. The active cells in each have to be in the same quadrant before it works.) I can "fix" the problem in ScTabView::ZoomChanged() with if (!SC_MOD()->IsFormulaMode()) UpdateEditView() Or perhaps more to the point, in ScTabView::SetTabNo - RefreshZoom(); - UpdateVarZoom(); if ( bRefMode ) + else + { + RefreshZoom(); + UpdateVarZoom(); + } -- You are receiving this mail because: You are the assignee for the bug.
