https://bugs.documentfoundation.org/show_bug.cgi?id=115824

            Bug ID: 115824
           Summary: FILEOPEN older files. Referenced Cells
           Product: LibreOffice
           Version: 6.0.1.1 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: trivial
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Description:
If you open an existing spreadsheet with several sheets, where referrings exist
between cells of different sheets, Calc writes in the formula bar the name of
the sheet and of the cell to which you refer.

If the referenced cell is in the same sheet, only the name of the cell should
be written in the formula bar. But in version 6.0.1.1 often (not always, as I
found) calc writes the sheet name into the formula bar even when the used cell
and the referenced cell are in the same sheet. This is a bit incommoding in my
opinion.

This happens in existing spreadsheets from former versions of Calc, not in new
ones, as far as I can see.

Steps to Reproduce:
1. Open a Calc-file with several sheets and cell references within the sheets.
2. 
3.

Actual Results:  
In the formula bar the sheet names are given even if the reference shows to the
same sheet.

Expected Results:
Sheet names should only be given if the reference shows to a different sheet.


Reproducible: Always


User Profile Reset: Yes



Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:3.4) Goanna/20180130
PaleMoon/27.7.2

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to