https://bugs.documentfoundation.org/show_bug.cgi?id=153548
--- Comment #10 from ady <[email protected]> --- (In reply to Stéphane Guillou (stragu) from comment #9) > Thank you both. Confirmed that it is inherited. > > In OOo 3.3, freezing is in Window > Freeze, and the UNO command can be found > in the Customize dialog in the "Insert" category, "Relative/Absolute > References" command. It is greyed out when following the steps in > Description (using cell D1 for the formula). 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. I can press [ENTER] and the formula sticks. But, if I change to a different cell (i.e. not the same cell where the freeze was introduced), then the procedure fails. I can also successfully do it if the sheet is not the immediately-adjacent, or the cell in that sheet is not A1. But all this depends on starting at the new "home" cell in the freeze area. Another important detail: in old versions, the sheet reference was also initially relative, same as the cell reference. In current versions, the sheet reference starts as absolute already. This part is not a bug; this was an intentional change! Please keep this part as it is now! -- You are receiving this mail because: You are the assignee for the bug.
