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
I was not able to reproduce with: - Version: 6.0.1.1 Build ID: 60bfb1526849283ce2491346ed2aa51c465abfe6 Threads CPU : 8; OS : Linux 4.13; UI Render : par défaut; VCL: gtk2; Locale : fr-FR (fr_FR.UTF-8); Calc: group Could you attach a sample file?
Created attachment 139977 [details] Spreadsheet, three sheets, problem can be seen in second sheet You asked me for a sample file, so I send one called »Differenziert2_Lösung.odt«. The problem can be seen in the second sheet called »Vollkosten Vierkornbrot« in the cells E5:E13 and in E20, E22 an E23. In this cases I find in the formula bar expressions like: ='Vollkosten Vierkornbrot'.C5*'Vollkosten Vierkornbrot'.D5 which is unnecessary because all these cells are in the same sheet, just in »Vollkosten Vierkornbrot«. The other cells in this sheet don't do so. The sheet works correctly, the results are OK. The file was created in 2015 with a former version of LibreOffice (can't remember which version). It is a minor bug, simply a bit unpleasing.
I see the problem. But behavior is the same whatever LibO version used: 5.3.7 or 6.0.1. How did you build such formula? If I manually remove extra sheet name, formula color enlightening works again.
I think it was resolved, but I'm not able to find the bug report.
(In reply to Laurent BP from comment #3) > How did you build such formula? The file has been created in May 2015, that means, LibO 4.4.x has been used for it, and it has been a 32bit-version at that time for me (Lubuntu GNU/Linux 14.04). Nowadays I open it with LibO 6.0.1.1, 64bit (Lubuntu GNU/Linux 16.04) and see the mentioned bug. Those formulas I use to build by clicking the mouse on the referenced cells to pick the cell name. So I do as well if the cells are in the same sheet or in any other. > If I manually remove extra sheet name, formula color enlightening works > again. Yes, I see the same behaviour here. If I create a NEW spreadsheet file with my 6.0.1.1 this bug does not appear and everything works fine as expected.
I asked a developer: "if the sheet names are already part of the references and stored to file there's nothing to do; there was some version that added the 3D sheet name to same-sheet references but that was long ago; if it's annoying one can use Find & replace" Closing.