https://bugs.freedesktop.org/show_bug.cgi?id=60773

          Priority: medium
            Bug ID: 60773
          Assignee: [email protected]
           Summary: [regression] FORMATTING: date format fields are not
                    formatted automatically
          Severity: major
    Classification: Unclassified
                OS: Linux (All)
          Reporter: [email protected]
          Hardware: All
            Status: UNCONFIRMED
           Version: 4.0.0.3 release
         Component: Spreadsheet
           Product: LibreOffice

If you enter values into date formatted columns no autoformat happens. Thus you
have to enter a fully qualified date, although in recent versions either a day
or a day-month-combination was reformatted to be either a day of the current
month or a day-month of the current year.

This saved lots of typing in bigger lists with date values /e.g. for
accounting/.

It is a regression in 3.6.5 and 4.0Release seen on Ubuntu and MacOS X.

How to reproduce:
* open a new spreadsheet
* format one column to be a date YYYY-mm-dd
* enter the following values to verify:
- 13. - no reformatting happens
- 13.2 - no reformatting happens
- 13.2.2013 - is formatted to YYYY-mm-dd

* if you enter these values and apply cell formatting afterwards the first two
inputs are not formatted into date values

Expected behaviour:
In versions prior to 3.6.5 and 4.0Release a date was automatically formatted if
entered in a spreadsheet, thus
- 13. => current month, e.g. 2013-02-13
- 13.2 => reformatted to a valid date: 2013-02-13
- 13.2.2013 => reformatted to a valid date: 2013-02-13

This bug is very annoying if you enter many values in lists because you have to
type much more to have an appropriately formatted input for date values.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to