https://bugs.documentfoundation.org/show_bug.cgi?id=92474
--- Comment #10 from Yann Dumont <[email protected]> --- I do more testing, again : - I test if the bug is reproducible with other logic function. OR, AND, XOR, IFERROR and IFNA are not affected. - behavior of formula =IF(TRUE();"true";"false") when copy-pasted is CORRECT - behavior of formula =IF(EXACT(LEFT(B2;10);"complement");"true";"false") when copy-pasted is INCORRECT - behavior of formula =IF(EXACT("same";"same");"true";"false") when copy-pasted is CORRECT - behavior of formula =EXACT(LEFT(B2;10);"complement") when copy-pasted is INCORRECT - behevior of formula =EXACT(LEFT(B2;10);"complement") when copy-pasted from one sheet to another from the same file, or simply copied in the same file, is CORRECT So, bug come from EXACT(;) function, not from IF(;;) ! EXACT() returns systematically FALSE() when cell is copied or cell's sheet is copied from one file to another, but not in the same document. >From there, I think it is out of my competences. I consider changing the title of the bug, but I am not really familiar with conditions needed to do so. Is it okay ? Does this need a higher importance, too ? And is it confirmed on other versions of LO ? (simple test is using =IF(EXACT("same";"same");"true";"false") formula) -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
