Converting DR Functions

To be able to use ClausionDROnline with DR documents that contain functions created with an older ClausionDR version, the functions must be converted.

Note: The Conversion of Functions feature is available only in ClausionDROnline version.

Before converting (Convert), make a backup of your DR document. The changes cannot be undone.

Cross-language conversion

When creating formulas intended for cross-language use (converting DROnline formulas between English-language Excel and Finnish-language Excel), default to using 1/0 for boolean logic instead of using localized boolean values (TRUE/FALSE or TOSI/EPÄTOSI), to avoid conversion issues. Formulas containing localized boolean values may fail after conversion.

• Use 1 instead of TRUE/TOSI
• Use 0 instead of FALSE/EPÄTOSI

For example, replace:

=CLAUSION.DRDATA("ACT";"10000;20000";"979989P";"2023";"12";TRUE;"EUR";"UNIT1")

with:

=CLAUSION.DRDATA("ACT";"10000;20000";"979989P";"2023";"12";"1";"EUR";"UNIT1")

where 1 indicates that the data is cumulative (0 = non-cumulative).

This is a known limitation of Excel.