Formulas with Limited Support
This page contains a list of formulas with limited support in SpreadsheetWEB, and also includes possible workarounds.
CELL – Parameter Limitation
This function can only be used with “address”, “row”, “col” and “type” parameters. Function returns #VALUE! with other parameters. For example:
=CELL(A1,$A$1) =CELL(A2,$A$1) =CELL(A3,$A$1) =CELL(A4,$A$1) =CELL(A5,$A$1) =CELL(A6,$A$1) =CELL(A7,$A$1) =CELL(A8,$A$1) =CELL(A9,$A$1)
There is no workaround
Some units are not supported. For example:
- Pa – psi
- N – lbf
- kg – lbm
Proposed workaround is to use simple math to convert between units.
Function may fail when used with other functions: For example:
Proposed workaround is separating other functions and HYPERLINK:
Function results may be inaccurate. For example:
There is no specific way.
Proposed workaround is avoiding using INDIRECT
If a number is used instead of range or array as [result_vector] parameter; SpreadsheetWEB fails. For example:
Proposed workaround is using range for [result_vector]: