Issue 10747 - Errors in SCALC documentation (cvs from sept. 2002)
Summary: Errors in SCALC documentation (cvs from sept. 2002)
Status: CLOSED FIXED
Alias: None
Product: documentation
Classification: Unclassified
Component: How To (show other issues)
Version: current
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 1.1 Beta2
Assignee: Uwe Fischer
QA Contact: issues@documentation
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-01-17 22:32 UTC by avagula
Modified: 2003-05-05 15:56 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description avagula 2003-01-17 22:32:23 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)
Comment 1 frank.thomas.peters 2003-03-14 12:57:58 UTC
FPE->UFI: Please check.
Comment 2 michael.bemmer 2003-03-25 07:59:14 UTC
Frank, you should have re-assigned this task to Uwe then. I do that now.
Comment 3 Uwe Fischer 2003-03-25 15:44:22 UTC
Thanks, will correct them asap
Comment 4 Uwe Fischer 2003-03-26 10:17:09 UTC
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.
Comment 5 h.ilter 2003-04-30 15:42:43 UTC
Will be checked with master.
Comment 6 Uwe Fischer 2003-05-05 15:56:56 UTC
verified in SO 6.1 Beta2