Difference between revisions of "Manuals/calci/CALCITOCHECKFIXED"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "==PLEASE ADD FIXED ITEMS HERE AFTER TESTING==")
 
Line 1: Line 1:
 
==PLEASE ADD FIXED ITEMS HERE AFTER TESTING==
 
==PLEASE ADD FIXED ITEMS HERE AFTER TESTING==
 +
 +
='''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''
 +
 +
==ROWS EXPLANATION==
 +
This will work only in CALCI as the {} notation for array is useful only in spreadsheet platforms and similar languages. In ZOS arrays are to be indicated by [] and Objects will use {} notation.
 +
 +
*''Rows Function Comments: Reading the explanation, this issue can be ignored. --- Swapna''
 +
 +
 +
='''RANDOMNUMBERGENERATION''', '''RANDOMNUMBERGENERATIONUNIFORM''', '''RANDOMUNIFORM''', '''PATTERENED'''=
 +
*Random number output is not displayed. Same command is displayed on space cube.
 +
e.g. =RANDOMNUMBERGENERATION(3, 4, "Uniform", TRUE, 3, 4)
 +
=RANDOMNUMBERGENERATION(3, 4, "Patterned", TRUE,1, 5, 3, 4)
 +
 +
RANDOMNUMBERGENERATION(30, 4, "Uniform", TRUE, 3, 4)
 +
 +
{| class="wikitable"|-
 +
| 3.195449711289257 || 3.2248697481118143 || 3.0816136938519776 || 3.2126745639834553 || 3.990793523611501 || 3.649687875760719 || 3.759418284520507 || 3.965467617381364 || 3.9545328468084335 || 3.3741041221655905 || 3.1905515757389367 || 3.777756262337789 || 3.9837128871586174 || 3.432979935547337 || 3.9010994143318385 || 3.7845077733509243 || 3.421978456666693 || 3.813554910942912 || 3.168992273742333 || 3.2010161119978875 || 3.9937344735953957 || 3.459437067853287 || 3.384454872459173 || 3.0950622770469636 || 3.1798048589844257 || 3.407964985817671 || 3.6846570973284543 || 3.6611867914907634 || 3.9072526150848716 || 3.2141497172415257
 +
|-
 +
| 3.2669153639581054 || 3.2465451690368354 || 3.0314107462763786 || 3.88823653687723 || 3.6240376371424645 || 3.0279260887764394 || 3.4216481952462345 || 3.747306031640619 || 3.515739459078759 || 3.175762218190357 || 3.6369324799161404 || 3.7142539599444717 || 3.6433018636889756 || 3.133950341725722 || 3.6951540084555745 || 3.4156028230208904 || 3.240273320581764 || 3.4762711247894913 || 3.7170767160132527 || 3.180914681404829 || 3.9355433725286275 || 3.0196601944044232 || 3.3859861323144287 || 3.854840762214735 || 3.37747969920747 || 3.7828165935352445 || 3.326533603016287 || 3.7698845479171723 || 3.1485248988028616 || 3.0072317481972277
 +
|-
 +
| 3.9251055871136487 || 3.2557102914433926 || 3.788066220469773 || 3.207987993489951 || 3.588850313099101 || 3.870454262243584 || 3.9496661769226193 || 3.4028041230048984 || 3.6568462373688817 || 3.6426883353851736 || 3.9649933751206845 || 3.2784565046895295 || 3.246733759297058 || 3.380512889707461 || 3.0992100907023996 || 3.739959954516962 || 3.3115603323094547 || 3.2317469376139343 || 3.5847271364182234 || 3.594636262860149 || 3.9285641501192003 || 3.712517147185281 || 3.9386905138380826 || 3.8844250414986163 || 3.1710384245961905 || 3.583163051167503 || 3.137686180183664 || 3.990223975619301 || 3.3122955770231783 || 3.6850603164639324
 +
|-
 +
| 3.162752259755507 || 3.126228274544701 || 3.4762895670719445 || 3.242924148682505 || 3.0085414829663932 || 3.9302729363553226 || 3.777372183976695 || 3.940537365153432 || 3.640196947613731 || 3.316979159368202 || 3.1863948297686875 || 3.9217444960959256 || 3.964422813616693 || 3.0397708313539624 || 3.883876184700057 || 3.882750508841127 || 3.485125683248043 || 3.8928709470201284 || 3.5129915438592434 || 3.0280541735701263 || 3.621288023889065 || 3.5997950434684753 || 3.1812141358386725 || 3.4793242022860795 || 3.4653837154619396 || 3.982316398760304 || 3.9729056453797966 || 3.0827220352366567 || 3.775389570510015 || 3.457127903588116
 +
|}
 +
Is this correct?
 +
 +
Has been corrected so that true false flag will show inside a cube or on ZOS.
 +
==Please check this in the next release ==
 +
(In ZOS it will show result in the window. In CALCI it will create a new window depending on request flag).
 +
 +
*Test Comments: '''Issue resolved. Working''' ---- Swapna
 +
 +
 +
='''MATCH(lkup_val, lkup_arr, m_type)'''=
 +
Issue: Function does not work in ZOS if lkup_arr represented with {} brackets, whereas works with [ ].
 +
 +
*ZCalci works with both type of array representation {}, [] and displays correct results -
 +
e.g.
 +
*MATCH(44,{40,42,44},1) does not work in ZOS.
 +
*MATCH(44,[40,42,44],1) returns relative position of '44' as '''3''' in ZOS.
 +
==MATCH EXPLANATION==
 +
See after new release if issue persists.
 +
 +
*''Test Comments : {} notation works in spreadsheet platforms. Hence {},[] both work in Calci and [] works in ZOS. This issue can be ignored --- Swapna''
 +
 +
 +
='''MID(txt, snum, noc)'''=
 +
Issue: Returns #NULL error, if 'txt' starts with a number.
 +
 +
e.g.
 +
*MID("123456",2,4) returns '''NULL'''.
 +
*MID("A123456",2,4) returns '''A123'''
 +
 +
*Test Comments (MID) : '''Issue resolved. Working''' ----- Swapna
 +
 +
 +
='''SUBSTITUTE(txt, otxt, ntxt, instnum)'''=
 +
Use: Function is used to replace nth instance of 'otxt' with 'ntxt'. Original string is in 'txt'.
 +
 +
Issue: If the original string '''starts with number''', Calci displays NULL error.
 +
 +
e.g.
 +
SUBSTITUTE("123456","123","888",1)
 +
*Expected result: "888456"
 +
*Observed result: #NULL (In Calci)
 +
*Works well in ZOS.
 +
 +
*Test Comments (SUBSTITUTE) : '''Issue resolved. Working''' ----- Swapna

Revision as of 05:51, 29 April 2014

PLEASE ADD FIXED ITEMS HERE AFTER TESTING

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

ROWS EXPLANATION

This will work only in CALCI as the {} notation for array is useful only in spreadsheet platforms and similar languages. In ZOS arrays are to be indicated by [] and Objects will use {} notation.

  • Rows Function Comments: Reading the explanation, this issue can be ignored. --- Swapna


RANDOMNUMBERGENERATION, RANDOMNUMBERGENERATIONUNIFORM, RANDOMUNIFORM, PATTERENED

  • Random number output is not displayed. Same command is displayed on space cube.

e.g. =RANDOMNUMBERGENERATION(3, 4, "Uniform", TRUE, 3, 4) 

=RANDOMNUMBERGENERATION(3, 4, "Patterned", TRUE,1, 5, 3, 4)

RANDOMNUMBERGENERATION(30, 4, "Uniform", TRUE, 3, 4)

3.195449711289257 3.2248697481118143 3.0816136938519776 3.2126745639834553 3.990793523611501 3.649687875760719 3.759418284520507 3.965467617381364 3.9545328468084335 3.3741041221655905 3.1905515757389367 3.777756262337789 3.9837128871586174 3.432979935547337 3.9010994143318385 3.7845077733509243 3.421978456666693 3.813554910942912 3.168992273742333 3.2010161119978875 3.9937344735953957 3.459437067853287 3.384454872459173 3.0950622770469636 3.1798048589844257 3.407964985817671 3.6846570973284543 3.6611867914907634 3.9072526150848716 3.2141497172415257
3.2669153639581054 3.2465451690368354 3.0314107462763786 3.88823653687723 3.6240376371424645 3.0279260887764394 3.4216481952462345 3.747306031640619 3.515739459078759 3.175762218190357 3.6369324799161404 3.7142539599444717 3.6433018636889756 3.133950341725722 3.6951540084555745 3.4156028230208904 3.240273320581764 3.4762711247894913 3.7170767160132527 3.180914681404829 3.9355433725286275 3.0196601944044232 3.3859861323144287 3.854840762214735 3.37747969920747 3.7828165935352445 3.326533603016287 3.7698845479171723 3.1485248988028616 3.0072317481972277
3.9251055871136487 3.2557102914433926 3.788066220469773 3.207987993489951 3.588850313099101 3.870454262243584 3.9496661769226193 3.4028041230048984 3.6568462373688817 3.6426883353851736 3.9649933751206845 3.2784565046895295 3.246733759297058 3.380512889707461 3.0992100907023996 3.739959954516962 3.3115603323094547 3.2317469376139343 3.5847271364182234 3.594636262860149 3.9285641501192003 3.712517147185281 3.9386905138380826 3.8844250414986163 3.1710384245961905 3.583163051167503 3.137686180183664 3.990223975619301 3.3122955770231783 3.6850603164639324
3.162752259755507 3.126228274544701 3.4762895670719445 3.242924148682505 3.0085414829663932 3.9302729363553226 3.777372183976695 3.940537365153432 3.640196947613731 3.316979159368202 3.1863948297686875 3.9217444960959256 3.964422813616693 3.0397708313539624 3.883876184700057 3.882750508841127 3.485125683248043 3.8928709470201284 3.5129915438592434 3.0280541735701263 3.621288023889065 3.5997950434684753 3.1812141358386725 3.4793242022860795 3.4653837154619396 3.982316398760304 3.9729056453797966 3.0827220352366567 3.775389570510015 3.457127903588116

Is this correct?

Has been corrected so that true false flag will show inside a cube or on ZOS.

Please check this in the next release

(In ZOS it will show result in the window. In CALCI it will create a new window depending on request flag).

  • Test Comments: Issue resolved. Working ---- Swapna


MATCH(lkup_val, lkup_arr, m_type)

Issue: Function does not work in ZOS if lkup_arr represented with {} brackets, whereas works with [ ].

  • ZCalci works with both type of array representation {}, [] and displays correct results -

e.g.

  • MATCH(44,{40,42,44},1) does not work in ZOS.
  • MATCH(44,[40,42,44],1) returns relative position of '44' as 3 in ZOS.

MATCH EXPLANATION

See after new release if issue persists.

  • Test Comments : {} notation works in spreadsheet platforms. Hence {},[] both work in Calci and [] works in ZOS. This issue can be ignored --- Swapna


MID(txt, snum, noc)

Issue: Returns #NULL error, if 'txt' starts with a number.

e.g.

  • MID("123456",2,4) returns NULL.
  • MID("A123456",2,4) returns A123
  • Test Comments (MID) : Issue resolved. Working ----- Swapna


SUBSTITUTE(txt, otxt, ntxt, instnum)

Use: Function is used to replace nth instance of 'otxt' with 'ntxt'. Original string is in 'txt'.

Issue: If the original string starts with number, Calci displays NULL error.

e.g. 

SUBSTITUTE("123456","123","888",1)
  • Expected result: "888456"
  • Observed result: #NULL (In Calci)
  • Works well in ZOS.
  • Test Comments (SUBSTITUTE) : Issue resolved. Working ----- Swapna
Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/CALCITOCHECKFIXED&oldid=198740"