Abstract: The present disclosure is directed to a spreadsheet application with an enhanced understanding of mathematical equations using a mathematical engine and a calculation engine. The disclosed spreadsheet application has many enhanced features, such as, but not limited to: analyzing complex equations, identifying dependencies, converting mathematical notation to spreadsheet notation, connecting variables in an equation to other cells of the spreadsheet, solving or simplifying equations, recommending different display representations of data, and a providing a math display mode.

Abstract: The present disclosure is directed to a spreadsheet application with an enhanced understanding of mathematical equations using a mathematical engine and a calculation engine. The disclosed spreadsheet application has many enhanced features, such as, but not limited to: analyzing complex equations, identifying dependencies, converting mathematical notation to spreadsheet notation, connecting variables in an equation to other cells of the spreadsheet, solving or simplifying equations, recommending different display representations of data, and a providing a math display mode.

Abstract: Simplified data and/or syntax entry in electronic documents is provided. Custom user interface components and selectable controls may be provided that may float on a displayed document and allow for easier data or syntax input. Electronic inking gestures may be used for entry of data and/or programming syntax in an electronic scratch pad and/or directly on top of a displayed electronic document. Gestures (e.g., screen touches) may be used for selecting document components (e.g., spreadsheet ranges) followed by an interpretation by the associated application of the user's gestures. A variety of disambiguation displays, interactions and/or hints may be provided to help a user clarify ambiguous UI selections.

Abstract: The present disclosure is directed to a spreadsheet application with an enhanced understanding of mathematical equations using a mathematical engine and a calculation engine. The disclosed spreadsheet application has many enhanced features, such as, but not limited to: analyzing complex equations, identifying dependencies, converting mathematical notation to spreadsheet notation, connecting variables in an equation to other cells of the spreadsheet, solving or simplifying equations, recommending different display representations of data, and a providing a math display mode.

Abstract: Associating comments with named objects is provided. A document may include a comment attached to a named object (e.g., a chart, a named range, a table, a pivot table, a piece of data in a pivot table, a shape, a picture, a graphic, clip art, an object within an object, etc.). The document may also comprise metadata associated with the comment that may include information such as the named object to which the comment is attached. If the named object is moved, the comment may remain attached to the object and accordingly, may be moved with the object. Attaching a comment to a named object via selecting the comment from a comments pane, dragging, and then dropping the comment onto the named object is also provided.

Abstract: Simplified data and/or syntax entry in electronic documents is provided. Custom user interface components and selectable controls may be provided that may float on a displayed document and allow for easier data or syntax input. Electronic inking gestures may be used for entry of data and/or programming syntax in an electronic scratch pad and/or directly on top of a displayed electronic document. Gestures (e.g., screen touches) may be used for selecting document components (e.g., spreadsheet ranges) followed by an interpretation by the associated application of the user's gestures. A variety of disambiguation displays, interactions and/or hints may be provided to help a user clarify ambiguous UI selections.