Please correct me if my understanding is not right :
I think persistent objects (sheets and chart objects) without show/hide conditions are not calculated but consume tiny memory to store properties. But if there is show/hide condition in the sheet/chart properties then the calculation is done and full memory is used. Is this right?
Also, I wanted to understand how accurate is the memory statistics? Some of the simple chart objects consume high memory and high calculation time. Please can you explain?
Thank you for your help.
Let me add few more to what deepak asked. i see calculation time varies each time it shows as 16 sometime and sometime it shows as 1216 .
the number it's showing is sec or milliseconds ?
And i have a straight table with 3 dimension and 5 expression (of around like 800 records ). but i cloned the same object and removed one expression.
when i see the calculation time for the object with 5 expression takes about 1155 and same object with four expressiion takes about 1170.
I couldn't interpret anything with this result can somebody throw some light on this
Thanks In Advance
Have a good day