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@lists.freedesktop.org ReportedBy: enigma_pentag...@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. _______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs