The characters do not fit in the default column size so Calc displays ### rather than cutting off the text. This is a feature so you know that there is more data. The column must default to a set size and there is no good argument to widen them just so that this format fits, for starters its a user defined format that Jesusfreak has defined not a standard Calc format. Even if it was a Calc format you need to draw the line somewhere for example "Wednesday, 6 March 2013" is almost twice as long.
I hope this clarifies why I marked the bug as invalid. The "make it easy for new users" line is valid sometimes and other times user just need to learn how the software works. This is one of those other times. -- 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: Error in date format for Wednesday Status in One Hundred Paper Cuts: Invalid Status in “libreoffice” package in Ubuntu: Invalid Bug description: 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/hundredpapercuts/+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
