Shift+F4 not work in different sheet

When I try to enter a formula, (i.e. Match() function, Sumif(), and other functions) where the parameter points to range on another sheet, locking reference using Shift+F4 sometimes not responds.

I must edit the formula manually add the $ symbol.

There is a bug about it:
bug 61977

Are you sure it does not respond? Shift+F4 has four states:

Sample formula: =A1

  • press SHIFT+F4 it appears: =$A$1 (locks row and column)
  • press SHIFT+F4 again: =A$1 (locks row)
  • press SHIFT+F4 again: =$A1 (locks column)
  • press SHIFT+F4 again: =A1 (back to default no locking).

It did works when selecting same sheet. But when selecting different sheet, it not work

I tested in LibO Version (Build ID: f969faf) on XP . Saved format: ODS

Shift+F4 work as long as I stay in the same Calc file even if the link is made to different sheet in this file

Shift+ F4 does not work when the link is to a different Calc file. In this case I need to add the $ signs manually.