Description: It would be nice if there is a new feature of setting the line width of default border of cells. Some suggests to create a style with the desired line width, however, if there is a feature of setting the default line width in Libreoffice Calc, it would be even more convenient. Steps to Reproduce: 1. Not applicable (suggestion for a new feature) 2. 3. Actual Results: Not applicable (suggestion for a new feature) Expected Results: Not applicable (suggestion for a new feature) Reproducible: Always User Profile Reset: No Additional Info: Not applicable (suggestion for a new feature)
Have you tried to set up it on Default style, and use the file then as default template?
If I use style with border lines with a certain linewidth, whether it is default or not, there are border lines on the cells, which I don’t want. What I want is no border lines by default. Therefore, I don’t want to have the default style with border lines of specific linewidth. When I want to draw border lines, I select the border line icon on the toolbar to draw them. And them, whether or not I use style with specific linewidth, the border lines are drawn with the fixed default line width, 0.05 pt. Therefore, using a style with a specific line width does not result in the same user experience. That is why I would like to suggest a new feature of specifying the default linewidth of border lines. (In reply to m.a.riosv from comment #1) > Have you tried to set up it on Default style, and use the file then as > default template?
[Automated Action] NeedInfo-To-Unconfirmed
Just an update. Recent versions of LibreOffice changed the default line width to 0.75pt instead of using the hairline 0.05pt. However, it's still not possible to set a default width option for borders. For instance, if you want to apply 0.5pt (non-default value) to several ranges, you'll have to do it manually for each range.
There are plenty of ways to configure the cell layout, via direct setting, per cell style, or with templates. I'm not sure what you want to change, the default background grid, the thickness of lines when using the borders toolbar button, the predefined value of borders. What is it exactly?
(In reply to Heiko Tietze from comment #5) > There are plenty of ways to configure the cell layout, via direct setting, > per cell style, or with templates. I'm not sure what you want to change, the > default background grid, the thickness of lines when using the borders > toolbar button, the predefined value of borders. What is it exactly? I am referring to the default line width when setting border lines of cells via the "Borders" toolbar button or via the menu Format>Cells>Borders tab. When changing border lines via the aforementioned methods, a certain default line width such as 0.05 pt (v7.0.6.2) or 0.75 pt (v7.3.6.2) applies. My suggestion is to have a feature that can set the default line width in these methods, so that users do not have to change the line width again when setting border lines via the "Borders" toolbar button or via the menu Format>Cells>Borders tab.
(In reply to snowboard975 from comment #6) > I am referring to the default line width when setting border lines of cells > via the "Borders" toolbar button or via the menu Format>Cells>Borders tab. Which means we have to add an option for this simple interaction. Have you considered to use cell styles for your workflow?
I considered using cell styles and making it default to a template and using the template as suggested in Comment #1 and answered in Comment #2. However, then all the cell borders are drawn with the cell borderline width of the style, which does not result in the same user experience as using the Borders toolbar or Cell Borders menu. With the toolbar or the menu, only selected cell border linewidths can be defined, which is different from defining all cell borders. That is the reason why I suggest this feature. (In reply to Heiko Tietze from comment #8) > (In reply to snowboard975 from comment #6) > > I am referring to the default line width when setting border lines of cells > > via the "Borders" toolbar button or via the menu Format>Cells>Borders tab. > > Which means we have to add an option for this simple interaction. Have you > considered to use cell styles for your workflow?
I also feel this pain, so I would like to suggest a course of action. First of all, IMO the default width (0.75 pt) is too thick. So every border is initially formatted with 0.75pt and then I have to reapply the borders so that they have 0.5pt width (which I think is the ideal width). My feeling is that my experience is not very good with formatting borders with the current UI, since I always have to apply the borders and then change the line width. Using styles is not great either, because sometimes I just want to apply a simple border and the toolbar is the quickest way to do that. So what we could do is: 1) Make LO Calc remember the last used line width; this way, if I apply 0.5pt width with the toolbar, then subsequent formatting will consider 0.5pt as well. This way we do not need any new configuration UI to set the default line width. 2) We could consider changing the default width to 0.5pt (but this is a matter of taste).
I have just tested 7.5 and Default style doesn't change line width if the style have not also a border with line.
Comment#11... For me that could be the bug, with it set up a line width for the file would be easy, changing default style. Even more, such issue doesn't let to create a default template with your desire line width.
(In reply to m.a.riosv from comment #11) > I have just tested 7.5 and Default style doesn't change line width... I derive a new cell style from Default, change border width to 0.5pt, color to black, and apply the lines around the shape (make sure you have done this too). Using this CS changes the border line to what I defined - and switching back to Default reverts everything. (In reply to Rafael Lima from comment #10) > 1) Make LO Calc remember the last used line width... I like this proposal.
(In reply to Rafael Lima from comment #10) > 1) Make LO Calc remember the last used line width; this way .. Looks the easiest and less intrusive way to get this done. Nice idea :)
Topic was on the agenda of the design meeting. We pondered over the question whether one setting should rule all controls, for example the cell border in Calc as well the page style, the tables in Writer, or shapes. This was done having in mind the recent change from 0.05pt to 0.75pt. However, the patch itself might not have an impact on all places nor it would be desired in general. So please continue and remember the last used value per control.
Created attachment 185528 [details] Video showing how it works with the patch This proposed patch fixes the issue for the sidebar controls (CellBorderStylePopup and CellLineStylePopup). https://gerrit.libreoffice.org/c/core/+/147467 The last used border width is remembered independently for each Calc instance. See video to see how it works with the patch.
Nice @Rafael.
*** Bug 152800 has been marked as a duplicate of this bug. ***