[Libreoffice-bugs] [Bug 76159] FILEOPEN: IF() and INDIRECT() in formulae causes #REF!

2014-09-18 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=76159 raal r...@post.cz changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|---

[Libreoffice-bugs] [Bug 76159] FILEOPEN: IF() and INDIRECT() in formulae causes #REF!

2014-09-17 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=76159 --- Comment #10 from Alex Masterov amaste...@gmail.com --- (In reply to comment #9) Hello! Yes, setting Always recalculate solves this problem. -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 76159] FILEOPEN: IF() and INDIRECT() in formulae causes #REF!

2014-09-05 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=76159 raal r...@post.cz changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC|

[Libreoffice-bugs] [Bug 76159] FILEOPEN: IF() and INDIRECT() in formulae causes #REF!

2014-04-01 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=76159 Jorendc jore...@libreoffice.org changed: What|Removed |Added Attachment #95776|text/plain

[Libreoffice-bugs] [Bug 76159] FILEOPEN: IF() and INDIRECT() in formulae causes #REF!

2014-03-18 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=76159 --- Comment #8 from Jens S jensnsoren...@gmail.com --- If I again open the original file test.ods with the result in G3 #REF! and make a hard recalc (ctrl+shift+F9), I got the correct result. When I close the file without saving (I'm not asked to

[Libreoffice-bugs] [Bug 76159] FILEOPEN: IF() and INDIRECT() in formulae causes #REF!

2014-03-16 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=76159 Alex Masterov amaste...@gmail.com changed: What|Removed |Added Attachment #95777|0 |1 is

[Libreoffice-bugs] [Bug 76159] FILEOPEN: IF() and INDIRECT() in formulae causes #REF!

2014-03-16 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=76159 --- Comment #7 from Alex Masterov amaste...@gmail.com --- BTW, any changing E3 (e.g. changing formula to incorrect =IF(B30;A1)) makes G3 cell to contain correct value 6. But save/load returns to #REF! error. -- You are receiving this mail

[Libreoffice-bugs] [Bug 76159] FILEOPEN: IF() and INDIRECT() in formulae causes #REF!

2014-03-15 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=76159 Terrence Enger lo_b...@iseries-guru.com changed: What|Removed |Added Attachment #95777|Test spreadsheet (correct |Test

[Libreoffice-bugs] [Bug 76159] FILEOPEN: IF() and INDIRECT() in formulae causes #REF!

2014-03-15 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=76159 Terrence Enger lo_b...@iseries-guru.com changed: What|Removed |Added Status|UNCONFIRMED |NEW

[Libreoffice-bugs] [Bug 76159] FILEOPEN: IF() and INDIRECT() in formulae causes #REF!

2014-03-15 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=76159 --- Comment #3 from Jens S jensnsoren...@gmail.com --- If I use correct syntax in cell E3, there is no problem. Change the formula from: =IF(B30;A1) to something like: =IF(B30;A1;0) but I cannot explain why. -- You are receiving this mail

[Libreoffice-bugs] [Bug 76159] FILEOPEN: IF() and INDIRECT() in formulae causes #REF!

2014-03-15 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=76159 Terrence Enger lo_b...@iseries-guru.com changed: What|Removed |Added Status|NEW |NEEDINFO ---

[Libreoffice-bugs] [Bug 76159] FILEOPEN: IF() and INDIRECT() in formulae causes #REF!

2014-03-15 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=76159 Terrence Enger lo_b...@iseries-guru.com changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED

[Libreoffice-bugs] [Bug 76159] FILEOPEN: IF() and INDIRECT() in formulae causes #REF!

2014-03-15 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=76159 --- Comment #5 from Terrence Enger lo_b...@iseries-guru.com --- Of course, I meant in accord with comment 3. -- You are receiving this mail because: You are the assignee for the bug. ___

[Libreoffice-bugs] [Bug 76159] FILEOPEN: IF() and INDIRECT() in formulae causes #REF!

2014-03-14 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=76159 Alex Masterov amaste...@gmail.com changed: What|Removed |Added Attachment #95776|0 |1 is