Issue 121126 - [From Symphony]User-definded format code is lost with a cell which value is TRUE or FALSE when importing xls file
Summary: [From Symphony]User-definded format code is lost with a cell which value is T...
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: 4.0.0
Assignee: AOO issues mailing list
QA Contact:
Keywords: ms_interoperability
Depends on:
Reported: 2012-09-27 06:04 UTC by Yan Ji
Modified: 2012-10-18 06:07 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

sample (25.00 KB, application/
2012-09-27 06:04 UTC, Yan Ji
no flags Details
Add patch (3.10 KB, patch)
2012-09-27 06:13 UTC, Zhang Lu
zhanglu.aoo: review?
Details | Diff

Note You need to log in before you can comment on or make changes to this issue.
Description Yan Ji 2012-09-27 06:04:56 UTC
Created attachment 79654 [details]

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]@
Comment 1 Zhang Lu 2012-09-27 06:13:29 UTC
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.

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.
Comment 2 Wang Lei 2012-09-27 06:58:54 UTC
The patch looks good. Submit it in revision 1390864
Comment 3 Shan Zhu 2012-10-08 09:19:46 UTC
Verified on AOO350m1 1391367. Passed.
Comment 4 Shenfeng Liu 2012-10-18 06:07:50 UTC
Update Target Milestone to AOO 3.5.0.