Ask Your Question

how does one select a paragraph in Calc? (not in Writer) [closed]

asked 2014-10-02 19:42:01 +0200 gravatar image

updated 2016-03-04 18:20:06 +0200

Alex Kemp gravatar image

LibreOffice Version running on Ubuntu 14.04, English. I couldn't find any documentation pertaining to what "defines" a paragraph in Calc (not in Writer); whenever I click on the Format menu item, the "Paragraph..." list entry right below "Character..." is never enabled; it's always disabled because I don't know what defines and therefore how to select a paragraph. I am working with cells containing text, such as labels for printing on Avery label sheets, and would like to be able to set the line spacing to something other than the default, and this is accomplished by selecting Paragraph..., correct?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-04 18:20:22.487328


I hope you are not using Calc as a word processing/text writing application.

ROSt52 gravatar imageROSt52 ( 2014-10-03 09:35:25 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2014-10-03 19:56:17 +0200 gravatar image

No, I am not using Calc as a word processing / text writing app; I merely wanted to change the spacing between multiple lines contained within one cell, and thought that the "Paragraph..." option (under the Format menu entry) was the best way to set line spacing. Perhaps there is another, better way of accomplishing this in Calc? Why is the "Paragraph..." option even listed in the menu item list, when in fact it doesn't seem to ever become enabled? No matter what I tried to select, that entry always remained grayed out / disabled. Does it serve any purpose at all? So if "Paragraph..." is not how one should control the line spacing (again, between text lines separated with a hard return contained within one single cell), then what would be the desired approach to accomplishing this?

edit flag offensive delete link more


I don't know for what reason the 'Format' > 'Paragraph' menu item is present at all (but greyed out). Glad you don't try to use Calc as a surrogat for text processing - but defining paragraph properties for cell content would tempt one or another to do so. A few years ago the only way to have a hard line break within a cell was entering it manually. Where are we going? Lets's have the programmers focused on functions, correctness and efficiency when programmiing Calc!

Lupp gravatar imageLupp ( 2014-10-03 22:21:28 +0200 )edit

The option in the menu is available but always disabled cuz LO, like its predecessor , is modular, using same code for every parts of the suite, and Calc doesn't use that feature. They could, sure, skip adding that menu entry, but it would be counter-intuitive by making one think it's removed or moved; you always used Calc and then you need to use Writer, but you think the entry ain't there, and possibly won't ever check out. All that could lead into abandoning LO altogether.

rautamiekka gravatar imagerautamiekka ( 2014-10-03 22:24:55 +0200 )edit

cosmic nexus, you shouldn't add an answer to your question when one isn't an answer. This belongs to the OP's comments.

rautamiekka gravatar imagerautamiekka ( 2014-10-03 22:27:46 +0200 )edit

answered 2014-10-02 21:33:59 +0200

Lupp gravatar image

Paragraphs simply don't exist in spreadsheet documents. What comes next to a paragraph is the text contained in a cell.

edit flag offensive delete link more


thank you guys! particularly "rautamiekka" and "Lupp". I love LO and use it nowadays exclusively on all platforms on which I work: Ubuntu Linux, Mac OS X, and once in long while Windows 7 (LOL). LO is a great product; I donated twice to the project, and recommend the suite to everybody and anybody I ever encounter who cares to learn about an Office Suite product. rautamiekka and Lupp, you have answered to the point and succintly, so I thank you. You're awesome! gravatar ( 2014-10-04 23:45:37 +0200 )edit

Question Tools



Asked: 2014-10-02 19:42:01 +0200

Seen: 685 times

Last updated: Oct 03 '14