[Libreoffice-ux-advise] [Bug 79787] Normal cell borders are showing dashed/ dotted when export to xlsx/xls and reopen in MSO

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

--- Comment #33 from Kevin Suo <suokunlong@126.com> ---
(In reply to Juergen Funk (CIB) from comment #30)

As already stated in my original bug report, the bug is: 
When you apply borders using the default toolbar icon command, it applied a
border which is solid, but after save as xlsx the border become dashed when
open with MSO.

The default toolbar icon command apply borders with 0.05 pt, and based on your
mapping the line is EXC_LINE_HAIR in MSO. This is the problem.

So, the further solution is:
1. Give the toolbar command a new value (for example, 0.75pt) which can produce
a solid line when open with MSO. Or
2. Mapp 0.05 to one of the solid line type.

For me it really does not matter if I apply border using the cell formatting
dialog with 0.05pt and then the border becomes dashed in MSO. But, it really
matters when I apply border using the toolbar and it shows me a solid border,
but becomes dashed when reopen with MSO. 99% of the time people apply borders
using the toolbar, not using the formatting dialog.

-- 
You are receiving this mail because:
You are on the CC list for the bug.