← Back to team overview

desktop-packages team mailing list archive

[Bug 1263326] Re: [Upstream] IF function not evaluating correctly with cell borders in .ods

 

** Bug watch added: freedesktop.org Bugzilla #72969
   https://bugs.freedesktop.org/show_bug.cgi?id=72969

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1263326

Title:
  [Upstream] IF function not evaluating correctly with cell borders in
  .ods

Status in LibreOffice Productivity Suite:
  Confirmed
Status in “libreoffice” package in Ubuntu:
  Triaged

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.1.3-0ubuntu2
    Candidate: 1:4.1.3-0ubuntu2
    Version table:
   *** 1:4.1.3-0ubuntu2 0
          500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages
          100 /var/lib/dpkg/status

  3) What is expected to happen via a terminal:
  cd ~/Desktop && wget https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+attachment/3934242/+files/bug-format-affects-value.ods && localc --nologo bug-format-affects-value.ods

  is that cells C1 and C2 both show Passed.

  4) What happens instead is that cell C2 shows Failed.

  WORKAROUND: Insert a row, and then remove the row.

  ProblemType: Bug
  DistroRelease: Ubuntu 13.10
  Package: libreoffice-calc 1:4.1.3-0ubuntu1
  ProcVersionSignature: Ubuntu 3.11.0-14.21-generic 3.11.7
  Uname: Linux 3.11.0-14-generic x86_64
  NonfreeKernelModules: nvidia
  ApportVersion: 2.12.5-0ubuntu2.2
  Architecture: amd64
  Date: Sat Dec 21 07:59:29 2013
  InstallationDate: Installed on 2012-11-18 (397 days ago)
  InstallationMedia: Ubuntu 12.10 "Quantal Quetzal" - Release amd64 (20121017.5)
  MarkForUpload: True
  ProcEnviron:
   LANGUAGE=en_US
   PATH=(custom, no user)
   XDG_RUNTIME_DIR=<set>
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+subscriptions