[Libreoffice-bugs] [Bug 115824] FILEOPEN older files. Referenced Cells

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 CC||todven...@suomi24.fi
 Resolution|--- |WONTFIX

--- Comment #6 from Buovjaga  ---
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.

-- 
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

[Libreoffice-bugs] [Bug 115824] FILEOPEN older files. Referenced Cells

[bugzilla-daemon]

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

--- Comment #5 from umbhaki  ---
(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.

-- 
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

[Libreoffice-bugs] [Bug 115824] FILEOPEN older files. Referenced Cells

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 CC||miguelangelrv@libreoffice.o
   ||rg

--- Comment #4 from m.a.riosv  ---
I think it was resolved, but I'm not able to find the bug report.

-- 
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

[Libreoffice-bugs] [Bug 115824] FILEOPEN older files. Referenced Cells

[bugzilla-daemon]

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

--- Comment #3 from Laurent BP  ---
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.

-- 
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

[Libreoffice-bugs] [Bug 115824] FILEOPEN older files. Referenced Cells

[bugzilla-daemon]

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

--- Comment #2 from umbhaki  ---
Created attachment 139977
  --> https://bugs.documentfoundation.org/attachment.cgi?id=139977=edit
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.

-- 
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

[Libreoffice-bugs] [Bug 115824] FILEOPEN older files. Referenced Cells

[bugzilla-daemon]

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

Laurent BP  changed:

   What|Removed |Added

 CC||jumbo4...@yahoo.fr

--- Comment #1 from Laurent BP  ---
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?

-- 
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