Posted 12 December 2023, 6:14 am EST
Dear all,
We are writing an Excel Workbook containing several Formulas, referenced named cells, and named tables. We have about 700 formulas ranging from highly complex to very simple. All cells containing formulas are themselves named. However, 103 formulas are not appearing in their corresponding cells. As a result, these cells remain blank. The strange thing is that there is no apparent pattern or similarities in the formulas which are not showing up. Complex as well as simple ones are affected. When manually copy-pasting these formulas into an excel workbook containing all necessary named cell references, the formulas work just fine. Could this be a bug?
Here are some examples of simpler formulas not showing up:
xlookup(surv.regi.r_regiid;dt_regi[id];dt_regi[nair])
surv.confs[deva__numericvalue]
if(surv.licas[outs]=enums.eyesorno.yes;100;surv.licas[frmo__numericvaluerowwise])
surv.datalot.results.enc.eif/xlookup(surv.regi.r_regiid;dt_regi[id];dt_regi[enin])
if(surv.qolis[ippe];surv.qolis[hshe__numericvalue];na())
The following error messages are thrown for each formula not showing up (see also screenshot):
Error while setting Excel FormulaId: ‘surv.datalot.results.nit.nai’, Formula: ‘xlookup(surv.regi.r_regiid,dt_regi[id],dt_regi[nair])’ : The formula in LH5 is invalid! [xlookup(surv.regi.r_regiid,dt_regi[id],dt_regi[nair])]
To further assist in diagnosing this issue, we are willing to provide the entire Excel file upon request.
Moreover, we would like to express our interest in purchasing this product. However, it is crucial for our decision that the product can compute all of these Excel formulas properly.
Any help is much appreciated.
Many thanks and best regards,
Jan
