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 <[email protected]> To: [email protected] 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 -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
