Claims:1. A method (400) of populating data in a grid having a plurality of rows and a plurality of columns, the method comprising:
detecting, by a detecting module (210), that at least one column is not visible on a screen;
generating, by a generating module (212), a sliding pane on the screen for each row, wherein the sliding pane comprising a tab for each cell of the row that corresponds to an invisible column;
receiving, by a receiving module (214), a value to be filled in a cell corresponding to the invisible column through the associated tab; and
populating, by a populating module (216), the data in the grid based on the receipt of values in tabs of the sliding pane for each row.

2. The method (400) as claimed in claim 1, comprising:
categorizing, by a categorizing module (218), cells of a row based on relevance of their population, wherein categories of the cells comprising at least one of a mandatory field category and a missing field category; and
generating, by the generating module (212), the sliding pane having a plurality of sub-panes, wherein each sub-pane comprising tabs corresponding to the cells belonging to one category.

3. The method (400) as claimed in claim 2, comprising generating, by the generating module (212), the sliding pane having a sub-pane enlisting tabs corresponding to cells of the row that are to be mandatorily filled, based upon the categorization.

4. A method (500) of populating data in a grid having a plurality of rows and a plurality of columns, the method comprising:
detecting, by a detecting module (210), that at least one row is not visible on a screen;
generating, by a generating module (212), a sliding pane on the screen for each column, wherein the sliding pane comprising a tab for each cell of the column that corresponds to an invisible row;
receiving, by a receiving module (214), a value to be filled in a cell corresponding to the invisible row through the associated tab; and
populating, by a populating module (216), the data in the grid based on the receipt of values in tabs of the sliding pane for each column.

5. A system (200) of populating data in a grid having a plurality of rows and a plurality of columns, the system (200) comprising:
a detecting module (210) adapted to detect that at least one column is not visible on a screen;
a generating module (212) in communication with the detecting module (210) and adapted to generate a sliding pane on the screen for each row, wherein the sliding pane comprising a tab for each cell of the row that corresponds to an invisible column;
a receiving module (214) in communication with the generating module (212) and adapted to receive a value to be filled in a cell corresponding to the invisible column through the associated tab; and
a populating module (216) in communication with the receiving module (214) and adapted to populate the data in the grid based on the receipt of values in tabs of the sliding pane for each row.

6. The system (200) as claimed in claim 5, comprising:
a categorizing module (218) adapted to categorize cells of a row based on relevance of their population, wherein categories of the cells comprising at least one of a mandatory field category and a missing field category; and
the generating module (212) in communication with the categorizing module (218) and adapted to generate the sliding pane having a plurality of sub-panes, wherein each sub-pane comprising tabs corresponding to the cells belonging to one category.

7. The system (200) as claimed in claim 6, comprising the generating module (212) to generate the sliding pane having a sub-pane enlisting tabs corresponding to cells of the row that are to be mandatorily filled, based upon the categorization.

8. The system (200) as claimed in claim 6, comprising the generating module (212) to generate the sliding pane having a sub-pane enlisting tabs corresponding to cells of the row that are missing a value, based upon the categorization.

9. The system (200) as claimed in claim 6, comprising the generating module (212) to generate the sliding pane having a sub-pane enlisting tabs corresponding to cells of the row that are adapted to include classified values, based upon the categorization.

10. A system (200) of populating data in a grid having a plurality of rows and a plurality of columns, the system (200) comprising:
a detecting module (210) adapted to detect that at least one row is not visible on a screen;
a generating module (212) in communication with the detecting module (210) and adapted to generate a sliding pane on the screen for each column, wherein the sliding pane comprising a tab for each cell of the column that corresponds to an invisible row;
a receiving module (214) in communication with the generating module (212) and adapted to receive a value to be filled in a cell corresponding to the invisible row through the associated tab; and
a populating module (216) in communication with the receiving module (214) and adapted to populate the data in the grid based on the receipt of values in tabs of the sliding pane for each column.
, Description:FIELD OF THE INVENTION

The present disclosure relates to population of data in a grid and in particular, relates to systems and methods for populating data in a grid having a plurality of rows and a plurality of columns.

BACKGROUND

It is quite common nowadays to use grids having multiple rows and columns for populating and tracking data. Each cell of such a grid is adapted to receive data for population. Generally, a user is required to manually move to each cell of the grid for filling in the respective content.

Particularly, in case of a grid having a large number of rows or columns or both, some of the rows and columns extend out of the screen of a device, which is being used to populate the grid, for example, a laptop or a mobile phone. Therefore, these cells are not visible and in order to populate content in such cells, the user is required to scroll horizontally or vertically to access the respective cells.

Figure 1 illustrates a User Interface (UI) 100 depicting required scrolling in a grid for populating data in cells, according to an existing technique. As illustrated, in the UI 100, based on the position of a sliding bar 102, it can be determined that there are some columns that are not visible on the UI 100. Therefore, the user has to horizontally scroll, for example, by using the sliding bar 102 to access cells belonging to different columns in a row. For example, in this case, columns 15 and thereon are not visible on the UI 100 and have to be accessed by using the sliding bar 102. Therefore, in such cases, at any point in time, there are some cells that are not visible to the user, which may cause difficulty in populating and tracking the data in the grid.

This issue becomes more prominent when there are some mandatory cells, for example, in a row that must be filled before the user is allowed to move to the subsequent row. For example, in the illustrated example, cells belonging to the columns 3, 4, 6, 8, 10, 11, 12, 13, and 14 are to be mandatorily filled before moving to the subsequent cell. Therefore, the user may have to frequently move back and forth on the grid to completely populate the grid, causing significant inconvenience.

Further, sometimes, the grid may not allow the user to move to the subsequent row or column owing to any cell of the present row being vacant or incorrectly filled. In such cases, the user is required to individually inspect each cell to locate the discrepancy. Owing to the need of frequent scrolling to do so, it becomes difficult for the user to locate unfilled cells or incorrectly filled cells and consequently, it becomes a time-intensive and frustrating process. In addition, such activities distract the user from the primary objective of correctly populating the data in the grid.

SUMMARY

This summary is provided to introduce a selection of concepts, in a simplified format, that are further described in the detailed description of the invention. This summary is neither intended to identify key or essential inventive concepts of the invention and nor is it intended for determining the scope of the invention.

In an embodiment of the present disclosure, a method of populating data in a grid having a plurality of rows and a plurality of columns is disclosed. The method includes detecting, by a detecting module, that at least one column is not visible on a screen. The method includes generating, by a generating module, a sliding pane on the screen for each row. The sliding pane includes a tab for each cell of the row that corresponds to an invisible column. The method includes receiving, by a receiving module, a value to be filled in a cell corresponding to the invisible column through the associated tab. The method includes populating, by a populating module, the data in the grid based on the receipt of values in tabs of the sliding pane for each row.

In another embodiment of the present disclosure, a method of populating data in a grid having a plurality of rows and a plurality of columns is disclosed. The method includes detecting, by a detecting module, that at least one row is not visible on a screen. The method includes generating, by a generating module, a sliding pane on the screen for each column. The sliding pane includes a tab for each cell of the column that corresponds to an invisible row. The method includes receiving, by a receiving module, a value to be filled in a cell corresponding to the invisible row through the associated tab. The method includes populating, by a populating module, the data in the grid based on the receipt of values in tabs of the sliding pane for each column.

In another embodiment of the present disclosure, a system of populating data in a grid having a plurality of rows and a plurality of columns is disclosed. The system includes a detecting module adapted to detect that at least one column is not visible on a screen. The system includes a generating module in communication with the detecting module and adapted to generate a sliding pane on the screen for each row. The sliding pane includes a tab for each cell of the row that corresponds to an invisible column. The system includes a receiving module in communication with the generating module and adapted to receive a value to be filled in a cell corresponding to the invisible column through the associated tab. The system includes a populating module in communication with the receiving module and adapted to populate the data in the grid based on the receipt of values in tabs of the sliding pane for each row.

In another embodiment of the present disclosure, a system of populating data in a grid having a plurality of rows and a plurality of columns is disclosed. The system includes a detecting module adapted to detect that at least one row is not visible on a screen. The system includes a generating module in communication with the detecting module and adapted to generate a sliding pane on the screen for each column. The sliding pane includes a tab for each cell of the column that corresponds to an invisible row. The system includes a receiving module in communication with the generating module and adapted to receive a value to be filled in a cell corresponding to the invisible row through the associated tab. The system includes a populating module in communication with the receiving module and adapted to populate the data in the grid based on the receipt of values in tabs of the sliding pane for each column.

To further clarify advantages and features of the present invention, a more particular description of the invention will be rendered by reference to specific embodiments thereof, which is illustrated in the appended drawings. It is appreciated that these drawings depict only typical embodiments of the invention and are therefore not to be considered limiting of its scope. The invention will be described and explained with additional specificity and detail with the accompanying drawings.

BRIEF DESCRIPTION OF THE DRAWINGS

These and other features, aspects, and advantages of the present invention will become better understood when the following detailed description is read with reference to the accompanying drawings in which like characters represent like parts throughout the drawings, wherein:

Figure 1 illustrates a User Interface (UI) depicting required scrolling in a grid for populating data in cells, according to an existing technique;
Figure 2 illustrates a block diagram of a system of populating data in a grid having a plurality of rows and a plurality of columns, according to an embodiment of the present disclosure;
Figure 3 illustrates a User Interface (UI) depicting population of data in the grid through a sliding pane on a screen, according to an embodiment of the present disclosure;
Figure 4 illustrates a flow chart depicting a method of populating content in a grid, according to an embodiment of the present disclosure; and
Figure 5 illustrates a flow chart depicting a method of populating content in a grid, according to another embodiment of the present disclosure.

Further, skilled artisans will appreciate that elements in the drawings are illustrated for simplicity and may not have been necessarily been drawn to scale. For example, the flow charts illustrate the method in terms of the most prominent steps involved to help to improve understanding of aspects of the present invention. Furthermore, in terms of the construction of the device, one or more components of the device may have been represented in the drawings by conventional symbols, and the drawings may show only those specific details that are pertinent to understanding the embodiments of the present invention so as not to obscure the drawings with details that will be readily apparent to those of ordinary skill in the art having benefit of the description herein.

DETAILED DESCRIPTION OF FIGURES

For the purpose of promoting an understanding of the principles of the invention, reference will now be made to the embodiment illustrated in the drawings and specific language will be used to describe the same. It will nevertheless be understood that no limitation of the scope of the invention is thereby intended, such alterations and further modifications in the illustrated system, and such further applications of the principles of the invention as illustrated therein being contemplated as would normally occur to one skilled in the art to which the invention relates. Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skilled in the art to which this invention belongs. The system, methods, and examples provided herein are illustrative only and not intended to be limiting.

Embodiments of the present invention will be described below in detail with reference to the accompanying drawings.

For the sake of clarity, the first digit of a reference numeral of each component of the present disclosure is indicative of the Figure number, in which the corresponding component is shown. For example, reference numerals starting with digit “1” are shown at least in Figure 1. Similarly, reference numerals starting with digit “2” are shown at least in Figure 2.

Figure 2 illustrates a block diagram of a system 200 of populating data in a grid having a plurality of rows and a plurality of columns, according to an embodiment of the present disclosure. In an embodiment, the system 200 may be adapted to be implemented in an electronic device, such as a smartphone, a desktop, a palmtop, and a laptop.

In an embodiment, the system 200 may include, but is not limited to, a processor 202, memory 204, modules 206, and data 208. The modules 206 and the memory 204 may be coupled to the processor 202. The processor 202 can be a single processing unit or a number of units, all of which could include multiple computing units. The processor 202 may be implemented as one or more microprocessors, microcomputers, microcontrollers, digital signal processors, central processing units, state machines, logic circuitries, and/or any devices that manipulate signals based on operational instructions. Among other capabilities, the processor 202 is configured to fetch and execute computer-readable instructions and data stored in the memory 204.

The memory 204 may include any non-transitory computer-readable medium known in the art including, for example, volatile memory, such as static random access memory (SRAM) and dynamic random access memory (DRAM), and/or non-volatile memory, such as read-only memory (ROM), erasable programmable ROM, flash memories, hard disks, optical disks, and magnetic tapes.

The modules 206, amongst other things, include routines, programs, objects, components, data structures, etc., which perform particular tasks or implement data types. The modules 206 may also be implemented as, signal processor(s), state machine(s), logic circuitries, and/or any other device or component that manipulate signals based on operational instructions.

Further, the modules 206 can be implemented in hardware, instructions executed by a processing unit, or by a combination thereof. The processing unit can comprise a computer, a processor, such as the processor 202, a state machine, a logic array or any other suitable devices capable of processing instructions. The processing unit can be a general-purpose processor which executes instructions to cause the general-purpose processor to perform the required tasks or, the processing unit can be dedicated to performing the required functions. In another embodiment of the present disclosure, the modules 206 may be machine-readable instructions (software) which, when executed by a processor/processing unit, perform any of the described functionalities.

