In Writer you can adjust the line spacing of text with context menu > Paragraph (or a paragraph style) > Indents & Spacing > Line Spacing. In Calc there is no such a feature. But Calc also will be used for much text or other content in cells which would profit from a line spacing feature with regards to better readability and clarity. Line spacing can be part of the cell style dialog as well as of the "Format Cells" dialog for direct formatting.
Didnt see the option in Excel and the functions in Format > Spacing also dont work and dont know enough to judge what would be useful for a spreadsheet, so i'll leave it to the experts. Regina, Cor, Stuart, Heiko: Ball in your corner.
Never thought Calc as a text processor where line spacing is a relevant option. If Thomas is right and users enter a lot of text the paragraph style properties are relevant, if not it's another overkill complicating the UI. Timur, what's your opinion?
Eike: Any thoughts on this enhancements?
Yes. I see an interoperability nightmare. If you really have that much text in a spreadsheet cell that you need individual line spacing then better use a text box ie. rectangle shape, which does support line spacing.
Fwiw, you can also change the row height and under Format Cells Alignment change Vertical to Distributed and activate "Wrap text automatically".
Eike, thanks for your thoughts. Spreadsheets will not only used for formula. Sense and nonsense of the use of spreadsheets for text content is an academic discussion that doesn't help real world use cases. The idea behind this bug report is readability and to have good-looking spreadsheets. Now with many fonts, wrapped content (not only text) looks densed and bad readable. Saved as non-odf it's right that this option will be lost. Is there no other LibO setting that is causing a similar problem
Currently we can: 1 change cell styles 2 set horizontal alignment and add left indent 3 set fixed row height for selected rows (not adaptable) 4 set optimal row height for selected rows and add spacing cell(upper border)-text 5 set vertical alignment including justified or similar distributed Looks like there are different formatting options although not all is automated if we want both spacing cell-text and text-text. What's not really available is what's requested here: add text line spacing. Such look now can be achieved only manually, using steps 3-5, but only row by row, not as a general solution using styles or single command. So, this would come in handy, albeit for a few users. I'd keep this one as New, with lowest priority enhancement.
*** Bug 112497 has been marked as a duplicate of this bug. ***
Hello! I am new here. But i have been planning to contribute to LibeOffice for a long time and this issue is really something that bothers me. Today i stumbled upon this problem again. I'd say that there is a real user-need for this.I personally know 3 other people (+ myself) who frequently use LibreCalc for writing invoices and are puzzled by not being able to have an efficient way for setting the line-spacing in a multi-line cell. Also, if you start searching for this problem this is for example what the web offers you - https://ask.libreoffice.org/t/how-can-i-adjust-line-spacing-for-cells-with-word-wrap-in-calc/7634/4 - (in german) https://ask.libreoffice.org/t/calc-zeilenabstand-im-tabellenfeld-anderbar/73580 In both discussion the solution proposed is to create a text-area in the multi-line cell and then write the text inside it, where all the features of paragraph formatting are available. I think this is a way to hacky solution for having control over line-spacing in cells. Also this is really bad UX. Ignoring this user-need or saying: "This is LibreOffice Calc and not LibreOffice Writer" would also be problematic as this would be ignoring how users think. I would argue that users can expect the text formatting in a cell to behave like the text formatting they know from Writer. This means, setting the line-spacing should work the same way like in Writer. As i have already told i am new here, so i do not really know how things are usually done, but i would like to suggest to things 1) Revive the discussion about this bug / feature request 2) raise the priority for this at least a little bit