Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | [From Symphony]User-definded format code is lost with a cell which value is TRUE or FALSE when importing xls file | ||||||||
---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | Yan Ji <yanji.yj> | ||||||
Component: | open-import | Assignee: | AOO issues mailing list <issues> | ||||||
Status: | CLOSED FIXED | QA Contact: | |||||||
Severity: | Normal | ||||||||
Priority: | P3 | CC: | leiw, liushenf, shanzhu33 | ||||||
Version: | 3.4.1 | Keywords: | ms_interoperability | ||||||
Target Milestone: | 4.0.0 | ||||||||
Hardware: | All | ||||||||
OS: | All | ||||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||
Developer Difficulty: | --- | ||||||||
Attachments: |
|
Created attachment 79655 [details]
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.
The patch looks good. Submit it in revision 1390864 Verified on AOO350m1 1391367. Passed. Update Target Milestone to AOO 3.5.0. |
Created attachment 79654 [details] 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]@