Version: 5.0.0 +
Compatibility issue when updating files containing DataTables with empty elements
Up to version 5.0, DataTables could contain empty elements. These elements were returned as NULL within the context of the entire table result. With the introduction of matrices, this is not allowed anymore. DataTables return either matrices with valid values, or return NULL as a whole.
The existing of empty elements in the context of a DataTable is probably due to copying an insufficient number of cells (from Excel or another DataTable).
During automatic updating, the NULL values are converted to the default values of the datatype (0 for long or double, 1/1/1753 for dates empty strings for strings and false for booleans). Because in previous versions the values were automatically interpreted as default values, there are no effects on the behavior of Futurama.