Issue 115198 - Confused borders of adjoining merged cells when save as xls(Microsoft Excel 97/2000/XP)
Summary: Confused borders of adjoining merged cells when save as xls(Microsoft Excel 9...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: 4.1.0-dev
Hardware: PC Windows, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-10-22 12:42 UTC by liyd
Modified: 2013-11-21 19:32 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
sample of described borders (15.52 KB, image/png)
2010-10-22 12:51 UTC, liyd
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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