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.
Context
- [Libreoffice-ux-advise] [Bug 79787] Normal cell borders are showing dashed/ dotted when export to xlsx/xls and reopen in MSO · bugzilla-daemon
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.