https://bugs.documentfoundation.org/show_bug.cgi?id=92474
Bug ID: 92474
Summary: Copy-paste of formula breaks IF function
Product: LibreOffice
Version: 4.4.4.2 rc
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: yann.dumo...@gmail.com
While formatting data on different files, I copy-paste this formula from on
file (ODS) to another (CSV I will save in ODS later) :
=SI(EXACT(GAUCHE(B3;10);"complement");CNUM(GAUCHE(DROITE(B3;18);7));CNUM(GAUCHE(B3;7)))
With English formula
=IF(EXACT(LEFT(B3;10);"complement");VALUE(LEFT(RIGHT(B3;18);7));VALUE(LEFT(B3;7)))
Then the results obtained when the SI/IF first argument is TRUE (B3 cell or
other cells under contain "complement"), the results obtained are "Err:502".
Everything works as if the first argument of SI/IF returns FALSE, even if it
may be TRUE. Since the string still contains text after processing by the third
argument of SI/IF, "Err:502" is quite normal there.
I find a... by-pass ? (I can't remember the correct word in English) : adding
spaces on each sides of the ";" of the SI/IF function reestablished the correct
behaviour of SI/IF.
Version: 4.4.4.2
Build ID: 40m0(Build:2)
Locale : fr_FR.UTF-8
Debian unstable distribution
Not tested on other environment
--
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
