Issue 119964

Summary: [From Symphony]Number displays different from MS with the same format code
Product: Calc Reporter: Yan Ji <yanji.yj>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CLOSED FIXED QA Contact:
Severity: Normal    
Priority: P3 CC: binbjguo, jingbaibetsy, leiw, liushenf, zhanglu.aoo
Version: 3.4.0   
Target Milestone: 4.0.0   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 120823    
Attachments:
Description Flags
sample
none
Add patch zhanglu.aoo: review?

Description Yan Ji 2012-06-12 08:55:06 UTC
Created attachment 78260 [details]
sample

MS displays the two Format code with the same result, but AOO doesn't, please see cell A1 and A2

[>0][BLUE]#.0;[<0][RED]#.0;[GREEN]#.000

[<0][RED]#.0;[=0][GREEN]#.000;[BLUE]#.0
Comment 1 Zhang Lu 2012-06-14 05:22:02 UTC
Created attachment 78315 [details]
Add patch

Root Cause:
AOO will ignore the <0 condition if appear in first scetion
Resolution:
To check the condition of first section, if meet condition, remove the minus sign
Comment 2 Wang Lei 2012-06-21 02:43:36 UTC
I will review it
Comment 3 Wang Lei 2012-06-21 07:27:56 UTC
Reviewed.  Patch looks good.
Thanks for the good work.
Applied on SVN revision 1352432
Comment 4 binguo 2012-08-20 09:43:43 UTC
Verified on latest AOO Trunk 0817 build on Window OS/Linux OS/Linux 64bit OS, this bug is fixed. Format code in cells A1 and A2 are correct.
Comment 5 Shenfeng Liu 2012-11-07 08:46:18 UTC
set Target Milestone to AOO 3.5.0 for PM purpose.