In an embodiment, the modules 206 may include a detecting module 210, a generating module 212, a receiving module 214, a populating module 216, and a categorizing module 218. The detecting module 210, the generating module 212, the receiving module 214, the populating module 216, and the categorizing module 218 may be in communication with each other. The data 208 serves, amongst other things, as a repository for storing data processed, received, and generated by one or more of the modules 206.

In a first embodiment, the detecting module 210 may be adapted to detect that at least one column of the grid is not visible on a screen, for example, of the smartphone or of the desktop or of the palmtop or of the laptop. The detecting module 210 may be in communication with the generating module 212. Based on the detection, the generating module 212 may be adapted to generate a sliding pane. In an embodiment, when it is detected that there are one or more columns not visible on the screen, the generating module 212 may generate a sliding pane on the screen for each row. The sliding pane may include a tab for each cell of the row that corresponds to an invisible column. The generating module 212 may be in communication with the receiving module 214.

The receiving module 214 may be adapted to receive a value to be filled in a cell corresponding to the invisible column through the associated tab. For example, in order to populate content in a cell corresponding to an invisible column 10, a corresponding tab on the sliding pane is selected for filling in the respective detail therein. Further, the receiving module 214 may be in communication with the populating module 216. Based on the receipt of values in tabs of the sliding pane for each row, the populating module 216 may be adapted to populate the data in the grid.

In an embodiment, the categorizing module 218 may be adapted to categorize cells of a row based on relevance of their population. The categories of the cells may include, but are not limited to, a mandatory field category, a classified field category, and a missing field category. As the name suggests, the mandatory field category may include cells which are to be mandatorily filled for a subsequent action to be performed. Similarly, the classified field category is indicative of cells having classified information. Further, the missing field category is indicative of vacant cells. The categorizing module 218 may be in communication with the generating module 212.

The generating module 212 may be adapted to generate the sliding pane having a plurality of sub-panes. Each sub-pane includes tabs corresponding to the cells belonging to one category. In an embodiment, the generating module 212 may be adapted to generate the sliding pane having a sub-pane enlisting tabs corresponding to cells of the row that are to be mandatorily filled, based on the categorization. In an embodiment, the generating module 212 may be adapted to generate the sliding pane having a sub-pane enlisting tabs corresponding to cells of the row that are missing a value, based upon the categorization. In an embodiment, the generating module 212 may be adapted to generate the sliding pane having a sub-pane enlisting tabs corresponding to cells of the row that are adapted to include classified values, based on the categorization.

In a second embodiment, the detecting module 210 may be adapted to detect that at least one row is not visible on the screen. The generating module 212 may be adapted to generate a sliding pane on the screen for each column. The sliding pane may include a tab for each cell of the column that corresponds to an invisible row. The receiving module 214 may be adapted to receive a value to be filled in a cell corresponding to the invisible row through the associated tab. The populating module 216 may be adapted to populate the data in the grid based on the receipt of values in tabs of the sliding pane for each column.

As would be appreciated by a person skilled in the art, all the other functionalities of the system 200 that are applicable to the first embodiment are equally applicable to the second embodiment, without departing from the scope of the present disclosure. For the sake of brevity, those details are not repeated in the second embodiment.

Figure 3 illustrates a User Interface (UI) 300 depicting population of data in the grid through the sliding pane 302 on the screen, according to an embodiment of the present disclosure. The UI 300 particularly relates to the first embodiment, i.e., including the sliding pane 302 with cells of a row belonging to invisible columns. As illustrated, cells belonging to columns 12, 13, 14, 15, 16, and thereon that are not visible on the screen are enlisted on the sliding pane 302, allowing the user to populate all cells of a row belonging to invisible columns on the same screen.

The sliding pane 302 further includes sub-panes 304 for selecting a category of cells that the user wishes to have on the sliding pane 302. For example, if the user selects a “mandatory cell” sub-pane, all mandatory cells belonging to invisible columns may be enlisted on the sliding pane 302 in form of tabs 306, individual referred to as 306-1, 306-2, 306-3, 306-4, 306-5, and 306-N. Similarly, if the user selects a “missing cell” sub-pane, all empty cells belonging to invisible columns may be enlisted on the sliding pane 302. Further, if the user selects a “classified cell” sub-pane, all cells belonging to invisible columns having classified information may be enlisted on the sliding pane 302. These cells can then be populated by selecting the respective tab 306 and filling in the required details therein.

