Support Board
Date/Time: Mon, 20 Jan 2025 20:44:40 +0000
Post From: Spreadsheet errors
[2018-07-03 21:26:32] |
VladimirP - Posts: 647 |
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
|