https://bugs.documentfoundation.org/show_bug.cgi?id=97232
Bug ID: 97232
Summary: When file link, string connect with number, not work
Product: LibreOffice
Version: 5.2.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
When over file link connect a text with a number, it show only the text not the
number.
E.g. ='file:///./Verkn-Quelldatei.ods'#$Sheet1.C2 & " " &
'file:///./Verkn-Quelldatei.ods'#$Sheet1.B2
When (String)C2="Is a string" and (number)B2=150 then it shows: Is a string
and the number 150 is missing.
A Workaround is:
='file:///./Verkn-Quelldatei.ods'#$Sheet1.C2 & " " &
TEXT('file:///./Verkn-Quelldatei.ods'#$Sheet1.B2; "######,#")
It shows right: Is a string 150
Look to the file examples
--
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
