Summary.
The problem becomes obvious especially with dashed borders and when they are printed on paper. The thicknesses don't map correctly, patterned borders have wrong intervals etc.
More details on this is in this blog post of mine: http://kohei.us/2014/01/17/the-art-of-drawing-border-lines/
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a96b6f4708d587ddddd93101e51e52dec4e87b7e fdo#73487: Write unit tests for this. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Created attachment 92401 [details] Double line border Please look at a cells with double line border in Excel and in LibreOffice master on the attached screenshot. Line join at corners and line distance are different.
How did you generate Calc's screenshot, at what zoom level?
I changed it so that the aperture of the double lines stays the same at all zoom levels. The line join difference is not something we can fix easily. So, I'd like to leave that as a future TODO.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=15974abe63f0d4fc88099634d5cd2ddb9760ec23 fdo#73487: Center thick border lines around cell grid. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
One last change: align borderline in the middle with respect to the cell grid. This reduces the amount of gap at line joins. I think I'm done here.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=9a19e8d838753128504274e1885eb3ce8ec1dbb8&h=libreoffice-4-2 fdo#73487, fdo#73886: Overhaul cell borders to make them look sane. It will be available in LibreOffice 4.2.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I'll mark it fixed.
Thanks Kohei Yoshida for your wonderful work. However, the Hairline border (0.05pt thick) made with Calc 4.1.0 (to Calc 4.2.0) when opened with 4.2.1 RC1 shows as 0.75 thick, but this is OK and not an issue at all Another thing, in Excel the default border (thin line) translates to a single line border of 0.75 pt thick in Calc 4.2.1. Whereas in Calc the default border is the hairline (0.05pt thick) Can the default in Calc also be made to replicate that of Excel?
(In reply to comment #11) > Another thing, in Excel the default border (thin line) translates to a > single line border of 0.75 pt thick in Calc 4.2.1. Whereas in Calc the > default border is the hairline (0.05pt thick) Can the default in Calc also > be made to replicate that of Excel? Possible. I'll probably come back to this and do some more work if time allows. I'll keep this in the back of my head.
*** Bug 34966 has been marked as a duplicate of this bug. ***
Version set from comment #2. Best regards. JBF