Performing {SUM(Len(B7:B11))} against empty cells produces a non-zero result
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Fix Released
|
Medium
|
|||
libreoffice (Ubuntu) |
Fix Released
|
Medium
|
Unassigned |
Bug Description
1) lsb_release -rd
Description: Ubuntu Trusty Tahr (development branch)
Release: 14.04
2) apt-cache policy libreoffice-calc
libreoffice-calc:
Installed: 1:4.2.0-0ubuntu1
Candidate: 1:4.2.0-0ubuntu1
Version table:
1:
400 http://
*** 1:4.2.0-0ubuntu1 0
500 http://
100 /var/lib/
3) What is expected to happen in Calc via a terminal:
cd ~/Desktop && wget -c https:/
is cell B12 is 0, as it is in Gnumeric and Microsoft Office Excel 2003 (11.5612.8172).
4) What happens instead is it is 5.
---
ApportVersion: 2.12.5-0ubuntu2.2
Architecture: amd64
DistroRelease: Ubuntu 13.10
MarkForUpload: True
Package: libreoffice 1:4.1.3-0ubuntu1
PackageArchitec
ProcVersionSign
Tags: saucy
Uname: Linux 3.11.0-15-generic x86_64
UpgradeStatus: Upgraded to saucy on 2013-11-15 (75 days ago)
UserGroups: adm cdrom dip lpadmin plugdev sambashare sudo wireshark www-data
Changed in libreoffice (Ubuntu): | |
status: | Incomplete → New |
Changed in df-libreoffice: | |
importance: | Unknown → Medium |
status: | Unknown → New |
summary: |
- Array formula bug SUM(Len(A2:A200)) adds empty cells + Performing {SUM(Len(B7:B11))} against empty cells produces a non-zero + result |
description: | updated |
tags: | added: amd64 trusty |
Changed in libreoffice (Ubuntu): | |
importance: | Undecided → Medium |
status: | New → Triaged |
Changed in df-libreoffice: | |
status: | New → Confirmed |
Changed in df-libreoffice: | |
status: | Confirmed → Fix Released |
Changed in libreoffice (Ubuntu): | |
status: | Triaged → Fix Released |
apport-collect 1273659 /launchpad. net/+authorize- token?. ..N)
The authorization page:
(https:/
should be opening in your browser. Use your browser to authorize
this program to access Launchpad on your behalf.
Press any key to continue or wait (5) seconds...
Waiting to hear from Launchpad about your decision...
(process:7620): GLib-CRITICAL **: g_slice_set_config: assertion 'sys_page_size == 0' failed
Package libreoffice not installed and no hook available, ignoring