Bug 98339 - EDITING reference type change (Shift-F4) does not work for cross-file references
Summary: EDITING reference type change (Shift-F4) does not work for cross-file references
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-03-02 08:54 UTC by Tilman Vogel
Modified: 2016-03-03 09:15 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Tilman Vogel 2016-03-02 08:54:55 UTC 
How it should work: When I have a cell with "=SUM(A1:C10)" in it and I hit Shift-F4, the formula should be changed to "=SUM($A$1:$C$10)". This works.

However, when I have a cell with "=SUM('file://somewhere/sheet.ods'#SheetName.A1:C10)" in it, and I hit Shift-F4 on it, the result is "=SUM('file://somewhere/sheet.ods'#SheetName.A1:$C$10)", so only the range end cell reference is adjusted while also the start should be adjustes.

Also, when I have a cell with "='file://somewhere/sheet.ods'#SheetName.A1" in it, and I hit Shift-F4 on it, I get a pop-up saying "No references found.".
Comment 1 Joel Madero 2016-03-02 20:14:44 UTC 
Hi Tilman,

Can you please try with 5.1 or 5.2 (4.3 isn't supported any longer, hasn't been for a long time). 

I just tested with 5.2 on bodhi moksha and it works as expected.

Closing as WFM. If you test on a newer, currently supported, version and you still see the problem, please set back to UNCONFIRMED and leave a comment.

Also just FYI - the shortcut in modern releases is f4 not shift+f4 :)
Comment 2 Tilman Vogel 2016-03-03 09:15:34 UTC 
Great, verified, it works on 5.1.0.3.