Converting 4D View plug-in formulas

Home

4D v17

Overview

As stated in the Converting 4D View documents page, most of the 4D View plug-in document contents and properties can be converted in 4D View Pro documents.

Formulas are also converted. However, the formula languages of 4D View and 4D View Pro are somewhat different. Three compatibility cases can occur:

a 4D View feature (operator, constant, function) is exactly the same in 4D View Pro: in this case, the conversion is transparent.
a 4D View feature is supported in 4D View Pro through a different function or operator: in this case, an automatic mapping is performed
a 4D View feature is partially or not supported in 4D View Pro: in this case, it will be necessary to adapt your converted formulas to make them work as expected.

The following tables list 4D View formula features and their corresponding features in 4D View Pro.

Operators

	4D View	4D View Pro
Numeric operators
Addition	+	+
Substraction	-	-
Multiplication	*	*
Division	/	/
Remainder	\	MOD
Integer division	÷	TRUNC(a/b)
Exponent	^	^
Percentage	%	%

Boolean operators
AND	&	AND
OR	\|	OR
Not	~	NOT

String operators
concatenation	+	&
destruction	-	SUBSTITUTE, ex: "Down Trend"-"Down" is replaced by SUBSTITUTE("Down Trend","Down","")
position	\	FIND (case sensitive) or SEARCH (case insensitive)

Date operators
date+days->date	+	+
date+time->date+time of day	+	+
date-days->date	-	-
date-date->number of days	-	-

Duration operators
addition	+	+
substraction	-	-
multiplication	*	*
division	/	/

Comparison operators
equality	=	=
difference	#	<>
greater than	>	>
less than	<	<
greater than or equal to	>=	>=
less than or equal to	<=	<=

Functions

4D View	4D View Pro	Comment
Abs	ABS
AddToDate	DATE	AddToDate(date;years;months;days) is replaced by DATE(YEAR(date)+years,MONTH(date)+months,DAY(date)+days)
date+time	TIME	DATE(date) + TIME(time)
And	AND
ArcCos	ACOS
ArcSin	ASIN
ArcTan	ATAN
Area	-	n/a (no plug-in area)
Average	AVERAGE
Cell	INDIRECT
Column	COLUMNLETTER	COLUMN returns a number (not a letter)
Cos	COS
Count	COUNTA
CurrentDate	TODAY
CurrentTime	NOW
CVCompound	PV	CVCompound(1%;5;1000) is replaced by PV(1%,5,-1000)
CVSimple	PV	CVSimple(1%;5;5*1000) is replaced by PV(1%,5,,-1000) -- note the two consecutive commas
Empty	ISBLANK
Eval4D	-	Currently not available
Exp	EXP
False	FALSE
Find	LOOKUP
FindCell	FINDCELL
FVCompound	FV	FVCompound(1%;35;35*1000) is replaced by FV(1%,35,-1000)
FVSimple	FV	FVSimple(12%;35;351000) is replaced by FV(12%,35,,-351000) -- note the two consecutive commas
If	IF
Length	LEN
Log	LN
Max	MAX
Min	MIN
MonthlyValue	PMT	MonthlyValue(10.5%/12,48,6500) is replaced by PMT(10.5%/12,48,-6500)
Not	NOT
Or	OR
PeriodNumber1	NPER	PeriodNumber1(10.5%/12;166.42;6500) is replaced by NPER(10.5%/12,-166.42,6500)
PeriodNumber2	NPER	PeriodNumber2(10.5%/12,5000,3000) is replaced by NPER(10.5%/12,,3000,-5000) -- note the two consecutive commas
Pi	PI
Random	RAND
Range	INDIRECT	Range("A1";"A3") is replaced by INDIRECT("A1:A3") -- note the colon character between A1 and A3
Rate1	RATE	Rate1(5;1000;3000) is replaced by RATE(5,-1000,3000)
Rate2	RATE	Rate2(5,6000,2800) is replaced by RATE(5,,2800,-6000) -- note the two consecutive commas
Rounding	ROUND
Row	ROW
Sin	SIN
SquareRoot	SQRT
StdDeviation	STDEV.P
String	TEXT
SubString	MID
Sum	SUM
Tan	TAN
True	TRUE
Type	TYPE	Returned types in 4D View Pro are different from 4D View
Variance	VAR.P