A new version of the encryption software was used to copy-protect GEM4D, which caused a virus warning on some computers. I reverted back to the earlier encryption version for Version 1.8.4.4, and made two improvements:
In previous versions of GEM4D, CSV data-files with inconsistent formatting could crash the program or cause unnecessary data loss. Error catchers were added that solves most of these issues - see the discussion under "NOTE" below.
Version 1.8.4.2 added rudimentary support for DateTime data columns, which was further improved in the latest version.
NOTE: When loading a CSV data file, always ensure that the formatting of the first data row is correct, as the first row is used to assign the formatting of the data columns. A few examples of the importance are:
If the first data row contains text in a data column, all the cells in the column will be read as text and not as values. This makes a difference when filtering data in the data-grid, as text cannot be sorted from small to large etc.
If the first data row contains a value in a data column, all the cells in the column have to be values. If a data row contains text when a value is expected, the cell will be filled with "NaN" (Not-A-Number), which is a valid 'number' in code. Filter out these "NaN" cells in the data-grid, which works similar to Excel filtering.
If a cell is empty and text is expected, the cell will automatically be filled with "Unknown".
If a cell is empty and a value is expected, the cell will automatically be filled with "NaN".
If the first row has empty cells, please complete the cells of the first row with "NaN" to indicate a value column, and "Unknown" to indicate a text column.
Comments