I can’t find any detailed documentation on the ANACONDA.CODE function. I can see through the IDE/GUI that cell references become parameters into the function after the “mode” parameter to be substituted into any “REF()” function. What’s not clear to me is the parameter “link” followed by a cell reference.
It’s clearly related to running the code in “linked mode”, but it’s not clear to me how the cell reference following that “link” string is determined. It appears to simply be whatever the previous cell with python code is, presumably to chain them all together in “row major order”? Or should that reference be only to the cell (or cells) that the current cell is relying on? I suspect the former but just want to be sure
Anaconda Code author here. ANACONDA.CODE() formulas are not intended to be user-modifiable outside of the Anaconda Code Editor. In fact, when the editor writes a formula, it always add ### Do Not Edit this formula directly. Use Anaconda Code to modify. as the first line. This message is intentional.
If you’re really curious and want to know the details, I can share. But parameters like “link” are implementation details which might change in the future and should not be relied upon. Yes, it is related to “linked mode” and ensures that cells are run in row-major order – the same order that Python in Excel (=PY) cells are run. Attempting to modify values after the “link” parameter will cause Anaconda Code to re-write the formula and correct it back to row-major order.
Understood - thanks Jim. To be clear, I’m not modifying the code outside of the code editor, just wanted to make sure that it wasn’t a bug perhaps that it was only linking to one cell rather than all dependent cells - so your explanation answers my question, no more detail needed
