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

[bugzilla-daemon at bugs.documentfoundation.org]

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

Yousuf Philips (jay) <philipz85 at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           See Also|                            |https://bugs.documentfounda
                   |                            |tion.org/show_bug.cgi?id=99
                   |                            |027
         Whiteboard|target:5.2.0                |target:5.2.0 interopability

--- Comment #44 from Yousuf Philips (jay) <philipz85 at hotmail.com> ---
We had similar discussions of what should be the default border line width for
tables in bug 99027.

So if we check out the competition, all of them (Excel, WPS/Kingsoft, Google
Sheets, Gnumeric, Calligra Sheets, Quattro Pro) provide style presets that
combine both the border line style and width. Calligra Sheets is the only one
that allows a user to create a custom style and width, but limits the width to
being only whole numbers.

(In reply to Juergen Funk (CIB) from comment #37)
> The problem is when we change the mapping from LO-Line-1 0,05 to
> Excel-Line-6 we lost this witdh information (0,05-0,50), and this mapping
> was before my change.

That is only natural because of format differences. When excel exports its
default border to ods, Calc opens it up at 0.05 and Calligra opens it at 1.

> Then i prefer we change the default to 0,75.

I would agree with this to provide maximum compatibility.

(In reply to Samuel Mehrbrodt (CIB) from comment #41)
> Please, before we discuss changing the default line thickness to something
> else, try *printing* a table with some text in it with the two different
> line thicknesses (Please do print, as you won't see much difference on the
> screen).

Yes someone with a printer should print out a sheet with various border widths
and give a recommendation of what they think should be default. I'd recommend
testing in 0.25 increments.

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