Apache OpenOffice (AOO) Bugzilla – Issue 119557
[From Symphony] Column header can not be displayed correclty in AOO3.4 after open the xls file.
Last modified: 2012-12-26 08:45:06 UTC
Created attachment 77771 [details] Sample file Steps: 1.Launch AOO. 2.Open the sample file. 3.Click anywhere using mouse cursor in the sheet, such as A3. 4.Check column header. Defet: Column header can not be displayed correclty. (please refer to the screenshot.) Sample File: Yes Screen Shot: Yes
Created attachment 77773 [details] screenshot
I am investigating this issue
How to reproduce this issue: 1. Launch Excel 2003 and a default work book(window) will be created. 2. Select a cell and click "Windows->Freeze Panes". Then current sheet will be divided into several parts. 3. Click "Window->New Window". A new window will be created. 4. Save it as "Book1.xls". 5. Import "Book1.xls" in AOO. Actual result: Column/Row header can not be displayed correctly.
Root cause: AOO only supports one window and the later created window will be imported. But a redundant "split" window property is imported. There is no "freeze" or "split" window property for the later created window. See "How to reproduce this issue" above. Resolution: Add a condition to ignore the redundant "split" window property when import.
Created attachment 78291 [details] Patch for this bug The patch just contains two lines modification
Created attachment 78292 [details] UT sample files for this bug
@Jianyuan Li: I am not a Calc expert, but Calc supports more than one window per document and more than one view per document. Is that not sufficient to support the "split" property? A new window can be created via the main menu Window->New Window. The view can be split vertically or horizontally by dragging the black bars at the right of the horizontal scroll bar and at the top of the vertical scroll bar, respectively.
@Andre: Yes, Calc supports more than one window per document and more than one view per document. But those windows will be save into an individual document separately. One Calc document will save one window. While for Excel several windows will saved into one document. So when import, only one window(the later created window) is imported due to the feature difference. But there is no "freeze" or "split" window property for the later created window. So here ignore the redundant property. To confirm this, we can also create two windows in Excel and set "Freeze" property in the later created window. Import it in AOO. Still the later created window will be imported and there will be "Freeze" property in the imported window. Any other comments please tell me. Thanks.
*** Issue 119486 has been marked as a duplicate of this issue. ***
Comment on attachment 78291 [details] Patch for this bug Reviewed, tested, checked in. SVN revision is 1354063.
Fixed.
Verify fixed on revision 1374181.
Close this bug