Ask Your Question
0

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

asked 2014-10-02 19:42:01 +0100

cosmic.nexus gravatar image

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

Alex Kemp gravatar image

LibreOffice Version 4.3.2.2 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

Comments

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

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

2 Answers

Sort by » oldest newest most voted
0

answered 2014-10-03 19:56:17 +0100

cosmic.nexus 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

Comments

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 +0100 )edit

The option in the menu is available but always disabled cuz LO, like its predecessor OpenOffice.org , 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 +0100 )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 +0100 )edit
1

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

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

Comments

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!

cosmic.nexus gravatar imagecosmic.nexus ( 2014-10-04 23:45:37 +0100 )edit

Question Tools

2 followers

Stats

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

Seen: 445 times

Last updated: Oct 03 '14