Bug 61977 - Formula: Shift-F4 absolute addressing to an other File
Summary: Formula: Shift-F4 absolute addressing to an other File
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: low minor
Assignee: Not Assigned
Depends on:
Blocks: Shortcuts-Accelerators
  Show dependency treegraph
Reported: 2013-03-07 17:35 UTC by office8ox-libreoffice0bugzilla
Modified: 2018-12-03 19:31 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description office8ox-libreoffice0bugzilla 2013-03-07 17:35:16 UTC
Reproduction of the bug:
1. enter in a1: 1
2. enter in a2: 2
3. save the workbook as /home/[user]/2.ods
4. open a new workbook
5. add this formula to a1: =SUMME('file:///home/[user]/2.ods'#$Tabelle1.A1:A2)

With Shift-F4 you can change A2 in the formula (see 5.) to absolute addressing. But you can NOT change A1 to absolute addressing with Shift-F4.
Comment 1 Joel Madero 2013-03-18 19:53:33 UTC
Thank you for reporting this issue! I have been able to confirm the issue on:
Platform: Bodhi Linux 2.2 x64
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 
As I've been able to confirm this problem on an earlier release I am changing the version number as version is the earliest version that we can confirm the bug, we use comments to say that the bug exists in newer versions as well.

Marking as:

New (confirmed)
Minor - doesn't prevent high quality work, slightly slows it down
Low - default for minor bugs, seems appropriate

Keywords - ProposedEasyHack

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 
LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link:

There are also other ways to get involved including with marketing, UX, documentation, and of course developing -  http://www.libreoffice.org/get-help/mailing-lists/. 

Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material
Comment 2 Paijo 2013-06-14 06:15:48 UTC
Shift+F4 not responds in same file but different sheet as well.
I'm using Calc
Comment 3 bugquestcontri 2013-06-14 08:02:12 UTC
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.

see also
Comment 4 Pedro 2013-06-14 15:29:57 UTC
This problem still occurs under 4.1 Beta2

The interesting part is that pressing Shift+F4 works correctly when you initially define the range but not when you later try to edit the formula.

And the error does not occur on the whole formula. E.g. In function SUMIF(Sheet1.A1:A9;L1:L2) if you press Shift+F4 while editing the Formula and the cursor is near A9, L1 or L2 it will work i.e. change A9 to $A$9. However if the cursor is near A1 it won't work.
Comment 5 Eike Rathke 2013-11-05 11:52:42 UTC
Source code entry point is sc/source/ui/view/viewfun4.cxx method ScViewFunc::DoRefConversion()
Comment 6 Eike Rathke 2013-11-06 15:04:17 UTC
It turned out that the ScRefFinder::ToggleRel() method in sc/source/core/tool/reffind.cxx is not prepared at all to handle references to external documents. Currently that methods operates on the string obtained from code tokens and can't be easily enhanced to take the various external references' document notations into account. Best a new approach would be implemented that operates on a copy of the compiled tokens instead. I wouldn't call that an EasyHack anymore though.. removing from those.
Comment 7 QA Administrators 2015-04-19 03:23:10 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2016-09-20 09:24:35 UTC Comment hidden (obsolete)
Comment 9 Roman Kuznetsov 2018-12-03 19:31:09 UTC
don't repro in

Version: (x64)
Build ID: d1b41307be3f8c19fe6f1938cf056e7ff1eb1d18
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: CL