Issue 115198

Summary: Confused borders of adjoining merged cells when save as xls(Microsoft Excel 97/2000/XP)
Product: Calc Reporter: liyd <liyd>
Component: save-exportAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues
Version: 4.1.0-dev   
Target Milestone: ---   
Hardware: PC   
OS: Windows, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
sample of described borders none

Description liyd 2010-10-22 12:42:26 UTC 
Actions:
1.open cals, create a empty file, merge B4:B9,  merge C4:C9, merge E4:E9, merge
F4:F9, now there're 4 merged cells: B4,C4,E4,F4.
2.set borders(left ,right, top, bottom) of C4 to 1.00pt weight, set borders(left
,right, top, bottom) of E4 to 1.00pt weight.
3.save it as "mergedBorders.xls" in type "Microsoft Excel 97/2000/XP(.xls)", and
close file.
4.re-open "mergedBorders.xls", and the borders are confused: 
    for C4: only the top 1/6 borders are left, and others missing.
    for F4: 5/6 from the bottom, which are not supposed to have borders , are of
solid line border.

If save file as "Microsoft Excel 2003 XML(.xml)", and open it by APIs, and do query:
------
XPropertySet cellPropSet = (XPropertySet) UnoRuntime.queryInterface(
XPropertySet.class, XCell);
BorderLine left = (BorderLine) UnoRuntime.queryInterface(BorderLine.class,
cellPropSet.getPropertyValue("LeftBorder"));
BorderLine right = (BorderLine) UnoRuntime.queryInterface(BorderLine.class,
cellPropSet.getPropertyValue("RightBorder"));
....
------
And the border lines have no problem, but after saved using
XStorable#storeAsURL() with option "FilterName"="MS Excel 97", the same confused
borders appear just as described in front.
Comment 1 liyd 2010-10-22 12:51:38 UTC 
Created attachment 72147 [details]
sample of described borders
Comment 2 Edwin Sharp 2013-11-21 19:32:43 UTC 
Bottom border of C4 missing.
F4 has bottom border for no reason.

AOO410m1(Build:9750)  -  Rev. 1543812
Rev.1543812
Win 7