Grid - Registered Users - Helpdesk
decimalseparator problem
Thread Starter: Rob van Tour Started: 5/25/2008 8:37 AM UTC
Replies: 3
5/25/2008 8:37 AM UTC
decimalseparator problem
Reply Quote

Rob van Tour

windows decimalseparator =   ,   komma

delphi separator set as :  decimalseparator :='.'     dot

if input in cell  =1/2 then output 0.5  that is OK

if input in cell 0.5 then the result is 5

How can this problem be solved

 

 

 

 



 
6/24/2008 12:37 PM UTC
Re: decimalseparator problem
Reply Quote

profgrid.com

Hello Rob,

This specific problem appears on Dutch locale.

Try to patch the procedure DoVarCast as follows.

Lines 4361 thru 4365 (ProfGrid.pas version 3.4.4.8), which are currently
------
   if TryStrToFloat(WS, D) then
   begin
     Dest := vargDest;
     Exit
   end;
------
should be changed to
------
   if TryStrToFloat(WS, D) then
   begin
     if D <> vargDest then
       Dest := D
     else
       Dest := vargDest;
     Exit
   end;
------


-Nicholas
6/30/2008 5:53 AM UTC
Re: decimalseparator problem
Reply Quote

Rob van Tour

Hi Nicholas,

Will this also be fixed in version 3.4.4.9. ( including the rounding problem).

In that case I wait for the new version.

Ronald



 
7/3/2008 12:39 PM UTC
Re: decimalseparator problem
Reply Quote

profgrid.com

Will this also be fixed in version 3.4.4.9.

Yes.


-Nicholas