Thanks Jean, I'll look this over. Too bad some of these comments just increased my research time...I would hope that a "a serious Calc user" would add facts rather then doubt...but I'll look it over and try my best to address these "issues".
On Sun, 2005-05-22 at 15:22 +1000, Jean Hollis Weber wrote: > I asked Jim Watson, a serious Calc user based in Canberra, if he would > have time to review any of the Calc Guide. He looked at App B, > Description of Functions. Here are his comments. > > Cheers, Jean > > -------- Original Message -------- > Subject: Re: Would you have time to review some/all of the Calc Users Guide? > Date: Sun, 22 May 2005 15:08:07 +1000 > From: Jim Watson <[EMAIL PROTECTED]> > To: Jean Hollis Weber <[EMAIL PROTECTED]> > > On Tue, May 03, 2005 at 06:47:10AM +1000, Jean Hollis Weber wrote: > > > > Any help at all would be gratefully received! Thanks. > > Jean, > > I dont have much time just now due to work commitments, so I think it is > better if i just give you some comments based on a quick reading and > maybe someone can make use of this. I will try and get more time on > this stuff in a few months later.. > > thanks > jim > > This relates to Appendix B calc Guide Description of Functions. > > 1. some limits to number of arguments are described such as SUM() and > SUMSQ() have limit of 30, also COUNt and COUNTA. This seems actually just > the number of input fields in the function wizard, the functions will handle > more arguments. Further the wizard entry fields will accept multiple entries > so the limit can be exceeded which is good. This needs more study but for > for now there should be a warning in the notes, the limit to number of > arguments feres to the function wizard entry fields, and may be exceeded in > most (all?) cases. > > 2. Should mention in the notes that Number singular generally means either a > number or a range (one cell). Numbers plural generally means either a list > of numbers or a range of cells. eg if A1=1 B1=1 C1=1 SUM(1;1;1)=3 > SUM(A1:C1)=3 SUM(A1;B1;C1)=3 > > 3. typo in description of CONVERT, "wihtin" > > 4. description of SUMSQ delete the words "in the text fields". delete period > (.) after "30 arguments" > > 5. At page 46 some notes about Add-in Functions. "These can be installed > through the OOo Setup program." Possibly this is obsolete, the functions > seem to be installed by default and there is no longer a "OOo Setup > program"? I only checked a couple of the functions, they already > installed in m100 and m102 anyway. > > (b) This is just a job for the wish list, it is not urgent but it would > be an improvment. The syntax arguments are sometimes generic "number" > such as ABS(number) and sometimes specific to the function such as > COUPDAYS(settlment;frequency;maturity;basis). Should be consistent, > probably always be specific is better. > > > -- Regards, Rick Barnes www.nostabo.net ******************************************************************* PRIVILEGED - PRIVATE AND CONFIDENTIAL This electronic mail is solely for the use of the addressee and may contain information which is confidential or privileged. If you receive this electronic mail in error, please delete it from your system immediately and notify the sender by electronic mail or using any of the contact details noted herein. This e-mail sent via Evolution 2.2.1 running on a Linux 2.6.11 kernel.
signature.asc
Description: This is a digitally signed message part
