This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
en:cachevariables [2022/02/22 10:19] – [Value types] lineflyer | en:cachevariables [2022/11/25 11:53] – [Functions] Add TRUNC function lineflyer | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | **FIXME** This will be used to describe the new tab on cache details used for cache variables. | ||
- | |||
- | **FIXME** We could add a chapter with some practical How-To examples (e.g. typical lettervalue case) | ||
- | |||
====== Cache Variables ====== | ====== Cache Variables ====== | ||
Line 95: | Line 91: | ||
|''/'' | |''/'' | ||
|'' | |'' | ||
- | |'' | + | |'' |
|'' | |'' | ||
Line 113: | Line 109: | ||
* Else the fifth parameter is returned | * Else the fifth parameter is returned | ||
- | For example '' | + | For example '' |
^ Operator ^ Meaning ^ Example ^ | ^ Operator ^ Meaning ^ Example ^ | ||
Line 131: | Line 127: | ||
The following functions are defined: | The following functions are defined: | ||
- | ^ Function ^ Synonyms ^ Description ^ Parameter1 | + | ^ Function ^ Synonyms ^ Description ^ Parameter 1 ^ Parameter 2 ^ Example ^ |
|'' | |'' | ||
|'' | |'' | ||
|'' | |'' | ||
- | |'' | + | |'' |
+ | |'' | ||
|'' | |'' | ||
|'' | |'' | ||
Line 144: | Line 141: | ||
|'' | |'' | ||
|'' | |'' | ||
- | |||
==== Variables ==== | ==== Variables ==== | ||
Line 202: | Line 198: | ||
* '' | * '' | ||
- | When a range is used in a context where only one value is allowed (this is the case in normal calculation), | + | When a range is used in a context where only one value is allowed (this is the case in normal calculation), |
Ranges currently support only positive constant integer values. A range must always be evaluate to at least 1 value and a range may not evaluate to more than 20 values. For example the following ranges are invalid: | Ranges currently support only positive constant integer values. A range must always be evaluate to at least 1 value and a range may not evaluate to more than 20 values. For example the following ranges are invalid: | ||
Line 215: | Line 211: | ||
* '' | * '' | ||
* '' | * '' | ||
+ | |||
+ | |||
+ | ==== Comments ==== | ||
+ | |||
+ | You may enter comments into formula expressions using the ''#'' | ||
+ | * '' | ||
+ | * '' |