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
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 ###.
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 ***