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

[bugzilla-daemon]

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

Yousuf Philips (jay)  changed:

   What|Removed |Added

   Keywords|needsUXEval |
 CC|libreoffice-ux-advise@lists |
   |.freedesktop.org|

--- Comment #47 from Yousuf Philips (jay)  ---
So in bug 99027, we've decided to go with 0.50.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

Yousuf Philips (jay)  changed:

   What|Removed |Added

 Status|RESOLVED|NEW
 Resolution|WONTFIX |---

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

Bartosz  changed:

   What|Removed |Added

 Blocks||88175


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=88175
[Bug 88175] [Meta] Tracking bug for limitations of XLSX (OOXML) format
-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

Justin L  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=88
   ||827

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

Yousuf Philips (jay)  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)  ---
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.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #41 from Samuel Mehrbrodt (CIB)  ---
> 1) change the predefined border size from 0.05 to 0.75

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).

* 0.05
* 0.75

I did that and I would very much prefer sticking with the 0.05. The 0.75 line
is much thicker and makes reading the text in the table harder.

I know that you can always change it back, but most users will stick with the
default line thickness.

Also note that the roundtrip LO -> xlsx -> LO works fine. The problem is only
when opening it in Excel.
We definitely need to live with some differences here, since the line styles in
Excel differ quite a lot from the ones in Calc. Attachment 127693 has all the
details.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #40 from Heiko Tietze  ---
(In reply to Kevin Suo from comment #38)
> How can we ping the design-team?

Keyword needsUXEval is set and ux-advice is CC'ed so the design team is aware
of this ticket.

To summarize: aiming for compatibility with MSO the options are
1) change the predefined border size from 0.05 to 0.75
2) map hairlines to something else, I guess that means to save/export 0.05 in a
different style

