Hi Rom,
The difference between PALO.DATA and DATAC: DATAC collects all the formulas in a workbook and executes them in one go, where PALO.DATA executes them one after the other the way Excel does (randomly more or less). The latter may mean many database accesses and thus a somewhat slower performance but you will need to use PALO.DATA if you have Palo formulas which involve values that are retrieved by another Palo formula.
So if you need a simple list for example, we recommend to use PALO.DATAC, sophisticated setups however where you use push-rules require PALO.DATA.
PALO.DATAV allows an even quicker access to your data. DATAV sends just one query to the database for all the cells in your worksheet that contain PALO.DATAV functions, and it receives all data in one array.
Limits: PALO.DATAV only works for tables where all DATAV formulas sit in a coherent array, it is not possible to have cells with other functions in between. And it only works where columns and rows contain just one dimension. For example you cannot use PALO.DATAV in a worksheet that shows both products and months in columns or rows.
Regards
Holger
Jedox QA
