Description: I have columns where the data in the body will be a single character. The heading is 10 or more characters. To conserve space, especially as the sheet can be many pages I want to slope the heading text at 45 degree angle. Steps to Reproduce: 1. type text in cells 2.change cell slope 3. Actual Results: displays incorrectly. Expected Results: should be correctly positioned and not overlap text from different cells Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-GB Module: SpreadsheetDocument [Information guessed from browser] OS: Linux (All) OS is 64bit: yes NOTE: This seems t be a problem that previously existed but has since been corrected. The original spreadsheet was created in around 2014/6, originally in Excel and then opened in Calc. See the extracted Sheet1 from that file. It had originally not had any formatting, just text. However, when I extracted sheet2 from a file created some years later, originally created in Calc, it displays correctly. If I add a new Sheet3, then copy the cells from Sheet1 to Sheet3 as unformatted text and then format them, it displays correctly. So, why raise this as a bug? Mainly to query how a person would resolve a problem like this. I have a long history of working with these kind of tools (from Visicalc in 1983). I was using a file which was already in ODS format and it was through some experimentation that I found that this might have been a bug in a former version. How does another user of Calc figure this out? My original file has 36 sheets in if many were still raw and I would have a lot of work to fix this. But maybe there are few who would experience this.
Created attachment 179114 [details] sheet1 displays incorrectly It would be nice if there were some kind of tool that could "audit" a sheet and identify cases where the sheet metadata does not conform to the standard so that this could be corrected
Some other format in the cells. Doing a [Ctrl+M] and then format to 45ΒΊ, seems to work fine.
That example sheet has cell format 'Reference Edge' set to 3rd choice. I loaded the sheet1 attachment file (MacOS and Windows) and notice the appearance can easily be corrected by doing one of: 1) left-aligning those slanted cells. 2) cell format alignment - set Reference Edge to first choice (bottom of cell) Undoing those returns those cells to the undesireable look. Even if those sample-file cells get copied into a new file, they look worse alongside default created slanted cells. This may not be a bug, just an unfortunate default setting used in older files(?). In a new file (MacOS and Windows) I make new slanted cells but they don't look bad until I set Reference Edge to the last/3rd choice (square shape). I updated hardware and version info above to include my results. Changing importance normal to minor, because workaround exists. I'm thinking this is not an actual bug, so keyword=needsDevAdvice
I can confirm that it is not a bug. When I copied the contents to a new / clean workbook the problem went away. It must have been as a consequence of a problem in an old alpha version (the original wb was created >5y ago).