desktop-packages team mailing list archive

[Jeffrey Panczyk <218835@xxxxxxxxxxxxxxxxxx>]

Thanks for the heads up.  Yes, I see that it works properly in
LibreOffice.  I guess we can close this one.

Jeff


________________________________
From: Christopher M. Penalver <christopher.penalver@xxxxxxx>
To: jpanczyk23@xxxxxxxx
Sent: Tuesday, August 16, 2011 3:28:08 PM
Subject: [Bug 218835] Re: [upstream] [hardy] calc: Valid values in drop down displayed incorrectly

Jeffrey Panczyk, this issue is unreproducible in LibreOffice Calc. Does
this work for you? If using Lucid or Maverick feel free to perform at
the Terminal:

sudo add-apt-repository ppa:libreoffice/ppa && sudo apt-get update &&
sudo apt-get -y upgrade && sudo apt-get -y install libreoffice-calc

lsb_release -rd
Description:    Ubuntu 11.04
Release:    11.04

apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.3-1ubuntu2
  Candidate: 1:3.3.3-1ubuntu2
  Version table:
*** 1:3.3.3-1ubuntu2 0
        100 /var/lib/dpkg/status
     1:3.3.2-1ubuntu5 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages
     1:3.3.2-1ubuntu4 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages

** Also affects: libreoffice (Ubuntu)
   Importance: Undecided
       Status: New

** Changed in: libreoffice (Ubuntu)
       Status: New => Incomplete

-- 
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/218835

Title:
  [upstream] [hardy] calc: Valid values in drop down displayed
  incorrectly

To manage notifications about this bug go to:
https://bugs.launchpad.net/openoffice/+bug/218835/+subscriptions

-- 
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/218835

Title:
  [upstream] [hardy] calc: Valid values in drop down displayed
  incorrectly

Status in The OpenOffice.org Suite:
  Confirmed
Status in “libreoffice” package in Ubuntu:
  Incomplete
Status in “openoffice.org” package in Ubuntu:
  Triaged

Bug description:
  Binary package hint: openoffice.org-calc

  openoffice.org-calc

  $ lsb_release -rd
  Description:	Ubuntu 8.04
  Release:	8.04

  $ apt-cache policy openoffice.org-calc
  openoffice.org-calc:
    Installed: 1:2.4.0-3ubuntu5
    Candidate: 1:2.4.0-3ubuntu5
    Version table:
   *** 1:2.4.0-3ubuntu5 0
          500 http://archive.ubuntu.com hardy/main Packages
          100 /var/lib/dpkg/status


  
  Expectation:  Date values in drop downs should be shown as dates
  What happened:  Values were shown as integers

  Procedure:
  1) Create a new spreadsheet.
  2) Highlight Cells A1,A2, and A3.  Select Format->Cells, click Data, and Click OK
  3) Enter the following values in the following cells:
      A1: 1/1/2008
      A2: 1/2/2008
      A3: 1/3/2008
  4) Click on Cell A1.   Select Data->Validity.    Change Allow from "All Values" to "Cell range".  Put A2:A3 in the Source Field, and click OK.
  5) Click on the dropdown arrow beside cell A1.  The available values are printed as integers, where they should be shown in the proper date format.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openoffice/+bug/218835/+subscriptions