As would be appreciated by a person skilled in the art, the above-mentioned categories are mere examples and the cells may be categorised in other categories as well, without departing from the scope of the present disclosure.

Figure 4 illustrates a flow chart depicting a method 400 of populating content in the grid, according to an embodiment of the present disclosure. In an embodiment, the method 400 may be a computer-implemented method 400. In an embodiment, the method 400 may be executed by the processor 202. Further, for the sake of brevity, features of the present disclosure that are explained in detail in the description of Figure 1, Figure 2, and Figure 3 are not explained in detail in the description of Figure 4.

At a block 402, the method 400 includes detecting that at least one column is not visible on a screen. In an embodiment, the detecting module 210 of the system 200 may detect that at least one column is not visible.

At a block 404, the method 400 includes generating the sliding pane on the screen for each row. The sliding pane includes a tab for each cell of the row that corresponds to an invisible column. In an embodiment, the generating module 212 may generate the sliding pane.

At a block 406, the method 400 includes receiving the value to be filled in a cell corresponding to the invisible column through the associated tab. In an embodiment, the receiving module 214 may be adapted to receive the value.

At a block 408, the method 400 includes populating the data in the grid based on the receipt of values in tabs of the sliding pane for each row. In an embodiment, the populating module 216 may be adapted to populate the data.

In an embodiment, the method 400 may include categorizing the cells of a row based on relevance of their population. The categories of the cells include at least one of a mandatory field category and a missing field category. In such an embodiment, the method 400 may further include generating the sliding pane having the plurality of sub-panes. Each sub-pane includes tabs corresponding to the cells belonging to one category.

In an embodiment, the method 400 may include generating the sliding pane having a sub-pane enlisting tabs corresponding to cells of the row that are to be mandatorily filled, based upon the categorization.

Figure 5 illustrates a flow chart depicting a method 500 of populating content in a grid, according to another embodiment of the present disclosure. In an embodiment, the method 500 may be a computer-implemented method 500. In an embodiment, the method 500 may be executed by the processor 202. Further, for the sake of brevity, features of the present disclosure that are explained in detail in the description of Figure 1, Figure 2, Figure 3, and Figure 4 are not explained in detail in the description of Figure 5.

At a block 502, the method 500 includes detecting that at least one row is not visible on a screen. In an embodiment, the detecting module 210 of the system 200 may detect that at least one row is not visible.

At a block 504, the method 500 includes generating the sliding pane on the screen for each column. The sliding pane includes a tab for each cell of the column that corresponds to an invisible row. In an embodiment, the generating module 212 may generate the sliding pane.

At a block 506, the method 500 includes receiving the value to be filled in a cell corresponding to the invisible row through the associated tab. In an embodiment, the receiving module 214 may be adapted to receive the value.

At a block 508, the method 500 includes populating the data in the grid based on the receipt of values in tabs of the sliding pane for each column. In an embodiment, the populating module 216 may be adapted to populate the data.

As would be gathered, the system 200, the method 400, and the method 500 offer a comprehensive and effective approach for populating data in a grid, without unnecessary scrolling in the grid. Since the sliding pane allows the user to fill the details in the cells belonging to invisible rows and columns, the user does not need to unnecessary keep scrolling through the grid. This would also allow the user to concentrate on populating the data while avoiding any operational difficulty.

Moreover, the sliding pane includes multiple sub-panes to facilitate category-wise population of the cells, providing convenience of selective filtering and population of the cells to the user. For example, the user can selectively filter the cells to provide a particular category of cells on the sliding pane. This would particularly assist the user in conveniently locating different cells of the grid. This would also save significant time in populating the grid.

Furthermore, due to the simplicity of the proposed solution, no skills from the user are required as such to use the sliding pane and any user can easily avail this facility of sliding pane. Also, because of the convenience offered, the possibility of committing any error in population of the grid is significantly reduced. Therefore, the present disclosure offers a comprehensive approach for error-free population of the data in the grid that is effective, convenient, and accurate.

While specific language has been used to describe the present subject matter, any limitations arising on account thereto, are not intended. As would be apparent to a person in the art, various working modifications may be made to the method in order to implement the inventive concept as taught herein. The drawings and the foregoing description give examples of embodiments. Those skilled in the art will appreciate that one or more of the described elements may well be combined into a single functional element. Alternatively, certain elements may be split into multiple functional elements. Elements from one embodiment may be added to another embodiment.