https://bugs.documentfoundation.org/show_bug.cgi?id=124461
Bug ID: 124461
Summary: Creating workbook to workbook links no longer simple.
Product: LibreOffice
Version: 6.1.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: b...@telpro.co.za
Description:
Traditionally in Libra office if one wanted to link A1 in worksheet Bob to B1
in works sheet Sam, and you had both worksheets open, you would simply place an
equals sign in A1 in Bob and pick on B1 in Sam. This functionality seems to
have disappeared. You can use the Hyperlink dialogue, however this is extremely
cumbersome if you have a range of cells you would like to link.
Actual Results:
=
Expected Results:
cell value from external file
Reproducible: Always
User Profile Reset: No
Additional Info:
>From Libra Office Help
Choose File - Open, to load an existing spreadsheet document.
Choose File - New, to open a new spreadsheet document. Set the cursor in the
cell where you want to insert the external data and enter an equals sign to
indicate that you want to begin a formula.
Now switch to the document you have just loaded. Click the cell with the data
that you want to insert in the new document.
Switch back to the new spreadsheet. In the input line you will now see how
LibreOffice Calc has added the reference to the formula for you.
The reference to a cell of another document contains the name of the other
document in single inverted commas, then a hash #, then the name of the sheet
of the other document, followed by a point and the name of the cell.
Confirm the formula by clicking the green check mark.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
