[Libreoffice-bugs] [Bug 52138] New: FORMATTING: Some Date Formats show "###" instead of the date.

[bugzilla-daemon at freedesktop.org]

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

             Bug #: 52138
           Summary: FORMATTING: Some Date Formats show "###" instead of
                    the date.
    Classification: Unclassified
           Product: LibreOffice
           Version: 3.5.5.2 rc
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
 Status Whiteboard: BSA
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: enigma_pentagram at yahoo.com


Created attachment 64260
  --> https://bugs.freedesktop.org/attachment.cgi?id=64260
a screenshot of the described problem

**Problem description: 
- Trying to change the date formate in a cell or a grp of cells yields "###"
- Date formats yielding the aforementioned result are:
NNNNMMMM DD, YYYY; MM/DD/YYYY; MMM D, YYYY; D. MMM. YYYY; MMMM D, YYYY; D. MMMM
YYYY; NN, MMM D, YY; NN DD/MMM YY; NN, MMMM D, YYYY; NNNNMMMM D, YYYY;
YYYY-MM-DD; QQ YY; MM/DD/YY HH:MM AM/PM; MM/DD/YYYY HH:MM:SS; [~jewish]NNNND
MMMM YYYY; [~jewish]NNNNMMMM D YYYY; [~jewish]NN MMMM D YYYY; [~jewish]NN D
MMMM YYYY; [~jewish]D MMMM YYYY; [~jewish]MMMM D YYYY; [~jewish]MMMM YYYY
- Date formats working properly are: 
M/D/YY; MM/DD/YY; MMM D, YY; MM-DD; YY-MM-DD; MM/YY; MMM DD; MMMM; WW;
[~jewish]D MMMM;  [~jewish]MMMM D; [~jewish]MMMM

**Steps to reproduce:
1. Create a new Calc sheet
2. Write down a date separating month, day, year by slashes like 03/01/2012
3. Go to Format>>Cells (or press ctrl+1)
4. In Numbers tab, choose Date from Category and then try the date formats
mentioned as yielding ### in the Problem Description section.

**Current behavior: Dates are displayed as ###

**Expected behavior: To display dates in the chosen formats

**Platform (if different from the browser): Ubuntu 12.04

**Note: LO version is LibreOffice 3.5.5.2 Build ID: 350m1(Build:2) installed
using “LibreOffice Packaging” team PPA @
https://launchpad.net/~libreoffice/+archive/ppa

**Browser: Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:13.0) Gecko/20100101
Firefox/13.0.1

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.