Bug 59997

Summary: FORMATTING Dates in Calc
Product: LibreOffice Reporter: Victor <vmena19>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: enhancement    
Priority: medium CC: mariosv
Version: 4.0.0.2 rc   
Hardware: Other   
OS: All   
Whiteboard:
i915 platform: i915 features:

Description Victor 2013-01-29 01:38:23 UTC
Hi. I need to show a date in the same cell, in two lines, and centered.
Centered is not possible.
Example:
|-----------|
|  january  |
| monday 28 |
|-----------|

Look what happens in this video:

https://docs.google.com/file/d/0B3va26fKWcqKcmd2MUtBcmNLNUU/edit

Thank you

Victor
Comment 1 m.a.riosv 2013-01-30 02:16:01 UTC
Hi Victor, thanks for reporting,

Reproducible with:
Win7x64 Ultimate
Version 4.0.0.2 (Build ID: 5991f37846fc3763493029c4958b57282c2597e)

In one cell enter a date: 28/1/2013
Format the cell:
Number: DDDD DD MMMM
Alignment: Horizontal= Center, Enable Wrap text automatically.
 
Seems that the row height is calculated, but the cell only shows ###.
Comment 2 Daniel Bankston 2013-02-05 07:20:20 UTC
Hi, Victor, I think the video was a nice touch to demonstrate your issue.

If I understand correctly, I think this is maybe more of an enhancement request and not a bug because the user is able to center the date by selecting Align Center Horizontally.  The user just can't center separate parts of the date on separate lines within the same cell.
Comment 3 Kohei Yoshida (inactive) 2013-02-06 03:49:13 UTC
Yup, this is an enhancement request.

This is a known limitation, and is not a bug.  It would be extremely difficult to handle wrapping of date values since date values themselves are numeric values internally, and we don't wrap numeric values in cells.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.