Ask Your Question

Shift+F4 not work in different sheet [closed]

asked 2013-06-13 13:29:58 +0200

Paijo gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-02 04:48:06.743958

3 Answers

Sort by » oldest newest most voted

answered 2013-06-13 23:00:29 +0200

m.a.riosv gravatar image

There is a bug about it: bug 61977

edit flag offensive delete link more

answered 2013-06-14 10:00:19 +0200

ROSt52 gravatar image

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.

edit flag offensive delete link more

answered 2013-06-13 15:11:41 +0200

froz gravatar image

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).

edit flag offensive delete link more


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

Paijo gravatar imagePaijo ( 2013-06-14 08:06:26 +0200 )edit

Question Tools


Asked: 2013-06-13 13:29:58 +0200

Seen: 315 times

Last updated: Jun 14 '13