** Summary changed:
- [upstream] OOo Calc displays -0 when the cell is formated as fraction
+ [upstream] Calc displays -0=-1*0
** Also affects: libreoffice (Ubuntu)
Importance: Undecided
Status: New
** Attachment added: "example.ods"
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/360836/+attachment/2154833/+files/example.ods
** Description changed:
Binary package hint: openoffice.org
- When the cell format is set to "Fraction" or "scientific" it will display
minus zero (which doesn't make much sense), for instance:
- Let A1 be -1 and A2 be 0
- If A3 is =A1*A2 then the answer given is:
- in fraction mode ==> -0 (minus zero)
- in scientific mode ==> -0,00E+000
+ 1) lsb_release -rd
+ Description: Ubuntu 11.04
+ Release: 11.04
+
+ 2) apt-cache policy libreoffice-calc
+ libreoffice-calc:
+ Installed: 1:3.3.2-1ubuntu5
+ Candidate: 1:3.3.2-1ubuntu5
+ Version table:
+ *** 1:3.3.2-1ubuntu5 0
+ 500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386
Packages
+ 100 /var/lib/dpkg/status
+ 1:3.3.2-1ubuntu4 0
+ 500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages
+
+ 3) What is expected to happen in LibreOffice Writer via the Terminal:
+
+ cd ~/Desktop && wget
+
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/360836/+attachment/2154833/+files/example.ods
+ && localc -nologo example.ods
+
+ is
+ cell A1=-1
+ cell A2 =0
+ cell A3 0=A1*A2
+
+ 4) What happens instead is cell A3 shows -0.
+
+ WORKAROUND: Use Gnumeric.
+
+ apt-cache policy gnumeric
+ gnumeric:
+ Installed: 1.10.13-1ubuntu1
+ Candidate: 1.10.13-1ubuntu1
+ Version table:
+ *** 1.10.13-1ubuntu1 0
+ 500 http://us.archive.ubuntu.com/ubuntu/ natty/universe i386 Packages
+ 100 /var/lib/dpkg/status
ProblemType: Bug
Architecture: i386
Dependencies:
-
+
DistroRelease: Ubuntu 9.04
Package: openoffice.org None [modified:
/var/lib/dpkg/info/openoffice.org.list]
ProcEnviron:
- LANG=es_AR.UTF-8
- SHELL=/bin/bash
+ LANG=es_AR.UTF-8
+ SHELL=/bin/bash
SourcePackage: openoffice.org
Uname: Linux 2.6.28-11-generic i686
UnreportableReason: Este no es un paquete Ubuntu genuino
** Tags added: lo33
** Changed in: libreoffice (Ubuntu)
Importance: Undecided => Low
** Changed in: libreoffice (Ubuntu)
Status: New => Triaged
** Changed in: openoffice.org (Ubuntu)
Importance: Medium => Low
** Bug watch added: freedesktop.org Bugzilla #37925
http://bugs.freedesktop.org/show_bug.cgi?id=37925
** Also affects: df-libreoffice via
http://bugs.freedesktop.org/show_bug.cgi?id=37925
Importance: Unknown
Status: Unknown
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/360836
Title:
[upstream] Calc displays -0=-1*0
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
