[Libreoffice-bugs] [Bug 96591] Formulas changed by adding sheet name before cell reference

[bugzilla-daemon]

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

car...@escila.net changed:

   What|Removed |Added

Version|5.1.0.1 rc  |5.1.6.2 release

--- Comment #9 from car...@escila.net ---
I'm sorry, I think the problem is not due to a change of version.

I don't know how, obviously, and I don't kwon when, but sometimes when I reopen
a file the formulas have changed by adding the sheet name before any cell
reference.

I reproduced the problem many times during my life, in many Libre Office
versions.
Currently, I'm using 5.1.6.2 in Ubuntu 16.04.3 but the problem also happened to
me under Windows in many versions.

And this problem happens to me suddenly and twice a month at least (every day I
work with many spreadsheet files)
It seems a silly question, but when happens, the reading and tracking of the
formulas becomes very complicated.


My "solution" is always find the name of sheet and replace by nothing but when
the file has many sheets it's heavy and annoying. Quite annoying, certainly.

I will appreciate reopen the bug in order to find a final solution.

Thank you.

-- 
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 96591] Formulas changed by adding sheet name before cell reference

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |FIXED

--- Comment #8 from Eike Rathke  ---
There was such bug adding the sheet name to each reference but it's long fixed.
Once stored to file there's nothing we could do in more recent release to
remove such because the user could had added them on purpose.

-- 
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 96591] Formulas changed by adding sheet name before cell reference

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Status|RESOLVED|CLOSED

-- 
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 96591] Formulas changed by adding sheet name before cell reference

[bugzilla-daemon]

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

--- Comment #7 from Migrec  ---
Created attachment 125418
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125418=edit
File with the bug

-- 
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 96591] Formulas changed by adding sheet name before cell reference

[bugzilla-daemon]

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

--- Comment #6 from Mateusz Konieczny  ---
How can I check whatever my file was in the past a XLSX 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

[Libreoffice-bugs] [Bug 96591] Formulas changed by adding sheet name before cell reference

[bugzilla-daemon]

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

--- Comment #4 from Mateusz Konieczny  ---
I noticed it happening in my document, unfortunately I was unable to pinpoint
(so far) when it happens. I keeps happening from time to time - maybe it
happens on Calc updates?

-- 
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 96591] Formulas changed by adding sheet name before cell reference

[bugzilla-daemon]

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

--- Comment #5 from Mateusz Konieczny  ---
For example it happened during using

Version: 5.1.0.3
Build ID: 1:5.1.0~rc3-0ubuntu1~trusty0
CPU Threads: 2; OS Version: Linux 3.13; UI Render: default; 
Locale: pl-PL (en_US.UTF-8)

maybe on upgrade from earlier version?

-- 
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 96591] Formulas changed by adding sheet name before cell reference

[bugzilla-daemon]

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

--- Comment #3 from Eldar  ---
Unfortunately I can't reproduce it now, because I saved document with new
version of LO. But I'm sure that formulas haven't Sheet names before cell
references when I was opened and used it with LO 5.0.3.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 96591] Formulas changed by adding sheet name before cell reference

[bugzilla-daemon]

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

--- Comment #1 from Eldar  ---
Additionally, some formatting styles are broken in cells.

I suspect that it happened only on ODS files that was converted from XLSX
files.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 96591] Formulas changed by adding sheet name before cell reference

[bugzilla-daemon]

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

raal  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||r...@post.cz
 Ever confirmed|0   |1

--- Comment #2 from raal  ---
I can not reproduce - created file in version 5.0, when I open in 5.2 the
formula is still "=A1+B1". Please send us a sample document, as this makes it
easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO', so please do change it back to
'UNCONFIRMED' once you have attached a document.
(Please note that the attachment will be public, remove any sensitive
information before attaching it.)
How can I eliminate confidential data from a sample document?
https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F
Thank you

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs