Difference between revisions of "Manuals/calci/CALCITOCHECKFIXED"
Jump to navigation
Jump to search
| Line 12: | Line 12: | ||
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. | 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 Test Comments== | |
| + | Reading the explanation, this issue can be ignored. --- Swapna | ||
| Line 37: | Line 38: | ||
(In ZOS it will show result in the window. In CALCI it will create a new window depending on request flag). | (In ZOS it will show result in the window. In CALCI it will create a new window depending on request flag). | ||
| − | + | ==RANDOMNUMBERGENERATION Test Comments== | |
| + | Issue resolved. Working ---- Swapna | ||
| Line 50: | Line 52: | ||
See after new release if issue persists. | See after new release if issue persists. | ||
| − | + | ==Match Function Test Comments== | |
| + | {} notation works in spreadsheet platforms. Hence {},[] both work in Calci and [] works in ZOS. This issue can be ignored --- Swapna | ||
| Line 60: | Line 63: | ||
*MID("A123456",2,4) returns '''A123''' | *MID("A123456",2,4) returns '''A123''' | ||
| − | + | ==MID Function Test Comments== | |
| + | Issue resolved. Working ----- Swapna | ||
| Line 74: | Line 78: | ||
*Works well in ZOS. | *Works well in ZOS. | ||
| − | + | ==SUBSTITUTE Function Test Comments== | |
| + | Issue resolved. Working ----- Swapna | ||
Revision as of 11:52, 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 Test 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).
RANDOMNUMBERGENERATION 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.
Match Function 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
MID Function Test Comments
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.
SUBSTITUTE Function Test Comments
Issue resolved. Working ----- Swapna