Manuals/calci/CALCITOCHECK

1) ROWS function

• The function displays #NULL error with arguments as array values.

e.g. ROWS({1,2;3,4;5,6})

Expected result: 3

Observed result: #NULL

2)PRODUCT function

• If the cells in calci have numerical as well as text and empty cells, PRODUCT function assigns '0' to text and empty cells (instead they should be ignored).

e.g. PRODUCT(A1:A5) returns '0' where A1=2,A2=4,A3=TEXT,A4= ,A5=1

Expected result: 8

Observed result: 0

• Function works correctly with logical values. i.e. assigns TRUE=1, FALSE=0

3)OR function

• If the cells in calci have numerical as well as text and empty cells, OR function assigns '0'(FALSE) to text and empty cells (instead they should be ignored).

e.g. OR(TEXT, ) returns FALSE

Expected result: #NULL

Observed result: FALSE

4)HOUR,MINUTE,SECOND

• If the hour value >24, or Minute value > 59 or Second value > 59, Calci does not automatically advance the time with respect to input times.

e.g. HOUR("25:33") displays '#ERROR' (Output can be '1')

MINUTE("12:72:20") displays '0' (Output can be '12')

SECOND("12:10:72") displays '0' (Output can be '12')

• Function with serial numbers of time as input -

TIMEVALUE("3:30") gives 0.1458333333284827 (which is correct)

If the above serial number is used as input to HOUR, MINUTE and SECOND functions, following are the observations :

• HOUR(0.1458333333284827) displays '19' (Expected Output: '3')
• MINUTE(0.1458333333284827) displays '0' (Expected Output: '30')
• SECOND(0.1458333333284827) displays '0' (correct. But displays '0' for other serial numbers too)

The output is same(i.e. 19,0,0) for any other serial numbers (e.g 0.9479166666642413 for "10:45 PM").

5)GOLDENRATIO

a)Suggestion: Argument name can be changed to 'logic_value' instead of 'smallphi'

Reason: Argument can be TRUE or FALSE or 1 or 0 for this function. 'smallphi' and 'capitalphi' are the output values obtained.

b)Calci does not give error for -

*Invalid arguments like GOLDENRATIO(7), GOLDENRATIO("ABCDEF"), GOLDENRATIO(-8)
*Multiple arguments like GOLDENRATIO(100,77)

c)Calci help displays incorrect values for smallphi and capitalphi.

• Observed result:

GOLDENRATIO(TRUE) returns 1.618033988749895

GOLDENRATIO(FALSE) returns 0.6180339887498948

• Expected result:

GOLDENRATIO(TRUE) returns 0.6180339887498948, value of capitalphi Φ

GOLDENRATIO(FALSE) returns 1.618033988749895, value of smallphi φ

d)If argument is ignored, i.e. GOLDENRATIO()

• Observed result: 0.6180339887498948, value of capitalphi Φ
• Expected result: 1.618033988749895, value of smallphi φ

Reason: smallphi is default value for Goldenratio. Capitalphi is the conjugate value.

6)HYPERLINK

• Link to specified location gets created in Calci. But document/website does not open up.

e.g.

=HYPERLINK("http://www.google.com","Click here")