You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/05/30 07:55:46 UTC
[Bug 119557] New: [From Symphony] Column header can not be displayed
correclty in AOO3.4 after open the xls file.
https://issues.apache.org/ooo/show_bug.cgi?id=119557
Priority: P3
Bug ID: 119557
Assignee: ooo-issues@incubator.apache.org
Summary: [From Symphony] Column header can not be displayed
correclty in AOO3.4 after open the xls file.
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: binbjguo@gmail.com
Hardware: PC
Status: UNCONFIRMED
Version: OOo 3.4 Beta
Component: ui
Product: spreadsheet
Created attachment 77771
--> https://issues.apache.org/ooo/attachment.cgi?id=77771&action=edit
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
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119557] [From Symphony] Column header can not be displayed
correclty in AOO3.4 after open the xls file.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119557
--- Comment #3 from Jianyuan Li <li...@gmail.com> ---
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.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119557] [From Symphony] Column header can not be displayed
correclty in AOO3.4 after open the xls file.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119557
Jianyuan Li <li...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #78291| |review?
Flags| |
--- Comment #5 from Jianyuan Li <li...@gmail.com> ---
Created attachment 78291
--> https://issues.apache.org/ooo/attachment.cgi?id=78291&action=edit
Patch for this bug
The patch just contains two lines modification
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119557] [From Symphony] Column header can not be displayed
correclty in AOO3.4 after open the xls file.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119557
--- Comment #8 from Jianyuan Li <li...@gmail.com> ---
@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.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119557] [From Symphony] Column header can not be displayed
correclty in AOO3.4 after open the xls file.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119557
Terry Yang <po...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|VERIFIED |CLOSED
--- Comment #13 from Terry Yang <po...@hotmail.com> ---
Close this bug
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119557] [From Symphony] Column header can not be displayed
correclty in AOO3.4 after open the xls file.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119557
--- Comment #6 from Jianyuan Li <li...@gmail.com> ---
Created attachment 78292
--> https://issues.apache.org/ooo/attachment.cgi?id=78292&action=edit
UT sample files for this bug
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119557] [From Symphony] Column header can not be displayed
correclty in AOO3.4 after open the xls file.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119557
Andre <af...@a-w-f.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #78291|review? |review+
Flags| |
--- Comment #10 from Andre <af...@a-w-f.de> ---
Comment on attachment 78291
--> https://issues.apache.org/ooo/attachment.cgi?id=78291
Patch for this bug
Reviewed, tested, checked in.
SVN revision is 1354063.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119557] [From Symphony] Column header can not be displayed
correclty in AOO3.4 after open the xls file.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119557
Andre <af...@a-w-f.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |FIXED
--- Comment #11 from Andre <af...@a-w-f.de> ---
Fixed.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119557] [From Symphony] Column header can not be displayed
correclty in AOO3.4 after open the xls file.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119557
Terry Yang <po...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |polo8495@hotmail.com
--- Comment #9 from Terry Yang <po...@hotmail.com> ---
*** Bug 119486 has been marked as a duplicate of this bug. ***
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119557] [From Symphony] Column header can not be displayed
correclty in AOO3.4 after open the xls file.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119557
--- Comment #4 from Jianyuan Li <li...@gmail.com> ---
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.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119557] [From Symphony] Column header can not be displayed
correclty in AOO3.4 after open the xls file.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119557
Andre <af...@a-w-f.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |af@a-w-f.de
--- Comment #7 from Andre <af...@a-w-f.de> ---
@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.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119557] [From Symphony] Column header can not be displayed
correclty in AOO3.4 after open the xls file.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119557
--- Comment #1 from binguo <bi...@gmail.com> ---
Created attachment 77773
--> https://issues.apache.org/ooo/attachment.cgi?id=77773&action=edit
screenshot
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119557] [From Symphony] Column header can not be displayed
correclty in AOO3.4 after open the xls file.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119557
Jianyuan Li <li...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |lijianyuan1983@gmail.com
--- Comment #2 from Jianyuan Li <li...@gmail.com> ---
I am investigating this issue
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119557] [From Symphony] Column header can not be displayed
correclty in AOO3.4 after open the xls file.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119557
Shenfeng Liu <li...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |liushenf@gmail.com
Target Milestone|--- |AOO 4.0
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119557] [From Symphony] Column header can not be displayed
correclty in AOO3.4 after open the xls file.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119557
Terry Yang <po...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |VERIFIED
--- Comment #12 from Terry Yang <po...@hotmail.com> ---
Verify fixed on revision 1374181.
--
You are receiving this mail because:
You are the assignee for the bug.