Description: Text which has been rotated through 90 Deg will not overflow into empty cells immediately above the rotated cells. Also, the alignment buttons on the toolbar transpose their effect so bottom aligned is equivalent to left-aligned on a horizontal cell whereas left-aligned becomes "top-aligned" for the text axis I don't necessarily consider the transposition of the alignment functions as a significant issue as they are easily correlated to the text flow. The row height appear to be automatically adjusted to "fit" the text length upon rotation but this is rarely the desired effect. The cells above the rotated cell can be "merged" but the rotation then has to be re-defined to achieve the display of full text Steps to Reproduce: Simple demo sheet attached Actual Results: Truncated text Expected Results: overflow text Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: Version: 7.0.4.2 (x64) Build ID: dcf040e67528d9187c66b2379df5ea4407429775 CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: sv-SE (en_GB); UI: en-GB Calc: threaded
Created attachment 168989 [details] Simple sheet demonstrating the effect
It may be that somebody will wish to redefine the impact as TRIVIAL
(In reply to Colin from comment #0) > The cells above the rotated cell can be "merged" but the rotation then has > to be re-defined to achieve the display of full text > I now realise this is due to the format being taken from the first or top cell so that is not a dubious action.
My view is that this is not a bug but standard behaviour. I have tested this in 7.0.3 and Excel and get the same behaviour. Basically, text overflow does not occur to cells above. As mentioned, there are two work arounds: merge the cell with those above; or increase the column height. Standard behaviour when you rotate text is for Calc to increase the row height to accommodate the rotated text. Excel does the same thing.
Whilst it's obviously a trivial, easily remedied effect, I suspect Excel is also flawed. Pour excessive water into any open container and it overflows. It doesn't really matter if the container is upright or has been knocked onto its side. It may also transpire that coding to incorporate physics could prove beneficial further along the development path. However, I would agree that if trying to emulate the laws of physics destroys or seriously impacts the ability to "Save as Excel" then it should be reassessed as either NOTABUG or WON'TFIX.
Hi Colin, Thanks for the response. I suspect that this issue needs to be decided by someone above my pay grade. I would, however, like to add a couple of problems with your suggestion. (1) Changing the behaviour of Calc to flow upward would have legacy issues for existing spreadsheets. Unfortunately, some people may be relying on the existing behaviour. (2) I decided to do something similar to rotating text - I increased the font size on standard non rotated text. Again the column height increased automatically and when I reduced the column height the top of the text did NOT display in the empty cells above. I suspect that the horizontal truncation of text if there is insufficient head room is a long standing legacy behaviour. The way forward with this problem requires someone with more product history than me. Regards…. Peter.
Hi Peter, I must confess, I hadn't considered the legacy issue if a user had already taken mitigating steps. I guess I must be a selfish Pom;) Best regards, Colin
Consulted with buovjaga and no further action required.