[Libreoffice-bugs] [Bug 141650] Need ability to define a default border

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=141650

prokras at hotmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |prokras at hotmail.com

--- Comment #4 from prokras at hotmail.com ---
Peter was gracious enough to link to this submission while posting about the
same issue in OpenOffice.  So I'll add my $.02 here as well.  Here is my use
case for Calc, and why I've wanted this issue addressed 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 Calc.

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 version of Excel I
have a license for.  It looks even worse in newer versions.

Excel's borders default to 0.75pt so when clients send me a spreadsheet, they
look just fine.  In Calc, 0.05pt borders used to look exactly the same as
0.75pt borders (I believe as of version 7.0.x this is no longer the case).  I
had to check every border I draw on the spreadsheet, or there would be no way
to know if that border had a weight of .05pt or .75pt. Then I would get clients
wondering why the spreadsheet looks funky unless I remember to adjust all the
borders.

Fortunately, LO has OOo beat here as well.  If I go into the Format Cells
dialog, it does indeed default to 0.75pt.  Kudos!  However, if I use the
toolbar button to apply a border, it still defaults to 0.05pt.  And as far as I
know, there's no way to change the weight of the border that the toolbar button
applies.  So I still need to remember every time I want to draw a border to NOT
use the toolbar button and to always use the dialog instead.

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 for professional work, even though I greatly prefer the LO
interface.

I no longer have that subscription.  I now use Excel 2007 rather than Calc for
most things I give to clients, other than quick edits.

So, yes, there are certainly use cases for wanting to be able to set one's own
default border, besides one's own aesthetic tastes.  There could be
organizational branding at state, for example.  In short, I agree that this
would be a really useful feature for some people.

Also, there is absolutely zero reason why the toolbar button should default to
applying a border with a weight of 0.05pt.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210413/a098cea2/attachment.htm>