Is there a pencil tool to draw borders in calc, like in Excel?

Hello there,

I’ve tried to find a way to draw borders easily in Calc, to no avail.
So far I’ve found 2 ways, both are pretty cumbersome:
1/ Select the cells you want to put a specific type of border (for instance bottom of the cell), then go click the ‘Specify the selected cells borders’ to open the menu, then select the border bottom icon.
Then select the other cells you want to draw borders on, and repeat the process by clicking on each different type of border.
Although this is the same default way of adding borders to cells as in Excel, this is painful and time consuming.

2/ Select the cells you want to edit the same way, then go to cells properties > borders, and then from here you can just click on the borders you want selected.
This way is a bit better, since you can have a bit more freedom in setting up the borders (colors, width, and top/bottom/diagonal/etc), but you still are constrained by having to select the cells first, and have the same borders drawn on each of them.

So, in my opinion both methods above, and although by default it’s the same Excel for regular users, are painful to use, and the UX is pretty bad.

Luckily in Excel there is a tool you can activate when you can click a ‘border pencil button’, which activate the ‘Border drawing mode’, then from here you can freely draw any borders you like, very easily.

This border pencil button can be long-clicked to change from drawing borders where your pencil his, to drawing all the border in the rectangle zone you selected.

This is really handy and easy to use.

I’ve search but couldn’t find such a tool in Libreoffice. Did I miss it? If not, where can we create a feature request for this?

Lastly, with that tool come the ‘Border erase tool’ which behave like the tool described above, but to remove borders. Does that exists as well?

Thank you

Since I cannot post more than one image in a message, here is what it looks like when using the second mode of the tool:

No pencil tool, but a third way:
Open Cell Appearance in the Properties section of the Sidebar.

Note that creating a style for cells might be more efficient, see the Styles pane in the sidebar. There is already a Heading style, if that were applied to Headings it is only 1 click, if you then wanted to create a lower border to the headings then adding that to the Heading style would update all your headings without further work. Of course, you can always create your own styles for specific headings or cells

1 Like

In addition to @EarnestAl ,

Cell Styles in Calc

1 Like

While I totally agree that creating styles is the best way to handle most ‘styling’ needs, this is not the solution here, where the idea is to be able to quickly sketch borders and diagonals arbitrarily.

Since LO already allow users to add non-style borders using the border buttons, I’m saying that having a pencil tool to draw those would make that task much more effective.

You need to say it where it can be heard by the right people: Feature requests

Calc is not intended for drawing and painting, is it?

tdf#104129 (“Cell borders freehand drawing tool”) might be a good starting point for your request.

1 Like