Launchpad has imported 3 comments from the remote bug at https://bugs.freedesktop.org/show_bug.cgi?id=52138.
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 2012-07-16T07:18:56+00:00 ENigma885 wrote: Created attachment 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 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1132531/comments/0 ------------------------------------------------------------------------ On 2012-07-16T08:12:51+00:00 Libreoffice-z wrote: User error, not a bug! @enigma_pentag...@yahoo.com: "###" simply shows that the column is too narrow, will be replaced by correct Date information when you increase column width. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1132531/comments/1 ------------------------------------------------------------------------ On 2012-07-16T08:19:50+00:00 ENigma885 wrote: (In reply to comment #1) > User error, not a bug! > > @enigma_pentag...@yahoo.com: > "###" simply shows that the column is too narrow, will be replaced by correct > Date information when you increase column width. It's not that apparent to notice indeed. So, I think the proper behavior should be displaying part of the date as an indication that the rest is hidden due to space limitation or popping out a message to tell the user that s/he needs to increase the width/length of the cell to display its content. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1132531/comments/2 ** Changed in: df-libreoffice Status: Unknown => Invalid ** Changed in: df-libreoffice Importance: Unknown => Medium -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1132531 Title: Use an arrow to show the date is too large to fit the column, instead of ### To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1132531/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs