desktop-packages team mailing list archive

[Bug Watch Updater <391572@xxxxxxxxxxxxxxxxxx>]

Launchpad has imported 6 comments from the remote bug at
https://bugs.freedesktop.org/show_bug.cgi?id=37978.

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 2011-06-06T10:00:28+00:00 Marcsinclair wrote:

After nearly TEN YEAR of this BUG in Open Office - perhaps Libreoffice
has the will to do something about it -

The issue is that date handling in the spreadsheet is a dogs breakfast.

1 - Open a new Spreadsheet on a machine with ISO dates as the native date
format

2 - Enter the (valid) date 2011-06-05into a cell

3 - Press return

4 - cell shows 05/06/11 (whatever that means, is it May, June or
November?)

5 - Select the cell

6 - The Input line now says 05/06/2011 (aha! so it is either May or
June)

7 - Double click the cell and it changes to the second format 02/01/2008 
trying to edit in this unusual format is problematic and almost useless for practical puposes.

Marc

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/391572/comments/1

------------------------------------------------------------------------
On 2011-06-06T10:06:13+00:00 Marcsinclair wrote:

After nearly TEN YEAR of this BUG in Open Office - perhaps Libreoffice has the
will to do something about it -

The issue is that date handling in the spreadsheet is a dogs breakfast.

1 - Open a new Spreadsheet on a machine with ISO dates as the native date
format

2 - Enter the (valid) date 2011-06-05into a cell

3 - Press return

4 - cell shows 05/06/11 (whatever that means, is it May, June or
November?)

5 - Select the cell

6 - The Input line now says 05/06/2011 (aha! so it is either May or
June)

7 - Double click the cell and it changes to the second format 05/06/2011#
trying to edit in this unusual format is problematic and almost useless for
practical purposes.

Marc

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/391572/comments/2

------------------------------------------------------------------------
On 2011-12-21T17:04:06+00:00 Erack wrote:

*** Bug 41042 has been marked as a duplicate of this bug. ***

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/391572/comments/4

------------------------------------------------------------------------
On 2011-12-21T17:08:39+00:00 Erack wrote:

Fixed in master
http://cgit.freedesktop.org/libreoffice/core/commit/?id=6c37252eb93db161edfd234696604774e9ee1d8c
and 3-5
http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-3-5&id=9c1d304d0df21b6ae63dbd4db737f0d21a51f227

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/391572/comments/5

------------------------------------------------------------------------
On 2011-12-21T18:42:27+00:00 Freedesktop-org wrote:

> Fixed in master
> 

I cannot believe it! This has been one of three or four serious show-
stoppers in OOo for the organizations where I have integrated OOo. I
really thought that we would never see it fixed.

Eike, your work is very, very appreciated! Thank you!

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/391572/comments/6

------------------------------------------------------------------------
On 2011-12-22T11:09:12+00:00 Mike Evans wrote:

Thank you for fixing this bug.  I too have been waiting many years for
this fix.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/391572/comments/9


** Changed in: df-libreoffice
       Status: Unknown => Fix Released

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

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

Title:
  [Upstream] Edit Date format does not match configured date format

Status in LibreOffice Productivity Suite:
  Fix Released
Status in The OpenOffice.org Suite:
  Unknown
Status in “libreoffice” package in Ubuntu:
  Fix Committed
Status in “openoffice.org” package in Ubuntu:
  Won't Fix

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

  When editing a date in Calc, the date format used to edit the date
  does not match the date format configured for the cell.

  Steps to reproduce:
  1) Right-Click on a cell -> Format Cells -> Numbers -> Category -> Date -> Choose format 31/12/1999
  2) Enter into that cell my wedding day: September 2, 2005: 2/9/2005

  What is displayed?
  February 9, 2005: the day of a car bombing.

  What is expected to be displayed?
  September 2, 2005: my wedding day.

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