Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||default border weight|
|Component:||formatting||Assignee:||AOO issues mailing list <issues>|
|Status:||REOPENED ---||QA Contact:|
|Priority:||P3||CC:||elish, issues, knmc, mseidel, peter, petko, prokras|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||4.1.9|
|Issue Depends on:||18027|
Description lvehko 2010-02-19 22:35:31 UTC
Unable to change default border weight in spreadsheet template
Comment 1 Edwin Sharp 2013-08-16 08:42:52 UTC
Format - Styles and Formatting - Cell Styles - Default - right click - Modify... - Borders
Comment 2 prokras 2014-03-04 19:23:51 UTC
(In reply to Edwin Sharp from comment #1) > Format - Styles and Formatting - Cell Styles - Default - right click - > Modify... - Borders Actually, this does not solve the problem. I don't want to draw borders over the entire sheet. I want to use the border toolbar buttons to apply a border with a weight of 0.50pt instead of the default 0.05pt. Failing that, can we just make 0.50pt the default universally? There is no reason for the default to be 0.05pt.
Comment 3 Edwin Sharp 2014-03-05 07:11:28 UTC
(In reply to prokras from comment #2) > Actually, this does not solve the problem. I don't want to draw borders > over the entire sheet. Create a new style and apply it selectively. > I want to use the border toolbar buttons to apply a > border with a weight of 0.50pt instead of the default 0.05pt. Failing that, > can we just make 0.50pt the default universally? There is no reason for the > default to be 0.05pt. Record a macro with desired border weight and assign it a toolbar button.
Comment 4 Peter Lairo 2021-04-10 22:19:54 UTC
I don't understand why this issue was closed. It seems to be "AN_OOO_ISSUE". Could you please reopen this issue? We really need a way to change the default border color and width when we create a border.
Comment 5 Peter Lairo 2021-04-10 22:22:00 UTC
Is the Issue Type really a "Defect" or rather an "Enhancement Request"?
Comment 6 Peter 2021-04-11 07:38:32 UTC
Created attachment 87017 [details] Format_Cells_screenshot I do not understand the Issue, sorry. We talk about the Format Cell Dialogue and you want that the default is configurable? I uploaded a Screenshot with the default selection, and markt a sample custom selection as a highlight. Is that what this is about?
Comment 7 Keith N. McKenna 2021-04-11 22:13:48 UTC
It was closed as it is not an issue because it can be done and Edwin gave you the way to do that.
Comment 8 Peter Lairo 2021-04-12 14:07:08 UTC
(In reply to Keith N. McKenna from comment #7) > It was closed as it is not an issue because it can be done and Edwin gave > you the way to do that. Edwin suggested creating a macro and adding it as a toolbar button. That is, at best, a workaround. I don't think many users will want to, or know how to, do that, including me (a savvy computer tinkerer). LO needs a better solution. lvehko (the creator of this issue) was unclear what he wanted. Let me try to be more precise with what I think he meant (and what I mean): When we create a new or open an existing LO Document (Calc, and, ideally, Writer, Draw, etc.), select cells, and want to create a border (CTRL+1, Tab: Borders), we would like the INITIALLY PRESENTED Border Width (and ideally, all other Border settings too) to be something we have PREVIOUSLY defined as a DEFAULT. Reason: The current default setting (black, thin line) does not satisfy the more aesthetically oriented users among us. We are forced to adjust these settings EVERY time. I, for example, would like to have color "Blue" and width "2 pt" as the default for all my future documents (and, FWIW, "Synchronize" to be "OFF"). What we do NOT need (at all) is the current ability to edit the default template and to set the Background, Border Line Style, and Border Color of a SELECTED SET of cells for ALL future new documents. That's just silly.
Comment 9 Peter Lairo 2021-04-12 14:08:15 UTC
Created attachment 87018 [details] Screenshot of What we want Here is a screenshot of what we want.
Comment 10 Peter Lairo 2021-04-12 14:09:45 UTC
Created attachment 87019 [details] Screenshot of what nobody needs Here is a screenshot of what nobody needs (the current "ability" to set a default).
Comment 11 Matthias Seidel 2021-04-12 14:26:20 UTC
(In reply to Peter Lairo from comment #8) > Edwin suggested creating a macro and adding it as a toolbar button. That is, > at best, a workaround. I don't think many users will want to, or know how > to, do that, including me (a savvy computer tinkerer). LO needs a better > solution. If you want that for LibreOffice you should head over to their Bugzilla. Just saying... ;-)
Comment 12 Peter Lairo 2021-04-12 15:25:34 UTC
(In reply to Matthias Seidel from comment #11) > If you want that for LibreOffice you should head over to their Bugzilla. > > Just saying... ;-) Oops. my bad. :-\ I'm filing the same request for LibreOffice right now. Here's the LO bug/issue: https://bugs.documentfoundation.org/show_bug.cgi?id=141650 BTW: OpenOffice would benefit from this too... ;-)
Comment 13 prokras 2021-04-13 02:06:49 UTC
Since I'm getting notifications again about this issue, I'll throw in my $.02. Here is my use case for Calc, and why I've wanted this issue resolved for so long. My situation cannot possibly be that unique: So, I work with spreadsheets pretty much all day long. And many of these get sent to clients for their decision-making, their reports, or for their records. Therefore, interoperability with other spreadsheet applications is of critical importance. Of course, with the vast VAST majority of my clients, the spreadsheet application they are using is Excel. The #1 reason I switched from OOo to LO years ago was because it offered better interoperability with Excel at that time. When I prepare a spreadsheet, I want it to be clearly readable, and I expect that what I see on my screen is a reasonable approximation of what another user will see on theirs. When it comes to .05pt borders, it looks nothing alike in Excel vs OOo (or LO, for that matter). When I send clients a spreadsheet full of 0.05pt borders, what they see in Excel are dotted lines that are barely visible against the gray cell boundary lines. The attached screenshot is of Excel 2007, the last verson of Excel I have a license for. It looks even worse in newer versions. Excel's borders default to 0.5pt so when clients send me a spreadsheet, they look just fine. In OOo, IIRC 0.05pt borders look EXACTLY THE SAME as 0.5pt borders. At least at default zoom levels. So unless I actually check every border I draw on the spreadsheet, there's no way to know if that border has a weight of .05pt or .5pt. Then I get clients wondering why the spreadsheet looks funky unless I remember to adjust the borders EVERY. SINGLE. TIME. A while back I had an opportunity to get an Office 365 subscription at no cost to me and I jumped on it. For years, nearly every spreadsheet that I would give to a client was created or edited in Excel and I nearly stopped using Calc altogether, even though I greatly preferred the interface. I no longer have that subscription. I now use Excel 2007 rather than Calc for anything I give to clients. So, perhaps this issue was misclassified as a "defect" when it should be called a feature request or an interoperability issue or something else. In any case, it's a big part of why OOo generally doesn't work for me. Being able to choose my own default border weight, or just making the default .5pt universally, would solve this for me. As I said 7 YEARS ago, there is NO reason why the default border weight should be .05pt in Calc.
Comment 14 prokras 2021-04-13 02:07:40 UTC
Created attachment 87020 [details] Screenshot showing how Excel 2007 displays borders of different weights. How Excel displays different border weights, to contrast with how OOo displays borders of .05pt and .50pt. Highlighting an interoperability issue.
Comment 15 prokras 2021-04-13 02:29:07 UTC
I was mistaken. It's not .50pt it's .75pt that Excel uses as the default, and which I would like all borders to default to.
Comment 16 Peter 2021-04-14 20:31:39 UTC
Thanks so much for the discussion. I think your view point is very clear now. I am your opinion on the case. We need set the border default to a value that is causing less work on daily use if worked with other Office suites. And a default value of 0.75 is fine for me. Also 0.05 is really thin if you want to print the sheet... Please see Issue 18027 for further details. I open this one as a recognition for Prokras and Peter Lairo arguments. But this is not the final state. Issue 18027 goes beyond the real minimum to set a different default. At the same time I do not think that 18027 demands the right thing. If we start to to extend this we should implement a good concept how to handle border styles and maybe cell styles in general and not just close an immediate gap. (which we did not in 18 years :P) With other words: 1) Maybe we can dirty hack this Issue... -> reopen 2) We should come up with a better enhancement then 18027 as a long term solution. -> want a new Issue with proper use case concept.