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/09/27 08:04:56 UTC
[Bug 121126] New: [From Symphony]User-definded format code is lost
with a cell which value is TRUE or FALSE when importing xls file
https://issues.apache.org/ooo/show_bug.cgi?id=121126
Priority: P3
Bug ID: 121126
Keywords: ms_interoperability
Assignee: ooo-issues@incubator.apache.org
Summary: [From Symphony]User-definded format code is lost with
a cell which value is TRUE or FALSE when importing xls
file
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: yanji.yj@gmail.com
Hardware: All
Status: CONFIRMED
Version: AOO 3.4.1
Component: open-import
Product: spreadsheet
Created attachment 79654
--> https://issues.apache.org/ooo/attachment.cgi?id=79654&action=edit
sample
Build: AOO 3.4.1
OS: All
Open attached sample file.
Defect: User-defined format code of A5:B5 is lost. The format code is
[BLUE]#,##0.00;[RED]\(#,##0.00\);[YELLOW]0;[GREEN]@
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121126] [From Symphony]User-definded format code is lost with a
cell which value is TRUE or FALSE when importing xls file
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121126
Zhang Lu <zh...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #79655| |review?
Flags| |
--- Comment #1 from Zhang Lu <zh...@gmail.com> ---
Created attachment 79655
--> https://issues.apache.org/ooo/attachment.cgi?id=79655&action=edit
Add patch
Root Cause:
Original number format code has been replaced by BOOL format code after load
this kind of formula cell if whose type is boolcell.
Resolution:
Keep the original number format code. Get formula type, if meet logical
formula, get result and show TEXT "true" or "false" with original number
format.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121126] [From Symphony]User-definded format code is lost with a
cell which value is TRUE or FALSE when importing xls file
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121126
Shenfeng Liu <li...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|VERIFIED |CLOSED
CC| |liushenf@gmail.com
Target Milestone|--- |AOO 3.5.0
--- Comment #4 from Shenfeng Liu <li...@gmail.com> ---
Update Target Milestone to AOO 3.5.0.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121126] [From Symphony]User-definded format code is lost with a
cell which value is TRUE or FALSE when importing xls file
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121126
Shan Zhu <sh...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |VERIFIED
CC| |shanzhu33@gmail.com
--- Comment #3 from Shan Zhu <sh...@gmail.com> ---
Verified on AOO350m1 1391367. Passed.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121126] [From Symphony]User-definded format code is lost with a
cell which value is TRUE or FALSE when importing xls file
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121126
Wang Lei <le...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CONFIRMED |RESOLVED
CC| |leiw@apache.org
Resolution|--- |FIXED
--- Comment #2 from Wang Lei <le...@apache.org> ---
The patch looks good. Submit it in revision 1390864
--
You are receiving this mail because:
You are the assignee for the bug.