Solution 1) sounds very simple, and users can change the line width back to
0.05 - ending up in the same trouble but intentionally in this case. Probably I
do not understand 2 but isn't this the best solution?

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #39 from kompilainenn <79045_79...@mail.ru> ---
(In reply to Kevin Suo from comment #38)
> (In reply to Juergen Funk (CIB) from comment #37)
> 
> > I give that to the design-team for decision, and then i hope i get a time 
> > slice for change.
> 
> How can we ping the design-team?

IRC-channel #libreoffice-design on Freenode.net

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #38 from Kevin Suo  ---
(In reply to Juergen Funk (CIB) from comment #37)

> I give that to the design-team for decision, and then i hope i get a time 
> slice for change.

How can we ping the design-team?

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #37 from Juergen Funk (CIB)  ---
(In reply to kompilainenn from comment #36)
> (In reply to Kevin Suo from comment #35)
> I support this view

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.

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

I give that to the design-team for decision, and then i hope i get a time slice
for change.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #36 from kompilainenn <79045_79...@mail.ru> ---
(In reply to Kevin Suo from comment #35)
> (In reply to Juergen Funk (CIB) from comment #34)
> 
> Yes, your patch has brought a lot of improvements to the border behaviour
> between ods and xlsx/xls, and thanks a lot for your hard work.
> 
> But do you think the issue I mentioned in the original bug report is
> resolved? I don't think so. 
> 
> Quote from original bug report:
> > Problem description:
> > When apply borders to cells by clicking the toolbar icon, then save as xlsx 
> > or xls format, when repened with MSO the borders are showing dashed/dotted 
> > rather than normal line borders.
> 
> My concern above is not a new issue.

I support this view

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #35 from Kevin Suo  ---
(In reply to Juergen Funk (CIB) from comment #34)

Yes, your patch has brought a lot of improvements to the border behaviour
between ods and xlsx/xls, and thanks a lot for your hard work.

But do you think the issue I mentioned in the original bug report is resolved?
I don't think so. 

Quote from original bug report:
> Problem description:
> When apply borders to cells by clicking the toolbar icon, then save as xlsx 
> or xls format, when repened with MSO the borders are showing dashed/dotted 
> rather than normal line borders.

My concern above is not a new issue.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #34 from Juergen Funk (CIB)  ---
(In reply to Kevin Suo from comment #33)

> 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.

BUT this mapping i have not changed

> 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. 
> 2. Mapp 0.05 to one of the solid line type.

The best solution is 1, when change the mapping in this case the roundtrip is
break, that was my main point, not change always the borders between LO and MS.

I think, this bug is solved, but yours is a new bug/feature, and i can not
decide what for solution is the right, but i think the best and easiers is 1

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #33 from Kevin Suo  ---
(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.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #32 from Juergen Funk (CIB)  ---
Hi Kevin Suo, or kompilainenn 

can you set the Status back to RESOLVED fixed. 
For me it is works

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #31 from Juergen Funk (CIB)  ---
Created attachment 127693
  --> https://bugs.documentfoundation.org/attachment.cgi?id=127693=edit
New Mapping LO-Excel-Lines 1.2.ods

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

Juergen Funk (CIB)  changed:

   What|Removed |Added

 Attachment #122897|0   |1
is obsolete||

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #30 from Juergen Funk (CIB)  ---
Hi Kevin Suo,

that was my first idea, you not have the right version, and of the other hand,
not all mapping between LO and MS are possible, in this case you can look to
the attachment "New_Mapping_LO-Excel-Lines_1.2"

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

kompilainenn <79045_79...@mail.ru> changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|FIXED   |---

--- Comment #29 from kompilainenn <79045_79...@mail.ru> ---
bug repro in 

Version: 5.3.0.0.alpha0+
Build ID: 70c7e82003a539ed7f7ccbe596bde5ac9031d15c
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2016-09-23_06:53:48
Locale: ru-RU (ru_RU); Calc: group

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #28 from Kevin Suo  ---
(In reply to Juergen Funk (CIB) from comment #27)
Bug still exists under linux.

Steps:
1. New Calc;
2. Apply border using the toolbar icon; (the border is solid)
3. Save as xlsx/xls and reopen with MSO. (the border is dashed)

Version: 5.2.2.2
Build ID: 8f96e87c890bf8fa77463cd4b640a2312823f3ad
CPU Threads: 4; OS Version: Linux 4.4; UI Render: default; 
Locale: zh-CN (zh_CN.UTF-8); Calc: group
Ubuntu 16.04 LTS x64.

Am I missing something?

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

Juergen Funk (CIB)  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

--- Comment #27 from Juergen Funk (CIB)  ---
Fixed and tested

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 CC||xiscofa...@libreoffice.org

--- Comment #26 from Xisco Faulí  ---
Hello Juergen,
Is this bug fixed?
If so, could you please close it as RESOLVED FIXED?

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

Roeland  changed:

   What|Removed |Added

 CC||79045_79...@mail.ru

--- Comment #24 from Roeland  ---
*** Bug 88743 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

Roeland  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=88
   ||743

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

raal  changed:

   What|Removed |Added

 CC||roelandb...@hotmail.com

--- Comment #23 from raal  ---
*** Bug 99190 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

Cor Nouws  changed:

   What|Removed |Added

 CC||c...@nouenoff.nl

--- Comment #22 from Cor Nouws  ---
ah wow :)

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

Commit Notification  changed:

   What|Removed |Added

 Whiteboard||target:5.2.0

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #20 from Yousuf (Jay) Philips  ---
(In reply to Pedro from comment #19)
> Maybe this older bug report is also related
> 
> https://bugs.documentfoundation.org/show_bug.cgi?id=77369

Nope not related as this is about compatibility and that is about
functionality.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #18 from Juergen Funk (CIB)  ---
I have push to gerrit here: https://gerrit.libreoffice.org/22665

have tested under windows, linux, the good and bad case.
That is my first unit-test, hope it is okay

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #17 from Juergen Funk (CIB)  ---
Hi  Yousuf (Jay) Philips,

i think it is a good idea, but has nothing to do with this bug. 
I mean a new Line-Styles are a new feature, we have 17 different
BorderLineStyles
look here:
http://api.libreoffice.org/docs/idl/ref/namespacecom_1_1sun_1_1star_1_1table_1_1BorderLineStyle.html
but for example the MS-Line Slant-DashDot is missing, and the other LineStyles
not all equal to the MS-Lines, then we need new BorderLines. 

I'm testing now the Unit-test and want commit, it is okay for you (we need this
patch as soon as possible).

When we improve the BorderLineStyle then we should improve this mapping and the
Unit-Test

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #15 from Juergen Funk (CIB)  ---
Hi Yousuf (Jay) Philips,
i do not change the available Line-Styles, at the moment we have and after my
patch are always 7. I only change the mapping Line-Style to MS-Lines, and this
mapping i descript in "New Mapping LO-Excel-Lines 1.1"
At the moment i work on the Unit-Test for the mapping (the mapping is
complete), now. It is arranged with the design-committee.

Hope it is okay, for you

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

Juergen Funk (CIB)  changed:

   What|Removed |Added

 Attachment #121956|0   |1
is obsolete||
 Attachment #122494|0   |1
is obsolete||

--- Comment #14 from Juergen Funk (CIB)  ---
Created attachment 122897
  --> https://bugs.documentfoundation.org/attachment.cgi?id=122897=edit
New Mapping LO-Excel-Lines 1.1

A new description of the mapping

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

Yousuf (Jay) Philips  changed:

   What|Removed |Added

 CC||philip...@hotmail.com

--- Comment #13 from Yousuf (Jay) Philips  ---
@Juergen: Is it not possible to extend LO's available list of line styles, so
we could have a 1:1 relationship with MSO? If not, having interoperability work
correctly is a good option, but what happens when an unknowing user selects one
of the styles which is mapped to a different looking style and then export it
to xlsx?

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise