• Action Events
  • About Cell Events
  • Activate Working Papers Action
  • Add a Form in CaseView Database Action
  • Add a Group in CaseView Database Action
  • Annotate Action
  • Calculation Explorer Action
  • CaseView Menu
  • Change Document Mode Action
  • Close All Database Browses Action
  • Close Any CaseView Document Action
  • Close CaseView Action
  • Close Client CaseView Document Action
  • Close Database Browse Action
  • Compare Document Action
  • Compare Section Action
  • Delete Column Action
  • Delete Form in CaseView Database Action
  • Delete Group in CaseView Database Action
  • Delete Row Action
  • Enable Rounding Action
  • Event Functions List Action
  • Execute Helper Application Action
  • Execute Script Action
  • Execute URL Action
  • Import Filed Cell Data Action
  • Input Integer Dialog Action
  • Input String Dialog Action
  • Insert Column Action
  • Insert Knowledge Library Link From List Action
  • Insert Link From Knowledge Library Index Action
  • Insert New Knowledge Library Link Action
  • Insert Row Action
  • Insert Section Action
  • Jump to Bookmark Action
  • Jump to Labeled Section Action
  • Knowledge Library (Select Links From List to Insert)
  • Label Browse Action
  • Launch Bookmark Dialog Action
  • Launch CaseView Document by Code Action
  • Launch CaseView Document by File Action
  • Launch CaseView Form by Code Action
  • Launch Caseware Dialog Action
  • Launch Caseware Document Action
  • Launch Cell Group Dialog Action
  • Launch Database Browse Action
  • Launch HTML Dialog Action
  • Launch Issues Pane Action
  • Launch Knowledge Library Index Action
  • Launch Message Box Action
  • Launch Note Number Style Dialog Action
  • Launch Rounding Dialog Action
  • Launch Style Dialog Action
  • Launch XBRL Financial Statement Dialog Action
  • Link Cell Action
  • Load Cell Group by Name Action
  • Load Cell Group File Action
  • Load Note Number Style Sheet Action
  • Load Style Sheets Action
  • Load Styles by Name Action
  • Merge Browses Action
  • Modify Browse Action
  • Modify Browse Filter Action
  • Move to Performance Measures Action
  • Pick File Dialog Action
  • Pick Path Dialog Action
  • Recalculate Action
  • Refresh CaseView Document by Code Action
  • Remove Change Flags Action
  • Remove Custom Property Action
  • Remove Knowledge Library Link Action
  • Round To Action
  • Save Document Action
  • Save Milestone Action
  • Set Cell Calculation Action
  • Set Cell Value Action
  • Set Current Form Action
  • Set Custom Property Action
  • Set Form Filter Action
  • Show Ruler Action
  • Shuffle Table Columns Action
  • Sort Paragraphs Action
  • Sort Sections Action
  • Sort Table Group Action
  • Sort Table Rows Action
  • Update a Knowledge Library Link Action
  • Update All Knowledge Library Links Action
  • Visual Compare to Knowledge Library Action

Set Cell Value Action

Event Function: SetCellValue

The Set Cell Value action enters a specified value in a selected cell.

Using the Events tab

Under	Enter	Example
Run Skip Condition	If desired, enter skip conditions for the event. When the "Run Skip Condition" is evaluated to be true, the action is not performed.
Cell Number	A cell number	cellno(C945)
Value	The new value of the cell	"4530"
Recalculate	A yes or no decision to recalculate the document after this event is run	"1" (for Yes)

Syntax (if entering it in the Equation bar)

ACTION("SetCellValue", expr1, expr2, expr3)

Where

expr1 = entry under Cell Number

expr2 = entry under Value

expr3 = entry under Recalculate

How the example will appear in the Equation bar

ACTION("SetCellValue", cellno(C945), "4530","1")

NOTE: The Set Cell Value action treats the Value as a string of text rather than as an integer. To set the value of the selected cell as an integer, use the MKINT function.

Related Topics

• Event Functions list