Ask Your Question

Creating BORDERS Problem

asked 2017-09-30 15:11:59 +0200

makey gravatar image

I have just one difficulty with the Borders in that I don't see how to create a bold line box type of border to go around around a section of items in a Spreadsheet.

I'm OK with the thin lines for individual cells, but the surrounding box always appears as the same thin lines. Also, I can't get the Double Underlines for a row of cells.

Can someone please tell me what to do?

Thanks in advance for any replies.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-09-30 18:48:22 +0200

Jim K gravatar image

In the following image from a Calc spreadsheet, the "abcd" cells each have thin inner borders, and the four cells are surrounded by a thicker border. Also, the "efg" cells have double underlining. The image was taken by using "Zoom In" from the lower right corner of the Calc window.

spreadsheet example

To set this up, select the "abcd" cells and go to Format -> Cells -> Borders tab. First, under Presets, click "Set outer border and All Inner Lines." This should create the thin line.

Now, click "Set Outer Border Without Changing Inner Lines." Then increase the width to 2.50 pt for example. Press OK.

borders dialog

For the double underlines, I simply went to Format -> Text -> Underline: Double. It shows up when Calc is zoomed in, as explained above.

edit flag offensive delete link more

answered 2017-09-30 18:12:15 +0200

Grantler gravatar image

updated 2017-09-30 18:14:39 +0200

Operating system? LibreOffice version?

Have a look to:

Double underlining: Export sheet as PDF format and enlarge view in PDF reader (Adobe; Foxit; Evince...) to 1600 or 2400 % - the double underlining is shown. It's kind of graphics and rendering... If your printout shows only one thick line so try a width of 2 pt or more. This also maybe a problem of rendering and output resolution... presumably no bug.


edit flag offensive delete link more
Login/Signup to Answer

Question Tools


Asked: 2017-09-30 15:11:59 +0200

Seen: 1,620 times

Last updated: Sep 30 '17