IP Library Granted Patent US 12,045,171
Granted Patent B2
US 12,045,171 · App. 16/831,949 · Granted Jul 23, 2024

Method and system of copying data to a clipboard

Inventors: Timothy Michael Stewart (Poestenkill, NY); Hemant Sharma (East Greenbush, NY); Jason Michael Winkler (Schenectady, NY); Eric Compton Stolzenbach (Nassau, NY)
Assignee: DATTO, INC.
G06F12/0875G06F3/0482G06F9/541H04N1/00408G06F2212/608
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 12,045,171
App. No.
16/831,949
Granted
Jul 23, 2024
Kind
B2
Abstract

Disclosed is a method and system method for bulk copying data from a cell grid to a workspace memory, such as a clipboard. According to an exemplary embodiment of this disclosure, the method includes displaying, in a user interface, a plurality of cell rows and a plurality of cell columns arranged in a grid form, a user selecting a plurality of rows of cell entries by selecting a respective selector indicator of all rows to be copied, the selected plurality of rows including a subset of a total number of rows displayed and a noncontinuous group of sequential rows where at least one nonselected row is located and displayed between two selected rows; and displaying, in the user interface, a drop-down menu including a plurality of user selectable options, the user selectable options including a user selectable command to copy the plurality of selected rows and a common predetermined subset of the associated column entries to a workspace memory such as a clipboard.

Claims (25)

1. An application user interface operatively associated with a computer device for bulk copying data from a cell grid to a workspace memory, the application user interface configured to perform a processor implemented method comprising:

displaying, in a user interface, a plurality of cell rows and a plurality of cell columns arranged in a grid form, the first row of cells including a plurality of cell column headings and each other row of cells including a common column row selector indicator cell and one or more other cells associated with one or more of the plurality of column headings, and a number of the plurality of cell columns each including a respective column selector indicator cell associated therewith;

a user, via the user interface, selecting a plurality of rows of cell entries by selecting a respective selector indicator of all rows to be copied, the selected plurality of rows including a subset of a total number of rows displayed and a noncontinuous group of sequential rows where at least one nonselected row is located and displayed between two selected rows and selecting a plurality of columns by selecting a respective column selector indicator of all columns to be copied, the selected plurality of columns including a subset of a total number of columns displayed and a noncontinuous group of sequential columns where at least one nonselected column is located and displayed between two selected columns; and

displaying in the user interface a drop-down menu including a plurality of user selectable options, the user selectable options including a user selectable command to copy the plurality of selected rows and the associated plurality of selected column entries to a workspace memory, the workspace memory configured to enable the user to copy the plurality of selected rows and the associated plurality of selected column entries into one or more of an application, a user file, an API (Application Programming Interface) and a program file.

2. The application user interface operatively associated with a computer device for bulk copying data from a cell grid to a workspace memory according to claim 1 , wherein the user selectable options include one or more of copy to clipboard, copy to archive, copy to chat message, and copy to document.

3. The application user interface operatively associated with a computer device for bulk copying data from a cell grid to a workspace memory according to claim 1 , wherein the method is operatively associated with a web-based system and the user interface is accessible via a web browser.

4. The application user interface operatively associated with a computer device for bulk copying data from a cell grid to a workspace memory according to claim 1 , wherein the plurality of cell rows are associated with a plurality of service ticket entries, and each service ticket entry including a row of cells including a common column entry ordered row selector indicator cell and one or more other column entry cells including a service ticket number, a company associated with the service ticket number, company contact, contact title, contract name and queue associated with the service ticket number.

5. The application user interface operatively associated with a computer device for bulk copying data from a cell grid to a workspace memory according to claim 1 , wherein the cell grid is one of a data table, a spreadsheet, a data form, and a data template.

6. The application user interface operatively associated with a computer device for bulk copying data from a cell grid to a workspace memory according to claim 1 , wherein the user selectable options include a plurality of copy to the workspace memory command options, the options associated with a plurality of unique subsets of the associated column entries.

7. A processor implemented method for bulk copying data from a cell grid to a clipboard, the method comprising:

a) displaying, in a user interface, a plurality of service ticket entries in the cell grid, the cell grid including a plurality of cell rows and plurality of cell columns arranged in a grid form, the first row of cells including a plurality of cell column headings and each other row of cells associated with a service ticket entry including a row of cells including a common column row selector indicator cell and one or more other cells associated with one or more of the plurality of column headings including a service ticket number, a company associated with the service ticket number, company contact, contact title, contract name and queue associated with the service ticket number, a number of the plurality of cell columns each including a respective column selector indicator cell associated therewith;

b) a user, via the user interface, selecting a plurality of rows of service ticket entries by selecting a respective selector indicator of all rows of service ticket entries to be copied, the selected plurality of rows including a subset of a total number of rows displayed and a noncontinuous group of sequential rows where at least one nonselected row is located and displayed between two selected rows and selecting a plurality of columns by selecting a respective column selector indicator of all columns to be copied, the selected plurality of columns including a subset of a total number of columns displayed and a noncontinuous group of sequential columns where at least one nonselected column is located and displayed between two selected columns; and

