To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115198 Issue #|115198 Summary|Confused borders of adjoining merged cells when save a |s xls(Microsoft Excel 97/2000/XP) Component|Spreadsheet Version|OOO320m18 Platform|Unknown URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|liyd
------- Additional comments from [email protected] Fri Oct 22 11:42:26 +0000 2010 ------- 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
