Launchpad has imported 3 comments from the remote bug at
https://www.libreoffice.org/bugzilla/show_bug.cgi?id=72969.

If you reply to an imported comment from within Launchpad, your comment
will be sent to the remote bug automatically. Read more about
Launchpad's inter-bugtracker facilities at
https://help.launchpad.net/InterBugTracking.

------------------------------------------------------------------------
On 2013-12-22T13:21:33+00:00 Ray DeCampo wrote:

Created attachment 91124
Example spreadsheet as in the bug description

Problem description:

When adding formatting, e.g. borders, to a cell, the string value of the
cell is affected.

Steps to reproduce:

See attached spreadsheet.  The first line has no formatting and behaves
as expected.  The second line has a border on cell B2 and the value of
that cell is affected.

Current behavior:

Cell C2 displays the value "Failed".
If the value of cell B2 is copied and pasted as text the value pasted is 
"foobar ".

Expected behavior:

Cell C2 displays the value "Passed" like the cell C1.  
If the value of cell B2 is copied and pasted as text the value pasted is 
"foobar".


Operating System: Ubuntu
Version: 4.1.3.2 release

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/comments/6

------------------------------------------------------------------------
On 2013-12-22T13:23:54+00:00 Ray DeCampo wrote:

I forgot to clarify in the original description, the issue began
manifesting when I upgraded from Ubuntu 13.04 to 13.10.  I believe the
version of LibreOffice for 13.04 is 4.0.2.

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/comments/7

------------------------------------------------------------------------
On 2013-12-22T17:07:20+00:00 Christopher M. Penalver wrote:

Raymond DeCampo, thank you for reporting this. Would you please be able
to bibisect this problem following
https://wiki.documentfoundation.org/QA/HowToBibisect ? This would help
tremendously in resolving this bug.

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/comments/9


** Changed in: df-libreoffice
       Status: Unknown => Confirmed

** Changed in: df-libreoffice
   Importance: Unknown => Medium

-- 
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.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

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to     : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp

Reply via email to