Topic: weird behavior
In a project made with MVD 6.1, I see strange behavior. (See illustration in attachment).
The column concerned is the result of a calculated field (Type Currency).
For certain values, the display is correct (ie 10113.58), for others there are too many digits after the decimal places (ie 96931.229999999).
I had the same display problem but in a report. A tip from Derek had saved my day and fixed the problem.
This time it doesn't work.
On the other hand, the value of the footer of this column is displayed correctly.
Here is the part of the code that applies to this column:
Recipes := Form1.TableGrid1.Columns[5].Footer.FormulaValue;
Expenses := Form1.TableGrid1.Columns[4].Footer.FormulaValue;
Balance := (Form1.TableGrid1.Columns[6].Footer.FormulaValue)- (Form1.TableGrid1.Columns[5].Footer.FormulaValue);
Form1.Edit1.Text:= FormatFloat('00.00',Balance)+ ' €';
Form1.TableGrid1.Columns[7].Footer.Caption := FormatFloat('00.00',Balance).
Thank you if anyone can resolve this anomaly which must be insignificant.
Thanks in advance.
JB