Cell Justify in Edit Mode

Last post 11-02-2007 1:43 AM by C1_GaryB. 1 replies.

Page 1 of 1 (2 items)
	Sort Posts: Previous Next

10-15-2007 12:51 PM

ScottW
Joined on 10-15-2007
Posts 1

Cell Justify in Edit Mode

Reply Contact

When using the OLEDB/Unicode Grid version 7.0.1.203, there seems to be an odd problem with edit mode justification. On one computer, when the ColDataType is set to something like Currency or Date, the value in the field displays the data right-justified. When editing, the cursor and data is always at the left. This is what I would expect. However, on some computers, I am seeing that this holds true only if the cell is blank. When there is already a value and you start to edit, the cursor and text stays on the right side of the cell. Why would this happen on only some computers? Is there some Windows setting that affects this? I think editing should always be done on the left side of the cell. I saw these differences on all Windows XP SP-2 machines. All normal US/English settings, and all with the grid version mentioned above. Is there a fix for this?

I can easily duplicate this with a test app using this version of the grid on a form with this:

Private Sub Form_Load()
    With Grid
        .Editable = flexEDKbdMouse
        .ColDataType(1) = flexDTBoolean
        .ColDataType(2) = flexDTCurrency
        .ColDataType(3) = flexDTDate
        .ColDataType(4) = flexDTString
        .ColDataType(5) = flexDTLong
        .ColDataType(6) = flexDTVariant
    End With
End Sub

Editing column 2 and 3 will recreate this behavior when there is already a value saved in the cell.

Filed under: flexgrid pro, Text direction cell, VSFlexGrid

11-02-2007 1:43 AM In reply to

C1_GaryB
Joined on 03-03-2006
Posts 324

Re: Cell Justify in Edit Mode

Reply Contact

Hi Scott,

This is not a problem with the grid as you can see the exact behavior in both version 8 and also with MS-Excel. To understand this better, please try using a calculator and you will find the digit keeps on increasing from Right justified. This is applicable for Currency, Date, Long, Variant, Integer etc - whereever there is some digit involved. However if you are using any String format the alignment will change automatically to Left Justified (as some alphabet is being used and our system by default is Left-To-Right).

Let me know if you still have any further questions on it.

Regards,

Gary.

<ScottW> wrote in message news:199030@10.0.1.98...

When using the OLEDB/Unicode Grid version 7.0.1.203, there seems to be an odd problem with edit mode justification. On one computer, when the ColDataType is set to something like Currency or Date, the value in the field displays the data right-justified. When editing, the cursor and data is always at the left. This is what I would expect. However, on some computers, I am seeing that this holds true only if the cell is blank. When there is already a value and you start to edit, the cursor and text stays on the right side of the cell. Why would this happen on only some computers? Is there some Windows setting that affects this? I think editing should always be done on the left side of the cell. I saw these differences on all Windows XP SP-2 machines. All normal US/English settings, and all with the grid version mentioned above. Is there a fix for this?

I can easily duplicate this with a test app using this version of the grid on a form with this:

Private Sub Form_Load()
    With Grid
        .Editable = flexEDKbdMouse
        ..ColDataType(1) = flexDTBoolean
        ..ColDataType(2) = flexDTCurrency
        ..ColDataType(3) = flexDTDate
        ..ColDataType(4) = flexDTString
        ..ColDataType(5) = flexDTLong
        ..ColDataType(6) = flexDTVariant
    End With
End Sub

Editing column 2 and 3 will recreate this behavior when there is already a value saved in the cell.

http://helpcentral.componentone.com/cs/forums/p/73319/199030.aspx#199030

Page 1 of 1 (2 items)

C1 Community