Select Page

# Formulas with Limited Support

You are here:

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)`