Description: As titled. Specifically, changing the border parameters (e.g. color, width) does not 'save' or persist. https://www.loom.com/share/19f5b7b7f7664d1989e3e2247c9c6057 Steps to Reproduce: 1. File > Templates > Manage Templates 2. Open default template 3. Styles (sidebar) > Default > Modify 4. Borders menu > Line sub-menu: change Color property 5. (opt) press update style Actual Results: Newly added borders are not in the specified color. (Clicking Update Sytle in style sidebar applies the parameter to ALL cells - not correct). Expected Results: When adding new cell borders, they would appear in the updated default color setting for the borders menu. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: yes Version: 7.4.3.2 (x64) / LibreOffice Community Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 CPU threads: 24; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL
Reproducible in stable and unstable builds Version: 7.4.3.2 (x64) / LibreOffice Community Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 5a1f41a0d3aab15c113651f2edc9d4137ae99063 CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
1. You are changing the default Page style, so any change would only be visible on a preview of the whole page. 2. The colour widget changes the colour of the _existing_ borders. If there is no border to change, the colour change won't be saved. No need to use a template to see this: change the border colour of a cell that does not have borders, press OK, reopen the dialog. The colour is back to the default Black. Now add border, then change the border colour: the colour stays. If you modify default Cell Style, add borders to it and change their default colour, the colour persists. This was the same in OOo 3.3. However, it is true that it feels at odds with e.g. Font Effects, in which it's possible to change the default font colour for a style, which will then be used for all new text. And other settings in the Border tab, like Padding. Others are also wondering how to change the default border colour: https://ask.libreoffice.org/t/how-to-change-the-default-border-color-that-is-used-when-adding-new-borders/70006 Similarly, about default border width: https://ask.libreoffice.org/t/calc-way-to-set-default-border-outline-width-thickness/20568 I'm changing this to a request to make border colour / width / style changes persist as a default for a style, even if no border is set. Regina and UX/Design team, what do you think? Am I missing something? Surprised I can't find a duplicate.
The template aspect has been discussed in bug 143249, and to "Remember last used line width (and other settings) for cell borders" in bug 144141. Shall we make this a duplicate?
(In reply to Heiko Tietze from comment #3) > The template aspect has been discussed in bug 143249, and to "Remember last > used line width (and other settings) for cell borders" in bug 144141. Shall > we make this a duplicate? I find it tricky to tease apart. I find the most helpful illustration is: 1. Open Calc 2. Change Default cell style to use: - Font Effect > Font Color > purple - Borders > Line > Color > purple 3. Writer sample text in A1 and A2: see that it is purple, as defined in style 4. Toolbar > Borders > Outer borders: borders are black, not purple. I can see how some people might think "I changed the default colour for font and borders in my style, why does it work for font but not borders?". But an overall solution needs to be found and the discussion is mainly happening in bug 144141, so let's mark as duplicate. *** This bug has been marked as a duplicate of bug 144141 ***