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)

Workaround

There is no workaround

CONVERT – Parameter Limitation

Some units are not supported. For example:

• Pa – psi
• N – lbf
• kg – lbm

Workaround

Proposed workaround is to use simple math to convert between units.

HYPERLINK – Incompatibility with other functions

Function may fail when used with other functions: For example:

=HYPERLINK(CONCATENATE("www",".pagos.com"))

Workaround

Proposed workaround is separating other functions and HYPERLINK:

=HYPERLINK(A1)

INDIRECT – May cause mismatches even undetectable by SSDIFF

Function results may be inaccurate. For example:

There is no specific way.

Workaround

Proposed workaround is avoiding using INDIRECT

LOOKUP – Number as a [result_vector] behavior

If a number is used instead of range or array as [result_vector] parameter; SpreadsheetWEB fails. For example:

=LOOKUP(A1,B1:B10,1)

Workaround

Proposed workaround is using range for [result_vector]:

=LOOKUP(A1,B1:B10,C1:C10)