Formula editor
AssigneeGoogle Inc.
InventorsVance J. Vagell, Shoshana Holtzblatt, Varnali Shah
Life of this patent
Estimating the term…
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.
Claims19
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.
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.
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.
Dependencies are inferred from the claim text.