TEXT ignores 0 (naught)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
libreoffice (Ubuntu) |
New
|
Undecided
|
Unassigned |
Bug Description
To reproduce:
Type the following formula into a cell:
=TEXT(0;"#")
Note that there is an output of an empty text.
What i expect to happen:
When naught is translated into the text, i would expect the output to be "0". This causes strange behaviour in more complicated formula.
ProblemType: Bug
DistroRelease: Ubuntu 16.04
Package: libreoffice-calc 1:5.1.4-0ubuntu1
ProcVersionSign
Uname: Linux 4.4.0-43-generic x86_64
ApportVersion: 2.20.1-0ubuntu2.1
Architecture: amd64
CurrentDesktop: XFCE
Date: Wed Nov 2 08:43:12 2016
InstallationDate: Installed on 2015-01-19 (652 days ago)
InstallationMedia: Xubuntu 14.04.1 LTS "Trusty Tahr" - Release amd64 (20140723)
SourcePackage: libreoffice
UpgradeStatus: Upgraded to xenial on 2016-07-29 (95 days ago)