Bug 108555 - Add line spacing feature to cell properties
Summary: Add line spacing feature to cell properties
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
: 112497 (view as bug list)
Depends on:
Blocks: Cell-Format-Dialog Cell-Line-Spacing
  Show dependency treegraph
Reported: 2017-06-15 22:59 UTC by Thomas Lendo
Modified: 2018-10-10 12:37 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Thomas Lendo 2017-06-15 22:59:47 UTC
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.
Comment 1 Yousuf Philips (jay) (retired) 2017-06-15 23:54:23 UTC
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.
Comment 2 Heiko Tietze 2017-06-16 07:49:45 UTC
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?
Comment 3 Yousuf Philips (jay) (retired) 2017-06-17 12:58:00 UTC
Eike: Any thoughts on this enhancements?
Comment 4 Eike Rathke 2017-06-19 22:43:18 UTC
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.
Comment 5 Eike Rathke 2017-06-19 22:51:54 UTC
Fwiw, you can also change the row height and under Format Cells Alignment change Vertical to Distributed and activate "Wrap text automatically".
Comment 6 Thomas Lendo 2017-06-19 23:23:11 UTC
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
Comment 7 Timur 2017-06-21 12:00:40 UTC
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.
Comment 8 V Stuart Foote 2017-09-21 13:19:21 UTC
*** Bug 112497 has been marked as a duplicate of this bug. ***