Issue 119964 - [From Symphony]Number displays different from MS with the same format code
Summary: [From Symphony]Number displays different from MS with the same format code
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.0
Hardware: PC All
: P3 Normal (vote)
Target Milestone: 4.0.0
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Blocks: 120823
  Show dependency tree
Reported: 2012-06-12 08:55 UTC by Yan Ji
Modified: 2012-11-07 08:46 UTC (History)
5 users (show)

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

sample (18.50 KB, application/octet-stream)
2012-06-12 08:55 UTC, Yan Ji
no flags Details
Add patch (1.98 KB, patch)
2012-06-14 05:22 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-06-12 08:55:06 UTC
Created attachment 78260 [details]

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


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
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.