Apache OpenOffice (AOO) Bugzilla – Issue 10747
Errors in SCALC documentation (cvs from sept. 2002)
Last modified: 2003-05-05 15:56:56 UTC
By translating documentation, I've found some errors. SCALC 1. There are errors in function names. e.g. error value #N/A is very often written as #NV, also in function name NA(). Some Financial functions have old names in documentation (names are changed from 1.0.1 to 643c and some changes are not visible in help files). In example for function DB function name is written as DDB... 2. The angle 1.57 (Pi/2) returns a cosine of 0 radians. -This a little bit wrong. A result of sin, cos functions is unitless, the angle must be given in radians. Look at the rest of angle functions too. 3. Documentation talks about function SCM_ADD - Smallest common multiple :) Here must be LCM_ADD - as Least common multiple 4. MULTINOMIAL(F11:H11) returns 1260, if F11 to H11 contain the values 2, 3 and 4. This corresponds to the formula =(2!+3!+4!)/2!*3!*4!. Here the right formula must be: =(2+3+4)!/2!*3!*4! Also, here is the function name right, but in function list it is 'POLYNOMIAL' 5. The formula: SERIESSUM(x;n;m;coefficients) = coefficients + coefficient2x(n+m) + coefficient3x(n+2m) +...+ coefficientix(n+(i-1)m) is wrong (and fuzzy) Right fomula is, I think: SERIESSUM(x;n;m;coefficients) = coefficient1*x^n + coefficient2*x^(n+m) + coefficient3*x^(n+2m) +...+ coefficienti*x^(n+(i-1)m) In this form, it works, at least :) 6. in the same SERIESSUM, in example is used function FACTORIAL(xxx), that exists not. must be FACT(xxx)
FPE->UFI: Please check.
Frank, you should have re-assigned this task to Uwe then. I do that now.
Thanks, will correct them asap
Re 1.: I cannot find wrong error strings in the current english Help files. The functions DB and DDB both exist and are used correct in the current english Help files. If you have more examples, please state where to find them. Re 2.: This was fixed as to bug #8051#. Re 3.: fixed in file scalc/01/04060106. Re 4.1.: The example for MULTINOMIAL is correct in the current english Help. Re 4.2.: The formula was fixed some time ago. Re 5.: I corrected this. Thank you for your error report, it did help a lot.
Will be checked with master.
verified in SO 6.1 Beta2