[Libreoffice-bugs] [Bug 124461] New: Creating workbook to workbook links no longer simple.

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Mar 31 21:17:11 UTC 2019


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 at lists.freedesktop.org
          Reporter: bob at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190331/c9b49077/attachment.html>


More information about the Libreoffice-bugs mailing list