Spreadsheet fields in text
A system architecture integrates spreadsheet functionality into text. The architecture allows insertion of discrete individual fields, referred to as “free floating fields”, inline with normal textual sentences. The free floating fields offer spreadsheet functionality, including the ability to handle complex formulas, reference values in a separate free floating field or table, and automatically recalculate the formulas when a source value changes. The values and formula results can also be formatted (e.g., numbers, date, times, currency, etc.), like a spreadsheet, while remaining part of the normal text of a document. The architecture also has a spreadsheet functionality manager to manage the spreadsheet functions for the free floating fields, such as recalculation, formula handling, sorting, referencing, and the like.
1. A computer-implemented method comprising:
presenting a free floating field in line with text in a document, the free floating field containing content derived from a source, wherein a format applied to the text is automatically applied to the content within the free floating field;
changing, upon selection the free floating field, an appearance of the free floating field from an appearance of the text in the document to an appearance of a spreadsheet;
determining, upon selection of the free floating field, a type of content in the free floating field;
entering content to the free floating field, wherein entering the content utilizes a formula edit box initially which initially defaults to a size and shape of the free floating field, but which dynamically resizes, as needed, as data is added;
interpreting a type of the entered content based upon the determination of the type of the content already in the free floating field, wherein the interpreting comprises interpreting user entry as applicable to spreadsheet functions, if the type of content is a formula or non-text data and interpreting the user entry as applicable to word processing functions, if the type of the content is not a formula or non-text data;
updating the content in the free floating field automatically upon modification of the source; and
creating a second free floating field partly in response to user selection of at least a portion of the text of the document, wherein the second free floating field is configured to contain the selected portion of the text.
2. The computer-implemented method of claim 1 , wherein presenting the free floating field comprises providing text-based content from the source.
3. The computer-implemented method of claim 1 , wherein presenting the free floating field comprises providing numeric-based content from the source.
4. The computer-implemented method of claim 1 , wherein the presenting comprises presenting a document written in a mark-up language.
5. The computer-implemented method of claim 1 , wherein entering content into the free floating field comprises entering some combination of text, numerals or a formula.
6. The computer-implemented method of claim 1 , wherein the resizing the formula edit box comprises resizing the formula edit box as the user enters data comprising text or numerals.
7. The computer-implemented method of claim 1 , additionally comprising dynamically resizing the formula edit box by extending the formula edit box horizontally, followed by subsequently extending the formula edit box vertically.
8. The computer-implemented method of claim 1 , additionally comprising overlaying the formula edit box on the free floating field to facilitate user entry of a formula.
9. The computer-implemented method of claim 1 , additionally comprising nesting the free floating field within a cell of a table defined within the document.
10. The computer-implemented method of claim 1 , additionally comprising referencing a cell in a table with the free floating field.
11. The computer-implemented method of claim 1 , additionally comprising nesting the free floating field within a first cell of a table in the document and referencing a second cell in the table with the free floating field.
12. The computer-implemented method of claim 1 , additionally comprising constructing a table within the document, wherein the free floating field and the second free floating fields contain one or more references to contents in the table.
13. The computer-implemented method of claim 1 , wherein the source includes one or more cells of a table in the document.
14. The computer-implemented method of claim 1 , additionally comprising, upon modification of the text in the second free floating field, automatically updating the free floating field.
15. The computer-implemented method of claim 1 , additionally comprising constructing multiple free floating fields within the document, wherein at least one free floating field contains a reference to contents in another free floating field.
16. The computer-implemented method of claim 1 , additionally comprising formatting numbers within the free floating field independently from text formatted in the free floating field.
17. The computer-implemented method of claim 1 , additionally is comprising tracking references made between a table in the document and the free floating field.
18. The computer-implemented method of claim 1 , additionally comprising:
referencing, by the second free floating field, the content the free floating field; and
automatically updating the second free floating field upon alteration of the contents of the free floating field.
19. The computer-implemented method of claim 1 , additionally comprising:
presenting a table in the document; and
referencing a cell in the table to add a data value to a formula within the free floating field.
20. The computer-implemented method of claim 1 , additionally comprising:
enabling a user to select a control function to modify or evaluate an aspect of the document; and
applying the control function across both text within a table and the free floating field.