c) displaying, in the user interface, a drop-down menu including a plurality of user selectable options, the user selectable options including a user selectable command to copy the plurality of selected ticket numbers and of the associated plurality of selected column entries to a clipboard associated with a neutral storage space, the clipboard configured to enable the user to copy the plurality of selected ticket numbers and the associated plurality of selected column entries into one or more of an application, an API (Application Programming Interface), a user file and a program file.

8. The processor implemented method for bulk copying data from a cell grid to a clipboard according to claim 7 , wherein the user selectable options include one or more of copy to clipboard, copy to archive, copy to chat message, and copy to document.

9. The processor implemented method for bulk copying data from a cell grid to a clipboard according to claim 7 , wherein the method is operatively associated with a web-based system and the user interface is accessible via a web browser.

10. The processor implemented method for bulk copying data from a cell grid to a clipboard according to claim 7 , wherein the cell grid is one of a data table, a spreadsheet, a data form, and a data template.

11. The processor implemented method for bulk copying data from a cell grid to a clipboard according to claim 7 , wherein the user selectable options include a plurality of copy to the clipboard command options, the options associated with a plurality of unique subsets of the associated column entries.

12. A PSA (Professional Services Automation module) operatively associated with a computer device for bulk copying data from a cell grid to a clipboard, the PSA configured to perform a processor implemented method comprising:

a) displaying, in a user interface, a plurality of service ticket entries in the cell grid, the cell grid including a plurality of cell rows and plurality of cell columns arranged in a grid form, the first row of cells including a plurality of cell column headings and each other row associated with a service ticket entry including a row of cells including a common column row selector indicator cell and one or more other cells associated with one or more of the plurality of column headings including a service ticket number, a company associated with the service ticket number, company contact, contact title, contract name and queue associated with the service ticket number, and a number of the plurality of cell columns each including a respective column selector indicator cell associated therewith;

b) a user, via the user interface, selecting a plurality of rows of service ticket entries by selecting a respective selector indicator of all rows of service ticket entries to be copied, the selected plurality of rows including a subset of a total number of rows displayed and a noncontinuous group of rows where at least one nonselected row is located and displayed between two selected rows and selecting a plurality of columns by selecting a respective column selector indicator of all columns to be copied, the selected plurality of columns including a subset of a total number of columns displayed and a noncontinuous group of sequential columns where at least one nonselected column is located and displayed between two selected columns; and

c) displaying, in the user interface, a drop-down menu including a plurality of user selectable options, the user selectable options including a user selectable command to copy the plurality of selected ticket numbers and of the associated plurality of selected column entries to a clipboard associated with a neutral storage space, the clipboard configured to enable the user to copy the plurality of selected ticket numbers and the associated plurality of selected column entries into one or more of an application, an API (Application Programming Interface), a user file and a program file.

13. The PSA module operatively associated with a computer device for bulk copying data from a cell grid to a clipboard according to claim 12 , wherein the user selectable options include one or more of copy to clipboard, copy to archive, copy to chat message, and copy to document.

14. The PSA module operatively associated with a computer device for bulk copying data from a cell grid to a clipboard according to claim 12 , wherein the method is operatively associated with a web-based system and the user interface is accessible via a web browser.

15. The PSA module operatively associated with a computer device for bulk copying data from a cell grid to a clipboard according to claim 12 , wherein the cell grid is one of a data table, a spreadsheet, a data form, and a data template.

16. The PSA module operatively associated with a computer device for bulk copying data from a cell grid to a clipboard according to claim 12 , wherein the user selectable options include a plurality of copy to the clipboard command options, the options associated with a plurality of unique subsets of the associated column entries.

Assignments (6)
SECOND LIEN PATENT SECURITY AGREEMENT Recorded Mar 24, 2025
From: DATTO, LLC
To: MORGAN STANLEY SENIOR FUNDING, INC., AS SECOND LIEN COLLATERAL AGENT
Reel/Frame 070609/0599 →
FIRST LIEN PATENT SECURITY AGREEMENT Recorded Mar 21, 2025
From: DATTO, LLC
To: MORGAN STANLEY SENIOR FUNDING, INC., AS FIRST LIEN COLLATERAL AGENT
Reel/Frame 070586/0681 →
RELEASE OF SECURITY INTEREST (PATENTS) Recorded Mar 20, 2025
From: GOLUB CAPITAL MARKETS LLC, AS COLLATERAL AGENT
To: DATTO, INC.
Reel/Frame 070583/0566 →
CHANGE OF NAME Recorded Oct 27, 2023
From: DATTO, INC.
To: DATTO, LLC
Reel/Frame 065385/0256 →
NOTICE OF GRANT OF SECURITY INTEREST IN PATENTS Recorded Aug 9, 2022
From: DATTO, INC.
To: GOLUB CAPITAL MARKETS LLC, AS COLLATERAL AGENT
Reel/Frame 061129/0839 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 31, 2020
From: STEWART, TIMOTHY MICHAEL; SHARMA, HEMANT; WINKLER, JASON MICHAEL; STOLZENBACH, ERIC COMPTON
To: DATTO, INC.
Reel/Frame 052269/0010 →