User Tools

Site Tools


syntax:types

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
syntax:types [2017/12/23 09:44] dmitrysyntax:types [2017/12/23 09:48] dmitry
Line 16: Line 16:
 <code>-12.4</code> <code>-12.4</code>
  
-To convert text values to numbers see [[syntax:functions:asnumber]] function.+To convert text values to numbers see the [[syntax:functions:asnumber]] function.
  
 ==== Dates ==== ==== Dates ====
Line 38: Line 38:
  
 Note: Ampersand (&) is the text concatenation operator. Note: Ampersand (&) is the text concatenation operator.
-To convert values to text see [[syntax:functions:astext]] function.+To convert a value to text see the [[syntax:functions:astext]] function.
  
 ==== Boolean ==== ==== Boolean ====
Line 45: Line 45:
  
 ==== Error ==== ==== Error ====
-Error is a special value that indicates incorrect calculation. It can only be a result of an expression. You can check if a value is an error using [[syntax:functions:iserror]] function.+Error is a special value that indicates incorrect calculation. It can only be a result of an expression. You can check if a value is an error using the [[syntax:functions:iserror]] function. 
 + 
 +You can also create an error values use the [[syntax:functions:error]] function.
  
 ==== Empty values ==== ==== Empty values ====
-If a table cell has no value - it's so called //empty value//. You can check if a column value is empty using [[syntax:functions:isempty]] function. The length of an empty value is always zero.+If a table cell has no value - it'the so called //empty value//. You can check if a column value is empty using [[syntax:functions:isempty]] function. The length of an empty value is always zero.
  
 Empty values are somewhat similar to nulls in relational databases but not exactly. For instance an empty value always equals to another empty value and equals to empty string. Empty values are somewhat similar to nulls in relational databases but not exactly. For instance an empty value always equals to another empty value and equals to empty string.
syntax/types.txt · Last modified: 2021/05/12 07:33 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki