https://bugs.documentfoundation.org/show_bug.cgi?id=106766
Bug ID: 106766
Summary: text(0,"#") returns empty text, rather than the text
"0".
Product: LibreOffice
Version: 5.2.6.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: genetics_...@hotmail.com
Description:
The text() function with the pound-sign format appears to handle the number
zero improperly. Instead of displaying the number in text form, as it does
with the other numbers, the resulting cell is blank.
It is returning something at least, since the formula =istext(text(0,"#"))
returns "TRUE".
The issue only exists with the format parameter given with the pound sign. The
formula =text(0,"0") returns the text "0" as expected. Since by design "0"
shows leading zeros and "#" doesn't show leading zeros, it appears that "#"
eats the zero even if it is the only character in the number.
Steps to Reproduce:
The formula =text(0,"#").
Actual Results:
"" - a blank text string
Expected Results:
The text "0".
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs