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