Re: AFC
Vladimir Korenev
Please write to the discussion group, so other users can find answers if
they have similar questions.
> - Can AFC use user-defined cell names to resolve input and output
> references if the when the inputs and outputs are cell ranges instead of
> single cells? For example, if the user assigns the name "I_data" to the
> range A3:A1002, can AFC automatically assign that range to an input
> method? If the user assigns the name "O_results" to the range E3:Z3,
> can AFC assign that to an output method?
For input cell range it depends on how this range is used. If the range
is used as a whole (e.g. in aggregation functions) and is referenced by
its name then you can define a repeating section. You can also define a
repeating section if you have an array of the same input and output
cells and formulas. You can read more about repeating sections and find
examples here:
http://www.formulacompiler.org/doc/tutorial/repeatingsections.htm
http://www.formulacompiler.org/doc/tutorial/repeatingsections_withoutputs.htm
> - If a cell or range of cells is mapped to an output method, can the
> formula in the cell(s) refer to other cells that are not input cells
> (i.e., cells that have been mapped to an input method)? Can one output
> cell refer to another output cell?
The formula in the cell can refer to other cells with formulas and
values. If a cell is not mapped to an input method then its value from
the spreadsheet is taken. Please note that AFC does not fully support
null/empty values now. Although we consider better support for nulls for
one of the future releases. For now the value of empty cell is
considered to be either an empty string or 0 for numbers.
Yes, output cell can refer to another output cell.
Vova