Spreadsheet Log
Table
The following log entries can be posted to the spreadsheet log file.
The fields shown in this table are a subset of the fields that are shown
in the Spreadsheet
Audit Log Viewer. For a description of the other fields, see
Spreadsheet
Audit Log Viewer.
Note that audit logs of spreadsheets are maintained on a per spreadsheet
basis. To track changes to a specific spreadsheet, open the spreadsheet
and from the Tools
– Audit Trail submenu, select
Settings.
The Spreadsheet
Audit Log Settings dialog box will be displayed, and you can
enable logging for the spreadsheet.
Use this table to review the specific information recorded in the log
entry for each spreadsheet operation. If a field is empty, no information
is stored in the field for that particular operation.
Operation |
CATEGORY |
ACTION |
MISC |
FC |
FV |
LC |
LV |
OLD |
NEW |
File
Create |
Document |
Create |
|
|
|
|
|
|
|
Import Excel, SPSS, Text, SAS, etc. |
Document |
Import |
File
name of imported file |
|
|
|
|
|
|
Truncate
Log |
Document |
Log Truncated |
|
|
|
|
|
|
|
Enable/Disable
Logging |
Document |
Logging
Enable |
|
|
|
|
|
true/false |
true/false |
Enable/Disable
Prompting for comments |
Document |
Reason
Prompting Enable |
|
|
|
|
|
true/false |
true/false |
Undo |
Document |
Undo |
Undo
Action Name |
|
|
|
|
|
|
Redo |
Document |
Redo |
Redo
Action Name |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Change
single cell value |
Data |
Change
Cell |
|
R |
R |
R |
R |
old value |
new value |
Paste
single cell |
Data |
Change
Cell |
|
R |
R |
R |
R |
old value |
new value |
Cut/Clear
a block of cells |
Data |
Clear
Block |
|
R |
R |
R |
R |
|
|
Modify
a block of data (e.g. SetCase) |
Data |
Modify
Block |
|
R |
R |
R |
R |
|
|
|
|
|
|
|
|
|
|
|
|
Paste
Block of cells |
Data |
Paste |
|
R |
R |
R |
R |
|
|
Fill
Random |
Data |
Fill
Random |
|
R |
R |
R |
R |
|
|
Fill
Down |
Data |
Fill
Down |
|
R |
R |
R |
R |
|
|
Fill
Right |
Data |
Fill
Right |
|
R |
R |
R |
R |
|
|
Standardize
Columns/Rows |
Data |
Standardize
Columns [Rows] |
|
R |
R |
R |
R |
|
|
Transpose
Block/File |
Data |
Transpose |
|
R |
R |
R |
R |
|
|
|
|
|
|
|
|
|
|
|
|
Change
Case Name |
Case
Specs |
Change
Case Name |
|
R |
|
R |
|
old value |
new value |
Change
Case Name Length |
Case
Specs |
Change
Case Name Length |
|
|
|
|
|
old value |
new value |
Copy
Case Names From Var |
Case
Specs |
Change
Case Name |
Copy
from var # |
R |
|
R |
|
|
|
Copy
Case Names To Var |
Data |
Modify
Block |
Copy
From Case Names |
R |
R |
R |
R |
|
|
Change
Case States |
Case
Specs |
Change
Case States |
|
R |
|
R |
|
old value |
new value |
Copy
Case States To Var |
Data |
Modify
Block |
Copy
from Case States |
R |
R |
R |
R |
|
|
Copy
Case States To Var |
Case
Specs |
Change
Case States |
Copy
from Var |
|
R |
|
R |
|
|
Color/Mark
By Var |
Case
Specs |
Color/Mark
By Category |
|
R |
R |
R |
R |
|
|
Color/Mark
case state variable by var |
Data |
Color/Mark
By Category |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Change
Info Box |
Headers |
Change
Info Box |
|
|
|
|
|
old value |
new value |
Change
Header |
Headers |
Change
Header |
|
|
|
|
|
old value |
new value |
|
|
|
|
|
|
|
|
|
|
Change
Var Name |
Var Specs |
Change
Var Name |
|
|
R |
|
R |
old value |
new value |
Change
Var Type |
Var Specs |
Change
Var Type |
|
|
R |
|
R |
old type
|
new type |
Change
Var Length |
Var Specs |
Change
Var Length |
|
|
R |
|
R |
old len |
new len |
Change
MD Code |
Var Specs |
Change
MD Code |
|
|
R |
|
R |
old value |
new value |
Change
Long Name |
Var Specs |
Change
Long Name |
|
|
R |
|
R |
old value |
new value |
Change
text labels |
Var Specs |
Change
Text Labels |
|
|
R |
|
R |
|
|
|
|
|
|
|
|
|
|
|
|
Add Cases |
Structure |
Add Cases |
|
R |
|
R |
|
|
|
Delete
Cases |
Structure |
Delete
Cases |
|
R |
|
R |
|
|
|
Copy
Cases |
Structure |
Copy
Cases |
Copied
N cases after case # |
R |
|
R |
|
|
|
Move
Cases |
Structure |
Move
Cases |
Moved
N Cases after case # |
R |
|
R |
|
|
|
|
|
|
|
|
|
|
|
|
|
Add Vars |
Structure |
Add Vars |
|
|
R |
|
R |
|
|
Delete
Vars |
Structure |
Delete
Vars |
|
|
R |
|
R |
|
|
Copy
Vars |
Structure |
Copy
Vars |
Copied
N Vars after var # |
|
R |
|
R |
|
|
Move
Vars |
Structure |
Move
Vars |
Moved
N vars after var # |
|
R |
|
R |
|
|
|
|
|
|
|
|
|
|
|
|
Change
Selection Conditions |
Case
Selection |
Change
Selection Conditions |
|
|
|
|
|
true/false |
true/false |
Change
Case Weights |
Case
Weight |
Change
Case Weights |
|
|
R |
|
|
true/false |
true/false |
|
|
|
|
|
|
|
|
|
|
Change
Locking |
Document |
Change
Locking |
|
|
|
|
|
old flags
value |
new flags
value |
Change
Event Autorun |
Document |
Change
Events Autorun |
|
|
|
|
|
true/false |
true/false |
Edit
Event Code |
Document |
Edit
Event Code |
|
|
|
|
|
|
|
Change/Set
Event Password |
Document |
Set Events
Password |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Merge
Concatenate |
Data |
Merge
Variables Concatenate |
2nd file |
|
|
|
|
|
|
Merge
Cartesian |
Data |
Merge
Variables Cartesian |
2nd file
|
|
|
|
|
|
|
Merge
Variables Matching |
Data |
Merge
Variables Matching |
2nd file |
|
|
|
|
|
|
Merge
Text Labels |
Data |
Merge
Text Labels |
2nd file |
|
|
|
|
|
|
Merge
Cases |
Data |
Merge
Cases |
2nd file |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sort |
Data |
Sort |
Sort
keys+orders |
R |
|
R |
|
|
|
Batch
Transform |
Data |
Batch
Transform |
the formulas |
|
|
|
|
|
|
Recalculate |
Data |
Recalculate
Formulas |
|
R |
R |
R |
R |
|
|
Rank |
Data |
Rank |
|
|
R |
|
R |
|
|
Recode |
Data |
Recode |
|
R |
R |
R |
R |
|
|
Replace
MD |
Data |
Replace
MD |
|
|
R |
|
R |
|
|
Shift |
Data |
Shift |
|
|
R |
|
R |
|
|
Standardize |
Data |
Standardize |
|
|
R |
|
R |
|
|
Date
Operations - numeric |
Data |
Numeric
Date Conversion |
describe
op |
|
|
|
|
|
|
Date
Operations - text |
Data |
Text
Date Conversion |
describe
op |
|
src |
|
dest |
|
|