Formula editor
First Claim
Patent Images
1. A computer-implemented method for editing a formula, the method comprising:
- receiving a text string including formula information;
while the text string is being received, parsing the received text string and analyzing the parsed text string for global formula errors, localized formula errors, and a formula including formula sub-parts wherein analyzing occurs after a threshold time delay;
in response to detecting a global formula error, generating an indication for the formula including the global formula error, generating a message including a suggested correction for the global formula error, and sending both the indication for the formula and the message including the suggested correction for the global formula error to a display;
in response to detecting a localized formula error, generating an indication for the formula sub-part including the localized formula error, generating a message including a suggested correction for the localized formula error, and sending both the indication for the formula sub-part and the message including the suggested correction for the localized formula error to the display;
in response to detecting a formula sub-part, calculating a sub-value for the formula sub-part, generating a message including the sub-value, and sending the message including the sub-value to the display; and
if neither a global formula error nor a localized formula error is detected, calculating a value for the formula, generating a message including the value, and sending the message including the value to the display.
2 Assignments
0 Petitions
Accused Products
Abstract
A computer-implemented method for editing a formula includes receiving a text string including formula information. The method further includes parsing the received text string and analyzing the parsed text string for a formula and formula errors while the text string is being received. In response to a formula error being detected in the analyzed text string, the method can include generating a message pertaining to the formula error. In response to a formula detected in the analyzed text string, the method can include calculating at least one sub-value for the formula and generating a message pertaining to the at least one sub-value of the formula.
-
Citations
19 Claims
-
1. A computer-implemented method for editing a formula, the method comprising:
-
receiving a text string including formula information; while the text string is being received, parsing the received text string and analyzing the parsed text string for global formula errors, localized formula errors, and a formula including formula sub-parts wherein analyzing occurs after a threshold time delay; in response to detecting a global formula error, generating an indication for the formula including the global formula error, generating a message including a suggested correction for the global formula error, and sending both the indication for the formula and the message including the suggested correction for the global formula error to a display; in response to detecting a localized formula error, generating an indication for the formula sub-part including the localized formula error, generating a message including a suggested correction for the localized formula error, and sending both the indication for the formula sub-part and the message including the suggested correction for the localized formula error to the display; in response to detecting a formula sub-part, calculating a sub-value for the formula sub-part, generating a message including the sub-value, and sending the message including the sub-value to the display; and if neither a global formula error nor a localized formula error is detected, calculating a value for the formula, generating a message including the value, and sending the message including the value to the display. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A computer-implemented method for editing a formula, the method comprising:
-
receiving a text string including formula information; while the text string is being received, parsing the received text string and analyzing the parsed text string for global formula errors, localized formula errors, and a formula including formula sub-parts, wherein analyzing occurs after a threshold time delay for receiving additional formula information; in response to detecting a global formula error that persists beyond the threshold time delay, generating a message including a suggested correction for the global formula error and sending the message including the suggested correction for the global formula error to a display; in response to detecting a localized formula error that persists beyond the threshold time delay, generating a message including a suggested correction for the localized formula error and sending the message including the suggested correction for the localized formula error to the display; in response to detecting a formula sub-part, calculating a sub-value for the formula sub-part, generating a message including the sub-value, and sending the message including the sub-value to the display; and if neither a global formula error nor a localized formula error is detected, calculating a value for the formula, generating a message including the value, and sending the message including the value to the display. - View Dependent Claims (8, 9, 10, 11, 12, 13)
-
-
14. A computer-readable medium having processor-executable program instructions adapted to be executed to implement a method for editing a formula, the method comprising:
-
receiving a text string including formula information; while the text string is being received, parsing the received text string and analyzing the parsed text string for global formula errors, localized formula errors, and a formula including formula sub-parts, wherein analyzing occurs after a threshold time delay for receiving additional formula information; in response to detecting a global formula error that persists beyond the threshold time delay, generating a message including a suggested correction for the global formula error and sending the message including the suggested correction for the global formula error to a display; in response to detecting a localized formula error that persists beyond the threshold time delay, generating a message including a suggested correction for the localized formula error and sending the message including the suggested correction for the localized formula error to the display; in response to detecting a formula sub-part, calculating a sub-value for the formula sub-part, generating a message including the sub-value, and sending the message including the sub-value to the display; and if neither a global formula error nor a localized formula error is detected, calculating a value for the formula, generating a message including the value, and sending the message including the value to the display. - View Dependent Claims (15, 16, 17, 18, 19)
-
Specification