[Libreoffice-bugs] [Bug 73210] FILEOPEN: Opening .xlsx corrupts some INDIRECT formulas

2015-01-22 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=73210 Michael Stahl changed: What|Removed |Added Attachment #91402|application/octet-stream|application/vnd.openxmlform mim

[Libreoffice-bugs] [Bug 73210] FILEOPEN: Opening .xlsx corrupts some INDIRECT formulas

2014-01-01 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=73210 mariosv changed: What|Removed |Added CC||mari...@miguelangel.mobi --- Comment #1 from m

[Libreoffice-bugs] [Bug 73210] FILEOPEN: Opening .xlsx corrupts some INDIRECT formulas

2014-01-01 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=73210 --- Comment #2 from Cedrick Collomb --- Similar but not strictly identical. Additional important information: works when loading .ods but does not work when loading .xlsx. Problem is not saving, it is in loading. If I create the formula in excel

[Libreoffice-bugs] [Bug 73210] FILEOPEN: Opening .xlsx corrupts some INDIRECT formulas

2014-01-03 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=73210 tommy27 changed: What|Removed |Added CC||ba...@quipo.it See Also|

[Libreoffice-bugs] [Bug 73210] FILEOPEN: Opening .xlsx corrupts some INDIRECT formulas

2014-01-03 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=73210 tommy27 changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0

[Libreoffice-bugs] [Bug 73210] FILEOPEN: Opening .xlsx corrupts some INDIRECT formulas

2014-01-03 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=73210 --- Comment #4 from Cedrick Collomb --- Forgot to mention that I unpacked the .xlsx after saving from LibreOffice and verified after saving that the content of sheet1.xml was accurate: AVERAGE(A1:INDIRECT("A"&D1))/120.5416667 -- You are

[Libreoffice-bugs] [Bug 73210] FILEOPEN: Opening .xlsx corrupts some INDIRECT formulas

2014-02-02 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=73210 --- Comment #5 from Cedrick Collomb --- This is still happening with 4.2.0.4 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bug

[Libreoffice-bugs] [Bug 73210] FILEOPEN: Opening .xlsx corrupts some INDIRECT formulas

2014-02-03 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=73210 GerardF changed: What|Removed |Added CC||gerard.farg...@orange.fr --- Comment #7 from G

[Libreoffice-bugs] [Bug 73210] FILEOPEN: Opening .xlsx corrupts some INDIRECT formulas

2014-02-03 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=73210 Cor Nouws changed: What|Removed |Added CC||c...@nouenoff.nl --- Comment #6 from Cor Nou

[Libreoffice-bugs] [Bug 73210] FILEOPEN: Opening .xlsx corrupts some INDIRECT formulas

2014-02-03 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=73210 --- Comment #8 from Cedrick Collomb --- Bug has been present at since 3.3.3 (also verified in 3.5.0 and 3.6.4). Hope this helps. -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 73210] FILEOPEN: Opening .xlsx corrupts some INDIRECT formulas

2014-02-04 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=73210 Cedrick Collomb changed: What|Removed |Added Version|4.1.3.2 release |3.3.0 release -- You are receiving th

[Libreoffice-bugs] [Bug 73210] FILEOPEN: Opening .xlsx corrupts some INDIRECT formulas

2014-02-04 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=73210 --- Comment #9 from Cedrick Collomb --- Created attachment 93397 --> https://bugs.freedesktop.org/attachment.cgi?id=93397&action=edit New example showing SUM/AVERAGE/OFFSET/ADDRESS/INDIRECT -- You are receiving this mail because: You are the

[Libreoffice-bugs] [Bug 73210] FILEOPEN: Opening .xlsx corrupts some INDIRECT formulas

2014-02-04 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=73210 --- Comment #10 from Cedrick Collomb --- Confirming this happens also with AVERAGE, SUM, OFFSET, ADDRESS, INDIRECT. Example .xlsx attached -- You are receiving this mail because: You are the assignee for the bug. ___

[Libreoffice-bugs] [Bug 73210] FILEOPEN: Opening .xlsx corrupts some INDIRECT formulas

2014-05-26 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=73210 sverson changed: What|Removed |Added See Also||https://bugs.freedesktop.or

[Libreoffice-bugs] [Bug 73210] FILEOPEN: Opening .xlsx corrupts some INDIRECT formulas

2014-05-26 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=73210 --- Comment #11 from sverson --- Confirming this happens also with INDEX. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@l

[Libreoffice-bugs] [Bug 73210] FILEOPEN: Opening .xlsx corrupts some INDIRECT formulas

2014-05-26 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=73210 Eike Rathke changed: What|Removed |Added CC||sver...@web.de --- Comment #12 from Eike R

[Libreoffice-bugs] [Bug 73210] FILEOPEN: Opening .xlsx corrupts some INDIRECT formulas

2014-05-26 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=73210 Eike Rathke changed: What|Removed |Added Status|NEW |RESOLVED Resolution|---

[Libreoffice-bugs] [Bug 73210] FILEOPEN: Opening .xlsx corrupts some INDIRECT formulas

2014-05-26 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=73210 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this mail bec

[Libreoffice-bugs] [Bug 73210] FILEOPEN: Opening .xlsx corrupts some INDIRECT formulas

2014-05-27 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=73210 --- Comment #14 from Eike Rathke --- Just note that ADDRESS() returns a string and not a reference and can not be used with the range operator. In the second test case document the formulas in D6 and D7 are invalid anyway. -- You are receiving