Hi everybody,
I'm currently using OWC11 on .NET Framework 2.0 (ASP.NET - VB.NET) in order to create charts. I'm experiencing an issue about rounding a piechart percentage values that I provide to the component.
my problem is:
If I have to represent three integer percentage values that are exacly 1/3 of a pie each one: using OWC11 in my application the result is a three-parts pie with 33% each one while doing the same on Excel the result is 33%, 33% and 34%! The sum of the last operation
is (uncorrectly) 100% (i guess that Excel auto-rounds something somewhere....... ) while in the first case, using OWC11, the sum is 99% (wrong anyway but perfectly consistent with the fact that are integer percentages not decimal!). The question is: does
the OWC11 component allows an auto-rounding excel-styled or do I have to "manage" series before send to the OWC11?
fgentili
0 Points
1 Post
Rounding Error creating a pie chart with OWC11 on ASP.NET / VB.NET
May 13, 2008 01:27 PM|LINK
I'm currently using OWC11 on .NET Framework 2.0 (ASP.NET - VB.NET) in order to create charts. I'm experiencing an issue about rounding a piechart percentage values that I provide to the component.
my problem is:
If I have to represent three integer percentage values that are exacly 1/3 of a pie each one: using OWC11 in my application the result is a three-parts pie with 33% each one while doing the same on Excel the result is 33%, 33% and 34%! The sum of the last operation is (uncorrectly) 100% (i guess that Excel auto-rounds something somewhere....... ) while in the first case, using OWC11, the sum is 99% (wrong anyway but perfectly consistent with the fact that are integer percentages not decimal!). The question is: does the OWC11 component allows an auto-rounding excel-styled or do I have to "manage" series before send to the OWC11?
Thanks in advantage
Fabio Gentili
OWC