Saltar para o conteúdo principal
Version: v19

On After Edit

CodePode ser chamado porDefinição
454D View Pro area - 4D Write Pro area - Combo Box - Form - Input - Hierarchical List - List Box - List Box ColumnO conteúdo do objecto inserível que tem o foco acabou de ser modificado

Descrição

Caso geral

This event can be used filter the data entry in keyboard enterable objects at the lowest level.

When it is used, this event is generated after each change made to the contents of an enterable object, regardless of the action that caused the change, i.e.:

  • Standard editing actions which modify content like paste, cut, delete or cancel;
  • Dropping a value (action similar to paste);
  • Any keyboard entry made by the user; in this case, the On After Edit event is generated after the On Before Keystroke and On After Keystroke events, if they are used.
  • Any modification made using a language command that simulates a user action (i.e., POST KEY).

Within the On After Edit event, text data being entered is returned by the Get edited text command.

4D View Pro

O objecto devolvido pelo comando FORM Event contém:

PropriedadeTipoDescrição
codeinteiro longoOn After Edit
descriptiontext"On After Edit"
objectNametextNome da área 4D View Pro
sheetNametextNome da folha do evento
actiontext"editChange", "valueChanged", "DragDropBlock", "DragFillBlock", "formulaChanged", "clipboardPasted"

Depending on the action property value, the event object will contain additional properties.

action = editChange

PropriedadeTipoDescrição
rangeobjectCell range
editingTextvariantO valor do editor actual

action = valueChanged

PropriedadeTipoDescrição
rangeobjectCell range
oldValuevariantValor da célula antes da alteração
newValuevariantValor da célula após a alteração

action = DragDropBlock

PropriedadeTipoDescrição
fromRangeobjectRange of source cell range (being dragged)
toRangeobjectRange of the destination cell range (drop location)
copybooleanSpecifies if the source range is copied or not
insertbooleanSpecifies if the source range is inserted or not

action = DragFillBlock

PropriedadeTipoDescrição
fillRangeobjectIntervalo utilizado para o preenchimento
autoFillTypelongintValor utilizado para o enchimento.
  • 0: Cells are filled with all data (values, formatting, and formulas)
  • 1: Cells are filled with automatically sequential data
  • 2: Cells are filled with formatting only
  • 3: Cells are filled with values but not formatting
  • 4: Values are removed from the cells
  • 5: Cells are filled automatically
  • action = formulaChanged

    PropriedadeTipoDescrição
    rangeobjectCell range
    formulatextA fórmula introduzida

    action = clipboardPasted

    PropriedadeTipoDescrição
    rangeobjectCell range
    pasteOptioninteiro longoSpecifies what is pasted from the clipboard:
  • 0: Everything is pasted (values, formatting, and formulas)
  • 1: Only values are pasted
  • 2: Only the formatting is pasted
  • 3: Only formulas are pasted
  • 4: Values and formatting are pasted (not formulas)
  • 5: Formulas and formatting are pasted (not values)
  • pasteDataobjectThe data from the clipboard to be pasted
  • "text" (text): The text from the clipboard
  • "html" (text): The HTML from the clipboard
  • Exemplo

    Here is an example handling an On After Edit event:

     If(FORM Event.code=On After Edit)
    If(FORM Event.action="valueChanged")
    ALERT("WARNING: You are currently changing the value\
    from "+String(FORM Event.oldValue)+\
    " to "+String(FORM Event.newValue)+"!")
    End if
    End if
    End if
    End if
    End if
    End if

    The above example could generate an event object like this:

    {

    "code":45;
    "description":"On After Edit";
    "objectName":"ViewProArea"
    "sheetname":"Sheet1";
    "action":"valueChanged";
    "range": {area:ViewProArea,ranges:[{column:1,row:2,sheet:1}]};
    "oldValue":"The quick brown fox";
    "newValue":"jumped over the lazy dog";
    }