Login Page - Create Account

Support Board


Date/Time: Sat, 27 Apr 2024 22:13:17 +0000



Post From: Spreadsheet errors

[2018-07-03 21:26:32]
VladimirP - Posts: 614
It is a bit annoying that formulas are truncated:

[ N21 ] IF(OR(L21=1,AND(N21=0,(ID0.SG2@20-M21)<=1.25)),... = 0 (number, integer)
  [ IF ] IF(OR(L21=1,AND(N21=0,(ID0.SG2@20-M21)<=1.25)),... = N21 (reference)
    [ OR ] OR(L21=1,AND(N21=0,(ID0.SG2@20-M21)<=1.25)) = 0 (number, integer)
      [ = ] L21=1 = 0 (number, integer)
        [ L21 ] L21 = 2 (number, integer)
        [ 1 ] 1 = 1 (number, integer)
      [ AND ] AND(N21=0,(ID0.SG2@20-M21)<=1.25) = 0 (number, integer)
        [ = ] N21=0 = 1 (number, integer)
          [ N21 ] N21 = 0 (number, integer)
          [ 0 ] 0 = 0 (number, integer)
        [ <= ] (ID0.SG2@20-M21)<=1.25 = 0 (number, integer)
          [ - ] (ID0.SG2@20-M21) = 1.5 (number, double)
            [ ID0.SG2@20 ] C20 = 2724.25 (number, double)
            [ M21 ] M21 = 2722.75 (number, double)
          [ 1.25 ] 1.25 = 1.25 (number, double)
    [ 0 ] 0 = (not evaluated)
    [ IF ] IF(AND(ID0.SG1@20<ID0.SG4@20,N21=0,(C20-M21)>1.... = N21 (reference)
      [ AND ] AND(ID0.SG1@20<ID0.SG4@20,N21=0,(C20-M21)>1.25) = 0 (number, integer)
        [ < ] ID0.SG1@20<ID0.SG4@20 = 0 (number, integer)
          [ ID0.SG1@20 ] B20 = 2723.75 (number, double)
          [ ID0.SG4@20 ] E20 = 2723.75 (number, double)
        [ = ] N21=0 = (not evaluated)
        [ > ] (C20-M21)>1.25 = (not evaluated)
      [ 1 ] 1 = (not evaluated)
      [ IF ] IF(OR(N21=1,AND(L21=0,(K20-ID0.SG3@20)<=1.25)),... = N21 (reference)
        [ OR ] OR(N21=1,AND(L21=0,(K20-ID0.SG3@20)<=1.25)) = 0 (number, integer)
          [ = ] N21=1 = 0 (number, integer)
            [ N21 ] N21 = 0 (number, integer)
            [ 1 ] 1 = 1 (number, integer)
          [ AND ] AND(L21=0,(K20-ID0.SG3@20)<=1.25) = 0 (number, integer)
            [ = ] L21=0 = 0 (number, integer)
              [ L21 ] L21 = 2 (number, integer)
              [ 0 ] 0 = 0 (number, integer)
            [ <= ] (K20-ID0.SG3@20)<=1.25 = (not evaluated)
        [ 2 ] 2 = (not evaluated)
        [ N21 ] N21 = N21 (reference)

The constant truncation value (50 characters) is not convenient for long formulas. It will be much flexible to deduct this value from the Dialog width.

  // Sometimes the full string can be too long, and is usually not really
  // useful, so truncate it if it is longer than a certain length.
  const int MAX_FULL_STRING_LENGTH = 50;
  c_String LimitedFullString = DetailsRootNode.GetFullString();
  if (LimitedFullString.GetLength() > MAX_FULL_STRING_LENGTH)
  {
    LimitedFullString.Truncate(MAX_FULL_STRING_LENGTH - 3);
    LimitedFullString += "...";
  }


As an alternative to show the full (non-truncated) formula, the hint can be used. Placing mouse over the truncated item the hint will popup showing full non-truncated formula.
Date Time Of Last Edit: 2018-07-05 17:04:02