| Summary: | CALC Vertically aligned text does not overflow | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Colin <that.man.colin> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | peter |
| Priority: | medium | ||
| Version: | 7.0.4.2 release | ||
| Hardware: | All | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Simple sheet demonstrating the effect | ||
|
Description
Colin
2021-01-18 11:47:26 UTC
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. |