https://bz.apache.org/ooo/show_bug.cgi?id=109452
--- Comment #13 from [email protected] --- 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. -- You are receiving this mail because: You are the assignee for the issue. You are on the CC list for the issue.
