Search

Module: Editor

Version: 4.3.0 +

Type: All

Category: Conversion

 

Description

Along with the transition from tables to matrices in 4.3.0, several conversion formulas were added to accomodate the transition. Before 4.3.0, implicit conversions were made by Futurama in index columns of datatables. That is, if the index type in a datatable did not match the type in a formula (for example VLookUp), it was runtime converted automatically (and caused an error if the conversion was not allowed).

In versions 4.3.0+, it is no longer allowed to enter non-matching types in these formulas. For compatibility issues, the implicit conversions were made explicit and added to the formula library. Some of these formulas were deprecated immediately in version 4.3.0, because the conversion does not make any sense (but they could occur theorethically in the files). 

Other conversion formulas were deprecated in version 5.2.0, because similar formulas already existed.

This concerns formulas:

IDNameComment
277 ConvertToDouble(string) Use ConvertTextToNumber() instead
278 ConvertToDouble(long) Conversion is allowed by default in Futurama
280 ConvertToLong(string) Use Value() instead
283 ConvertToString(long) Use FormatNumber() instead
284 ConvertToString(double) Use FormatNumber() instead
286 ConvertToString(date) Use FormatDate() instead
290 ConvertToDate(string) Use ConvertTextToDate() instead
291 ConvertToDouble(date) Conversion is not allowed and will cause error
292 ConvertToLong(date) Conversion is not allowed and will cause error
293 ConvertToBoolean(date) Conversion is not allowed and will cause error
294 ConvertToDate(double) Conversion is not allowed and will cause error
295 ConvertToDate(long) Conversion is not allowed and will cause error
296 ConvertToDate(bool) Conversion is not allowed and will cause error

Related Topics

FormatNumber: To convert real numbers to text

FormatDate: To convert dates to text

Updated: 2014-01-28