| Summary: | EDITING reference type change (Shift-F4) does not work for cross-file references | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Tilman Vogel <tilman.vogel> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | jmadero.dev |
| Priority: | medium | ||
| Version: | 4.3.7.2 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
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 :) Great, verified, it works on 5.1.0.3. |
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.".