Date: Thu, 28 Mar 2024 14:41:54 +0100 (CET) Message-ID: <821489334.111080.1711633314808@srvdoc.doc.ipesoft.com> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_111079_1182378744.1711633314808" ------=_Part_111079_1182378744.1711633314808 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Accessing the current value of a D2000 system object is allowed by the f= unction D2_GetValue.
D2_GetValue(objName, attribut= e, refresh)
objName | TEXT ty= pe |
Object name. |
attribute | TEXT typ= e |
Required object value attribute. |
refresh | Optional parameter. |
The optional parameter Refresh is used to force the of the functi=
on computation. The parameter has been implemented for the reason of the MS=
Excel method to calculate expressions in a cell.
Expressions will be calculated if:
The parameter Refresh allows to initialize calculating the expres= sion.
=3D D2_GetValue("Sec", "")
The expression gets the value of the object Sec right in the m= oment of computation. Reloading the current value can be performed only= by manual editing of the expression.
Expression in cell:=20=3D D2_GetValue("Sec", "TIM")=
The function works analogous to the previous example, but its return val= ue is the time of the object value (in D2000 system, there is an equivalent= declaration Sec\TIM).
Both the expressions give one trouble: the cells containing such express= ions will not be updated after opening the workbook. Their contents stay un= changed since last the cells was editing last time (and saving the workbook= ). Using the parameter Refresh eliminates the problem.
Expressio= ns in cell:=20=3D D2_GetValue("Sec", "", A3= )
The function works analogous to the previous example. Using the optional= parameter will provides for computation of the expression if the value of = the cell A3 is changed.
If the following expression is typed into the c= ell A3:=20=3D NOW()
the expression D2_GetValue(=E2=80=9CSec=E2=80=9D, =E2=80=9C=E2=80=9D, A3= ) will be computed also when the workbook is opening.
For the parameter Refresh, it is appropriate to use the reference= to the cell D2000_BT (the cell is automatically computed when the w= orkbook is opening =E2=80=93 see the topic Predefined cells).