[Libreoffice-bugs] [Bug 91007] FILEOPEN: XLS - Cell borders not present

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #9 from himajin100000 at gmail.com ---
Just a guess.

A-1. Suppose we have A1:B1 merged. the merged area has a unique border style
for a specific direction. If the border under A1 is with solid style, the
border under B1 would be solid style. This applies to both Excel and Calc.
-----
A-2. Lets think about another case.

At least in Calc, When all the following three conditions are met,

a-1. there is a unmerged area A1:B1
a-2. A1 has solid bottom border 
a-3. B1 has no bottom border

if we merge A1:B1, the area will have a unique solid bottom border as described
in A-1
-----
A-3. Lets think about one more case.

At least in Calc, When all the following three conditions are met,

b-1. there is a unmerged area A1:B1
b-2. A1 has no bottom border 
b-3. B1 has solid bottom border

if we merge A1:B1, the area will have no bottom border.
-----
A-4.
If all the following five conditions are met in Excel

c-1. there is a unmerged area A1:B1
c-2. A1 has no bottom border 
c-3. B1 has solid bottom border
c-4. A1 has its content "AAA"
c-5. After we select A1:B1, open [Format Cells] Dialog, and choose "Center
across Selection" for [Horizontal] combobox under [Alignment] Tab

A1 will have no bottom border, B1 will have a solid bottom border. the content
"AAA" will be poisitioned horizontally center in A1:B1

now we save this file in xlsx format. the data "centerContinuous" and its
target area A1:B1 will be saved to the file.
-----
A-5.
Open this xlsx file in Calc.
On loading the file, Calc MERGES the area A1:B1. We can see no bottom border,
as A1 had no bottom border.

https://opengrok.libreoffice.org/xref/core/sc/source/filter/oox/sheetdatabuffer.cxx?r=358bdc5e#716
https://opengrok.libreoffice.org/xref/core/sc/source/filter/oox/sheetdatabuffer.cxx?r=358bdc5e#500

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210316/88ec05a7/attachment.htm>