https://bugs.freedesktop.org/show_bug.cgi?id=75886
Priority: medium
Bug ID: 75886
Assignee: [email protected]
Summary: Concatentation of Boolean and String is not consistent
with Microsoft Office behaviour
Severity: major
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.1.5.3 release
Component: Spreadsheet
Product: LibreOffice
Issue
-----
It seems that when Microsoft Excel evaluates a cell formula like
="hello"&TRUE()
it becomes the string
helloTRUE
but when LibreOffice Calc evaluates this it becomes
hello1
A similar issue appears when evaluating ="hello"&FALSE()
I'm not sure sure what the correct behaviour is but I tried
- Microsoft Excel for Mac 2011, Version 14.3.9 (131030)
- Microsoft Excel 2007
and both evaluated the formula to the string helloTRUE.
Steps to reproduce
------------------
1. Start LibreOffice Calc and create a new spreadsheet
2. Enter the following formula into the cell
="hello"&TRUE()
LibreOffice Calc will evaluate this to the string hello1
3. Try evaluating the same formula in Microsoft Office and it will evaluate to
the string helloTRUE
Additional remarks
------------------
I came across this issue because of a spreadsheet I was given that concatenates
a string coming from a another cell and a bool coming from a checkbox in the
spreadsheet. The resulting string is then searched for in a table using
VLOOKUP(). Because Libreoffice calc does not treat the boolean in the same way
as Microsoft Office the VLOOKUP() fails.
I'm not sure what is the better behaviour when converting a bool to a string
but at the very least LibreOffice should do the same thing that Microsoft
Office does when handling Microsoft Office files (in my case it was .xls
format).
Of course I can work around this by having a formula like...
="hello"&( if( FORMULA,"TRUE","FALSE") )
I'd rather not do that though...
--
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
