https://bugs.documentfoundation.org/show_bug.cgi?id=153548
Justin L <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #11 from Justin L <[email protected]> --- (In reply to Justin L from comment #8) > We already know that because of a > bug the two cells adjacent to a split confuse the testing of this bug (In reply to ady from comment #10) > Well, it partially works with the old [SHIFT]+[F4] in LO 3.3. If I freeze, > and in the same cell I click the "=" icon, select the immediately-adjacent > sheet and click on A1, [SHIFT]+[F4], I see it works. Whether it works or not in that specific situation is basically irrelevant. I tried to discourage testing that situation with comment 8. Having a uno name is a great code pointer. Thanks for providing that. The name of the toolbar control to search for is "Cycle Cell Reference Types". As soon as I switch to a sheet with a frozen column (not row) then this toolbar disables (even before selecting any cell). [For fun, add a third sheet. Starting from sheet 2, start a formula and select a cell in sheet 3. F4 works. Now switch to sheet 1. Although it still references a sheet3 cell, F4 no longer functions. So the disabling of the command is the code that needs to be examined. In the code, grepping for SID_TOGGLE_REL leads to sc/source/ui/view/editsh.cxx's Execute() function. This function is not even called when F4 is pressed in a frozen sheet. I can "fix" the issue by removing "StateMethod = GetState;" from editsh.sdi. -- You are receiving this mail because: You are the assignee for the bug.
