TAtlasColumnKind

ackText value

ackText

Any text, stored unchanged (including leading and trailing spaces).

ackNumber value

ackNumber

A finite number in invariant format: . as decimal separator, optional sign and exponent, no thousands separators (12.50, -3, 1e3; surrounding spaces are accepted). Stored in the shortest invariant form (12.5, -3, 1000). NaN, INF, 1,000 and locale forms such as 12,5 raise EAtlasDataError. Sorted numerically and right-aligned in TAtlasGrid.

ackBoolean value

ackBoolean

true or false in any case, or 1 / 0. Stored as true or false.

ackDate value

ackDate

A calendar date written exactly as YYYY-MM-DD: four-digit year 0001 to 9999, two-digit month and day, and a real date (2024-02-29 is accepted, 2025-02-29 is not). Stored unchanged, so text order is date order. There is no time part and no locale format.

See what each kind stores

AtlasNormalizeValue returns the stored form or raises, exactly like AddRow. The comments show the output.

uses System.SysUtils, Atlas.Data;

procedure ShowNormalizedValues;
begin
  Writeln(AtlasNormalizeValue(ackNumber, '12.50'));    // 12.5
  Writeln(AtlasNormalizeValue(ackNumber, '1e3'));      // 1000
  Writeln(AtlasNormalizeValue(ackBoolean, 'TRUE'));    // true
  Writeln(AtlasNormalizeValue(ackBoolean, '0'));       // false
  Writeln(AtlasNormalizeValue(ackDate, '2024-02-29')); // 2024-02-29
  try
    AtlasNormalizeValue(ackNumber, '12,5');
  except
    on E: EAtlasDataError do
      Writeln(E.Message);                              // Invalid finite number: 12,5
  end;
end;