Use an arrow to show the date is too large to fit the column, instead of ###
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Invalid
|
Medium
|
|||
One Hundred Papercuts |
Won't Fix
|
Low
|
Unassigned | ||
libreoffice (Ubuntu) |
Won't Fix
|
Low
|
Unassigned |
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~
ProcVersionSign
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_
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to quantal on 2012-10-19 (128 days ago)
summary: |
- Error in date format for Wednesday + Use an arrow to show the date is too large to fit the column, instead of + ### |
description: | updated |
Changed in hundredpapercuts: | |
status: | Invalid → Confirmed |
Changed in libreoffice (Ubuntu): | |
status: | Invalid → Confirmed |
Changed in hundredpapercuts: | |
importance: | Undecided → Medium |
Changed in libreoffice (Ubuntu): | |
importance: | Undecided → Wishlist |
Changed in df-libreoffice: | |
importance: | Unknown → Medium |
status: | Unknown → Invalid |
Changed in libreoffice (Ubuntu): | |
importance: | Wishlist → Low |
Changed in hundredpapercuts: | |
importance: | Medium → Low |
status: | Confirmed → Triaged |
Changed in libreoffice (Ubuntu): | |
status: | Won't Fix → Triaged |
tags: | added: needs-coding |
Changed in hundredpapercuts: | |
assignee: | Papercuts Ninjas (papercuts-ninja) → nobody |
status: | Triaged → Won't Fix |
Changed in libreoffice (Ubuntu): | |
status: | Triaged → Won't Fix |
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/~libreoffic e/+archive/ ppa
**Browser: Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:13.0) Gecko/20100101 Firefox/13.0.1