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

raal <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
                 CC|                            |[email protected]
     Ever confirmed|0                           |1

--- Comment #1 from raal <[email protected]> ---
I can confirm with  Version: 4.5.0.0.alpha0+
Build ID: 51e0d789c344547956764c3b5f0ef5a304f4e0aa
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time:
2015-04-13_16:58:45

paste into cell:

=CONCATENATE(IF(BA3=1);"A";(IF(BA3=2);"B";(IF(BA3=3);"C";(IF(BA3=4);"D";(IF(BA3=5);"E";(IF(BA3=6);"F";(IF(BA3=7);"G";(IF(BA3=8);"H";(IF(BA3=9);"I";(IF(BA3=10);"J";(IF(BA3=11);"K";(IF(BA3=12);"L";(IF(BA3=13);"M";(IF(BA3=14);"N";(IF(BA3=15);"O";(IF(BA3=16);"P";(IF(BA3=17);"Q";(IF(BA3=18);"R";(IF(BA3=19);"S";(IF(BA3=20);"T";(IF(BA3=21);"U";(IF(BA3=22);"V";(IF(BA3=23);"W";(IF(BA3=24);"X";"Y")))))))))))))))))))))));RANDBETWEEN(5;17))

LO change into:
=CONCATENATE(IF(BA3=1);"A";(IF(BA3=2)~"B"~(IF(BA3=3)~"C"~(IF(BA3=4)~"D"~(IF(BA3=5)~"E"~(IF(BA3=6)~"F"~(IF(BA3=7)~"G"~(IF(BA3=8)~"H"~(IF(BA3=9)~"I"~(IF(BA3=10)~"J"~(IF(BA3=11)~"K"~(IF(BA3=12)~"L"~(IF(BA3=13)~"M"~(IF(BA3=14)~"N"~(IF(BA3=15)~"O"~(IF(BA3=16)~"P"~(IF(BA3=17)~"Q"~(IF(BA3=18)~"R"~(IF(BA3=19)~"S"~(IF(BA3=20)~"T"~(IF(BA3=21)~"U"~(IF(BA3=22)~"V"~(IF(BA3=23)~"W"~(IF(BA3=24)~"X"~"Y")))))))))))))))))))))));RANDBETWEEN(5;17))

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

Reply via email to