asked on

About FarPoint's Spread Clipboard

Hi,

I want to know if it's possible to clip the datacell just before the user makes a change in a vaSpread control... something like BeforeChangeDataCell( ). Because, I'm trying give the possibility to the user to cancel is modification without makes an SQL Query.

thanks.

Mikal613

Private Sub Form_Load()
Command1.Caption = "Copy"
Command2.Caption = "Cut"
Command3.Caption = "Paste"
End Sub

Private Sub Command1_Click()
fpSpread1.ClipboardCopy
fpSpread1.ClearSelection
End Sub

Private Sub Command2_Click()
fpSpread1.ClipboardCut
fpSpread1.ClearSelection
End Sub

Private Sub Command3_Click()
fpSpread2.ClipboardPaste
End Sub

try doing it in user change

PapaOne

ASKER

hmmm... I was not clear! I'm trying againt.

Okay, we got a spread's grid and one button on a form. The button give the possibility to the user to retrieve the old value who was in the cell before the modification (i.e. cancel the modification).

Example: When the user push the "Escape key" to void his modificaitions in the cell, the cell retreive is old value.
All I want is catch this cell value.

Is that possible to tell to the spread to catch the cell value just before the user makes change (automatically)?

thks!

ASKER CERTIFIED SOLUTION

Mikal613

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mikal613

or try this
Private Sub Spread_EnterRow(ByVal Row As Long, ByVal RowIsLast As Long)

End Sub

PapaOne

ASKER

or I try this,

when the user click on the cell, the cell value will be copied in the celltag! And if the user need the old value, he just have to bring back the value of the celltag.

that it!

so thks for all!