Hi. I need to show a date in the same cell, in two lines, and centered.
Centered is not possible.
| january |
| monday 28 |
Look what happens in this video:
Hi Victor, thanks for reporting,
Version 18.104.22.168 (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 ###.
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.
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.
Workaround: use TEXT( date ; format ) to convert your date in a string which could be wrapped and centered
*** This bug has been marked as a duplicate of bug 40685 ***