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.
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 3.6.6.2 (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.