Apache OpenOffice (AOO) Bugzilla – Issue 86135
In a chart Equation and R², decimal places are default 0, this is too low
Last modified: 2013-02-24 21:20:05 UTC
When having a graph, a trendline and the equation and R². OOo sets automatically the number of decimals for R² to 0, this is too low for R². Please raise it to 4 or 5.
Created attachment 51535 [details] Just an ods file with a chart in it for testing this.
Hi Bjoern, one for you.
That's not entirely true. The default format for R² is "Standard", which is the default also for all cells in a spreadsheet. This number format uses two optional decimal places, i.e. "0,99" stays "0,99". "1,01" also stays "1,01". However, e.g. "0,999" becomes "1" and also "1,001" becomes "1". So, you have 2 decimal places. If this is too low, you have to increase it. I am not sure about the default. Do you also want more digits in the Standard number format of Calc, or why is it no problem there?
You're right but even two numbers are too little for me.
In a scientific or engineering context the number can never be 1, thats why I'm complaining. (Mayby make it adjust the numbers until it is no longer 1) (Anyway, this won't be such a big problem when there are chart templates that can be used quick and easy. So I only have to make one chart template with more than two decimal places in it. This is part of another issue.)
changed target to 3.x
change owner
I think this is a duplicate to issue 85005. *** This issue has been marked as a duplicate of 85005 ***
closed as duplicate