[Libreoffice-bugs] [Bug 100220] Result of the Combination IF() and AND()

[bugzilla-daemon]

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

Aron Budea  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |DUPLICATE

--- Comment #5 from Aron Budea  ---
Reopened bug 75650. Closing this as duplicate.

*** This bug has been marked as a duplicate of bug 75650 ***

-- 
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 100220] Result of the Combination IF() and AND()

[bugzilla-daemon]

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

Aron Budea  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=75
   ||650

-- 
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 100220] Result of the Combination IF() and AND()

[bugzilla-daemon]

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

--- Comment #4 from Aron Budea  ---
Created attachment 125516
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125516=edit
Schrödinger's cat

Got an e-mail from h7rojas with some details, thanks. My conclusion is a bit
different, though (the information I got is that it occurs in 64-bit, but not
in 32-bit).

Before I spoil the details, see attachment, and in particular formula/values C1
and C2.

Spolier:
C1 is formatted as Boolean value, and 150 is TRUE if it's displayed as boolean.
However, I didn't format it as such. What happens is that if you first input a
boolean formula in the field, it's displayed as Boolean value, if you later
change it to a numerical formula, the display format doesn't change, and the
result is displayed as boolean.

I'm leaning towards considering this a bug, but there are many different cases
here with different display formats, and automatically adjusting the display
format might not work in all cases.

-- 
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 100220] Result of the Combination IF() and AND()

[bugzilla-daemon]

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

Aron Budea  changed:

   What|Removed |Added

 CC||ba...@caesar.elte.hu

--- Comment #3 from Aron Budea  ---
Can you? I couldn't, and see 150 in 5.1.3.2 as well.
The formula translates to this in English, right?: =IF(AND(B1 > A1; B1 < A2);
B1; "")

Could you or h7rojas upload it as a sample document?

An unrelated, interesting observation:
Is it normal that copy-pasting between different Calc instances (eg. multiple
different versions running), the formula is evaluated, and pasted as 150?
Only when it's the same Calc (different or same files, doesn't matter) the
formula transferred as a formula.

-- 
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 100220] Result of the Combination IF() and AND()

[bugzilla-daemon]

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

Julien Nabet  changed:

   What|Removed |Added

 CC||serval2...@yahoo.fr

--- Comment #2 from Julien Nabet  ---
On pc Debian x86-64 with LO Debian package 5.1.3.2, I could reproduce this but
I don't reproduce with LO master sources updated today.

-- 
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 100220] Result of the Combination IF() and AND()

[bugzilla-daemon]

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

--- Comment #1 from h7ro...@gmail.com ---
Created attachment 125488
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125488=edit
Screen Capture

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