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 Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1132531 Title: Use an arrow to show the date is too large to fit the column, instead of ### Status in LibreOffice Productivity Suite: Invalid Status in One Hundred Paper Cuts: Confirmed Status in “libreoffice” package in Ubuntu: Confirmed Bug description: When characters do not fit in the default column size, Calc displays ### rather than cutting off the text. This is a feature so you know that there is more data. Instead possibly an arrow can be shown to signify there is more data. This is probably good behavior for numbers which could be interpreted a being complete even though they are not, but dates might be considered different. Open the example spreadsheet provided and take a look at the first column filled with dates in ascending order. All the cells for Wednesdays are displayed as "###" where I would expect something like "Wed 08.03 13" ProblemType: Bug DistroRelease: Ubuntu 12.10 Package: libreoffice-calc 1:3.6.2~rc2-0ubuntu4 ProcVersionSignature: Ubuntu 3.5.0-18.29-generic 3.5.7 Uname: Linux 3.5.0-18-generic x86_64 ApportVersion: 2.6.1-0ubuntu10 Architecture: amd64 Date: Sun Feb 24 20:59:00 2013 EcryptfsInUse: Yes InstallationDate: Installed on 2012-08-13 (195 days ago) InstallationMedia: Xubuntu 12.04 LTS "Precise Pangolin" - Release amd64 (20120425) MarkForUpload: True ProcEnviron: TERM=xterm PATH=(custom, no user) XDG_RUNTIME_DIR=<set> LANG=en_US.UTF-8 SHELL=/bin/bash SourcePackage: libreoffice UpgradeStatus: Upgraded to quantal on 2012-10-19 (128 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1132531/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp