INTERACTION WITH SPREADSHEET APPLICATION FUNCTION TOKENS

摘要

Interaction with spreadsheet formula/function tokens is provided. Functions and formulas may be tokenized into individual components and/or arguments. Interaction with a token allows for filtering among various mathematical operations/functions. Tokens may be moved together to create, nest or perform operations. Tokens may be moved from a formula/function bar into a spreadsheet grid or canvas to perform an operation. Tokens may be moved off a formula/function bar or edit field to remove the token from a formula or function. Tokens may be interacted with for clearing an associated value in a cell or formula/function bar. Tokens may be toggled between absolute and relative references. Tokens may be zoomed into to show precedents of the token. Tokens may be moved for changing a value of a token. Tokens may be converted from token to editable text and back to token.