Automatic spreadsheet formula output validation

摘要

A spreadsheet validation method may provide a validation input value to an input field of a computer spreadsheet application and identify a calculated result from an output field of the computer spreadsheet application. The result is calculated based on a formula associated with the output field and the formula uses the validation input value as an input. Further, the calculated result may be compared to an expected validation output value.

主权项

1. A method, comprising:
analyzing a formula included in a spreadsheet to select a validation scenario; selecting, in view of a characteristic of the formula included in the spreadsheet, a validation input value that satisfies, for all possible outputs, the selected validation scenario in relation to a conditional statement included in the formula; providing the validation input value to an input field of the spreadsheet, the validation input value being included in the validation scenario comprising an expected validation output value; identifying, by a processing device, a result from an output field of the spreadsheet that is calculated in view of the conditional statement and a formula associated with the output field that uses the validation input value as an input; and comparing the result to the expected validation output value.