# US 2025/0094699 A1 · Methods and systems for spreadsheet function and flex copy paste control of formatting and use of selection list panels > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 2025/0094699 A1 - Document ID: US20250094699A1 - Status: Published application - Kind: A1 - Application number: 18/967,076 - Filed: 2024-12-03 - Published: 2025-03-20 - Earliest claimed: 2022-05-02 - Assignees: Adaptam Inc. - Applicants: Adaptam Inc. - Inventors: Robert E. Dvorak; Yuriy Garin; Alexey Verkhovskiy - Web page: https://patentgrep.com/patent/US20250094699A1 ## CPC - G06F 40/18: of spreadsheets (form-filling G06F40/174) - G06F 40/103: Formatting, i.e. changing of presentation of documents (automatic justification G06F40/189; automatic line break hyphenation G06F40/191) - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract Disclosed is a method giving an alternative to typing, cell selecting, single list selecting and pasting in arguments for a built-in spreadsheet function and flex copy paste capabilities through the use of a broad spectrum of selection list panels supporting multiple selections from multiple lists with fixed and/or situationally specific specification options. Those and other arguments can be invisible in the spreadsheet formula text while more understandably visible in UIs. Also disclosed is function and flex copy-paste control of cell formatting overriding any cell formatting otherwise applied to those cells employing a broad spectrum of specification types and selection list panels not previously utilized for spreadsheet functions or copy paste. ## Claims ### Claim 1 As an alternative to formatting cells, when the cells are populated by a spreadsheet flex copy-paste, a method applying formatting as an argument of the spreadsheet flex copy-paste including: receiving a first signal from a user invoking a selection list panel, in a context of a user-specified spreadsheet flex copy-paste that populates a plurality of cells in a spreadsheet range with flex copy-paste results; responsive to the first signal, causing display of the selection list panel that includes a list of specifications appropriate to the context that are useable with the spreadsheet flex copy-paste, wherein a plurality of first specifications in the list are formatting specifications that configure the formatting of output of a plurality of cells in a spreadsheet flex copy-paste range and override cell formatting otherwise applied to the spreadsheet flex copy-paste range; and receiving at least one second signal from the user selecting at least one of the formatting specifications, and configuring the formatting of the output from the spreadsheet flex copy-paste accordingly when the spreadsheet flex copy-paste is committed to the spreadsheet cells. ### Claim 2 (depends on 1) The method of claim 1, wherein when a change in cells populated by the spreadsheet flex copy-paste expands the formatted range, that expanded range overrides the cell formatting otherwise applied to the spreadsheet range. ### Claim 3 (depends on 1) The method of claim 1, wherein when a change in cells populated by the spreadsheet flex copy-paste contracts the formatted range, the spreadsheet flex copy-paste formatted cells no longer occupied by the spreadsheet flex copy-paste revert to the cell formatting otherwise applied to those cells or the default formatting. ### Claim 4 (depends on 1) The method of claim 1, wherein the user selected formatting specification is non-conditional cell formatting. ### Claim 5 (depends on 1) The method of claim 1, wherein the user selected formatting specification is conditional formatting. ### Claim 6 (depends on 1) The method of claim 1, wherein the selected formatting specification is populated as argument text in an argument list of a spreadsheet formula in the spreadsheet cell. ### Claim 7 (depends on 1) The method of claim 1, wherein at least some of the formatting specifications are visible in the selection list panel and not visible as argument text in an argument list of a spreadsheet formula in the spreadsheet cell. ### Claim 8 (depends on 1) The method of claim 1, further including the selection list panel displaying corresponding selected configuration descriptions aligned with at least some of the specifications in the list of specifications. ### Claim 9 (depends on 1) The method of claim 1, further including, in the selection list panel, multiple separate lists with multiple value selections, wherein the multiple lists present the multiple value selections for respective ones of the formatting specifications. ### Claim 10 (depends on 1) The method of claim 1, further including in the selection list panel a first list of specification topics, each of which is accompanied by a second list of specifications applicable to the specification topics in the first list. ### Claim 11 (depends on 1) The method of claim 1, further including in the selection list panel a first list of specifications, each of which is accompanied by a second cascading list, that is selectable using a control, that presents specification alternatives applicable to specifications in the first list. ### Claim 12 (depends on 1) The method of claim 1, wherein a user selectable selection list panel button is positioned adjacent to a formula bar of the spreadsheet. ### Claim 13 (depends on 1) The method of claim 1, wherein a user selectable selection list panel button becomes visible when a spreadsheet cell that holds a spreadsheet flex copy-paste is selected. ### Claim 14 (depends on 1) The method of claim 1, further including receiving a normal user application of cell formatting to all the cells within a target range of a spreadsheet flex copy-paste and then automatically converting the cell formatting to control of the spreadsheet flex copy-paste. ### Claim 15 (depends on 1) The method of claim 1, further including receiving a normal user application of cell formatting to a subset of cells within the spreadsheet flex copy-paste range and then automatically propagating the normal user application of the cell formatting for that subset of cells to control the formatting of the spreadsheet flex copy-paste range. ### Claim 16 (depends on 15) The method of claim 15, wherein the automatically converting extends the user-applied cell formatting throughout all the cells in the spreadsheet copy-paste target range. ### Claim 17 (depends on 16) The method of claim 16, wherein the extension of user-applied cell formatting throughout all the cells in the spreadsheet copy-paste target range can be reverted using a ribbon action or shortcut. ### Claim 18 A non-transitory computer readable medium holding program instructions that, when executed on a processor as an alternative to formatting cells, when the cells are populated by a spreadsheet flex copy-paste, a method applying formatting as an argument of the spreadsheet flex copy-paste including: receiving a first signal from a user invoking a selection list panel, in a context of a user-specified spreadsheet flex copy-paste that populates a plurality of cells in a spreadsheet range with flex copy-paste results; responsive to the first signal, causing display of the selection list panel that includes a list of specifications appropriate to the context that are useable with the spreadsheet flex copy-paste, wherein a plurality of first specifications in the list are formatting specifications that configure the formatting of output of a plurality of cells in a spreadsheet flex copy-paste range and override cell formatting otherwise applied to the spreadsheet flex copy-paste range; and receiving at least one second signal from the user selecting at least one of the formatting specifications, and configuring the formatting of the output from the spreadsheet flex copy-paste accordingly when the spreadsheet flex copy-paste is committed to the spreadsheet cells. ### Claim 19 (depends on 18) The non-transitory computer readable medium of claim 18, wherein when a change in cells populated by the spreadsheet flex copy-paste expands the formatted range, that expanded range overrides the cell formatting otherwise applied to the spreadsheet range. ### Claim 20 (depends on 18) The non-transitory computer readable medium of claim 18, wherein when a change in cells populated by the spreadsheet flex copy-paste contracts the formatted range, the spreadsheet flex copy-paste formatted cells no longer occupied by the spreadsheet flex copy-paste revert to the cell formatting otherwise applied to those cells or the default formatting. ### Claim 21 (depends on 18) The non-transitory computer readable medium of claim 18, wherein at least some of the formatting specifications are visible in the selection list panel and not visible as argument text in an argument list of a spreadsheet formula in the spreadsheet cell. ### Claim 22 A computer-implemented system including at least one processor and memory coupled to the processor, the memory holding program instructions that as an alternative to formatting cells, when the cells are populated by a spreadsheet flex copy-paste, a method applying formatting as an argument of the spreadsheet flex copy-paste including: receiving a first signal from a user invoking a selection list panel, in a context of a user-specified spreadsheet flex copy-paste that populates a plurality of cells in a spreadsheet range with flex copy-paste results; responsive to the first signal, causing display of the selection list panel that includes a list of specifications appropriate to the context that are useable with the spreadsheet flex copy-paste, wherein a plurality of first specifications in the list are formatting specifications that configure the formatting of output of a plurality of cells in a spreadsheet flex copy-paste range and override cell formatting otherwise applied to the spreadsheet flex copy-paste range; and receiving at least one second signal from the user selecting at least one of the formatting specifications, and configuring the formatting of the output from the spreadsheet flex copy-paste accordingly when the spreadsheet flex copy-paste is committed to the spreadsheet cells. ### Claim 23 (depends on 22) The system of claim 22, wherein when a change in cells populated by the spreadsheet flex copy-paste expands the formatted range, that expanded range overrides the cell formatting otherwise applied to the spreadsheet range. ### Claim 24 (depends on 22) The system of claim 22, wherein when a change in cells populated by the spreadsheet flex copy-paste contracts the formatted range, the spreadsheet flex copy-paste formatted cells no longer occupied by the spreadsheet flex copy-paste revert to the cell formatting otherwise applied to those cells or the default formatting. ### Claim 25 (depends on 22) The system of claim 22, wherein at least some of the formatting specifications are visible in the selection list panel and not visible as argument text in an argument list of a spreadsheet formula in the spreadsheet cell.