Public bug reported:
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
ProcVersionSignature: Ubuntu 4.4.0-43.63-generic 4.4.21
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)
** Affects: libreoffice (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug xenial
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1638465
Title:
TEXT ignores 0 (naught)
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1638465/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
