WO2019140987A1 - Procédé de commande de tableau, dispositif, appareil et support d'informations - Google Patents

Procédé de commande de tableau, dispositif, appareil et support d'informations Download PDF

Info

Publication number
WO2019140987A1
WO2019140987A1 PCT/CN2018/114343 CN2018114343W WO2019140987A1 WO 2019140987 A1 WO2019140987 A1 WO 2019140987A1 CN 2018114343 W CN2018114343 W CN 2018114343W WO 2019140987 A1 WO2019140987 A1 WO 2019140987A1
Authority
WO
WIPO (PCT)
Prior art keywords
cell
touch operation
display screen
user
standard
Prior art date
Application number
PCT/CN2018/114343
Other languages
English (en)
Chinese (zh)
Inventor
张维元
Original Assignee
广州视源电子科技股份有限公司
广州视臻信息科技有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 广州视源电子科技股份有限公司, 广州视臻信息科技有限公司 filed Critical 广州视源电子科技股份有限公司
Publication of WO2019140987A1 publication Critical patent/WO2019140987A1/fr

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0487—Interaction techniques based on graphical user interfaces [GUI] using specific features provided by the input device, e.g. functions controlled by the rotation of a mouse with dual sensing arrangements, or of the nature of the input device, e.g. tap gestures based on pressure sensed by a digitiser
    • G06F3/0488—Interaction techniques based on graphical user interfaces [GUI] using specific features provided by the input device, e.g. functions controlled by the rotation of a mouse with dual sensing arrangements, or of the nature of the input device, e.g. tap gestures based on pressure sensed by a digitiser using a touch-screen or digitiser, e.g. input of commands through traced gestures
    • G06F3/04883—Interaction techniques based on graphical user interfaces [GUI] using specific features provided by the input device, e.g. functions controlled by the rotation of a mouse with dual sensing arrangements, or of the nature of the input device, e.g. tap gestures based on pressure sensed by a digitiser using a touch-screen or digitiser, e.g. input of commands through traced gestures for inputting data by handwriting, e.g. gesture or text
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/174—Form filling; Merging
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets

Definitions

  • the present disclosure relates to the field of spreadsheet technology, for example, to a table control method, apparatus, device, and storage medium.
  • the form is usually drawn by using a special form drawing software.
  • the presenter explains the problem, it is necessary to frequently switch between the form drawing software and the electronic whiteboard.
  • the table is written using the writing function of the electronic whiteboard, but the written table does not have the attributes of the drawing table and cannot be adjusted according to the adjustment method of the drawing table.
  • the related technology cannot implement the table function under the function of the electronic whiteboard.
  • the present disclosure provides a table control method, apparatus, device, and storage medium to solve the technical problem that the table function cannot be implemented under the function of the electronic whiteboard.
  • the present disclosure provides a table control method including:
  • the corresponding cells in the standard table are adjusted based on a user's touch operation in the display screen for the standard form.
  • the disclosure also provides a form control device comprising:
  • a table shaping module configured to display a standard form generated based on the handwritten table track in the display
  • a form adjustment module is configured to adjust a corresponding cell in the standard table based on a user's touch operation in the display screen for the standard form.
  • the present disclosure also provides an apparatus comprising:
  • a display screen for displaying a standard form, and at least one processor
  • a memory configured to store at least one program
  • the at least one program is executed by the at least one processor such that the at least one processor implements a table control method as described in the present disclosure.
  • the present disclosure also provides a storage medium containing computer executable instructions for performing a table control method as described in the present disclosure when executed by a computer processor.
  • the standard form is displayed on the display screen by forming the user's handwritten form track into a standard form, and the corresponding standard table is adjusted based on the touch operation of the user for the standard form.
  • the technical means of the cell realizes the shaping of the handwritten table track under the function of the electronic whiteboard, and can adjust the standard table by means of the touch standard table, for example, in the meeting scene, when the user needs to draw the form, Standard form data can be obtained without opening the table drawing software, which improves the user experience.
  • FIG. 1 is a flowchart of a table control method according to an embodiment
  • FIG. 2 is a schematic diagram of a display screen of a display screen according to an embodiment
  • FIG. 3 is a schematic diagram of a display screen of a display screen according to an embodiment
  • FIG. 4 is a schematic diagram of a display screen display interface provided by an embodiment
  • FIG. 5 is a flowchart of a table control method according to another embodiment
  • FIG. 6 is a schematic view showing an angle range provided by an embodiment
  • FIG. 7 is a schematic view showing an angle range provided by an embodiment
  • FIG. 8 is a schematic diagram of a display screen of a display screen according to another embodiment.
  • FIG. 9 is a schematic diagram of a display screen of a display screen according to another embodiment.
  • FIG. 10 is a schematic diagram of a display screen of a display screen according to another embodiment.
  • FIG. 11 is a schematic diagram of a display screen of a display screen according to another embodiment.
  • FIG. 12 is a schematic diagram of a display screen of a display screen according to another embodiment
  • FIG. 13 is a schematic diagram of a display screen of a display screen according to another embodiment.
  • FIG. 14 is a schematic diagram of a display screen of a display screen according to another embodiment.
  • 15 is a schematic diagram of a display screen of a display screen according to another embodiment.
  • FIG. 16 is a schematic structural diagram of a table control apparatus according to an embodiment
  • FIG. 17 is a schematic structural diagram of an apparatus according to an embodiment.
  • FIG. 1 is a flowchart of a table control method according to an embodiment.
  • the table control method provided by this embodiment may be executed by a table control device implemented by software and/or hardware and integrated in the device.
  • an interactive smart tablet is used as an example for executing a table control method, wherein the interactive smart tablet controls the content displayed on the display tablet through touch technology and realizes the integration of human-computer interaction operations.
  • the device, interactive smart tablet integrates various functions such as projector, electronic whiteboard, screen, audio, TV and video conferencing terminal.
  • the table control method provided in this embodiment includes the following steps.
  • Step 110 Display a standard form generated based on the handwritten table track in the display screen.
  • the display screen is a touch display screen.
  • the user can perform writing and control operations on the display screen with a finger or an associated smart pen.
  • the electronic whiteboard function is set, and the user can perform a writing operation in the display screen after the electronic whiteboard function is turned on, and the interactive smart tablet records the writing trajectory generated based on the writing operation in real time.
  • the writing trajectory is obtained by arranging a series of touch points in accordance with the writing timing. Therefore, when the writing track is recorded, the time stamp of the touch point in the writing track is recorded synchronously.
  • determining that the user stops writing may be: determining that the user stops writing when the user clicks the end button set in the display screen; or: not receiving the user input within the set time length Writing a trajectory determines that the user stops writing.
  • the handwritten table trajectory mentioned above is an unshaped trajectory.
  • the manner of determining whether the writing trajectory is a handwritten table trajectory may be: identifying whether the writing trajectory is a cross graphic or a suspected table graphic composed of at least two horizontal lines and at least two vertical lines, and if yes, determining writing The trajectory is a handwritten table trajectory; or: a table writing mode is set, when the user opens the table writing mode, the default writing trajectory is a handwritten table trajectory; or: the user is prompted to circumscribe the trajectory area, and the user is on the display screen. All writing trajectories inside the circled area are determined as handwritten table trajectories.
  • the method for integrating the handwritten table trajectory to obtain the standard table is: determining the peripheral rectangular coordinates of the table based on the plurality of boundary points of the handwritten table trajectory, and determining the number of rows of the table according to the intersection between the handwritten table trajectories, The number of columns, the number of cells, etc., and then draw the corresponding standard table based on the above data.
  • machine learning is performed on a plurality of existing standard tables to establish an shaping model, and the writing trajectory is input to the shaping model to determine whether the writing trajectory is a handwritten table trajectory by the shaping model, and if it is a handwritten table trajectory, shaping The model automatically draws a standard form.
  • FIG. 2 is a schematic diagram of a display screen display interface provided by an embodiment.
  • the handwritten table track displayed in the display screen includes four horizontal lines and four vertical lines.
  • the handwritten table trajectory is shaped according to the manner mentioned above, and a plurality of standard tables having the same cell width and height are obtained.
  • FIG. 3 is a schematic diagram of a display screen display interface provided by an embodiment. A standard table in which the widths and heights of the plurality of cells obtained based on the handwritten table trajectory in FIG. 2 are the same are displayed in the display interface of FIG.
  • FIG. 4 is a schematic diagram of a display screen display interface provided by an embodiment, and the display interface of FIG. 4 displays a width and a height of a plurality of cells obtained based on the handwritten table track in FIG. 2 according to a corresponding handwritten table track. Standard tables with different and different distances.
  • the standard table mentioned above is a machine-drawn table, similar to the table displayed in Excel, or the table inserted in Word, the number of columns corresponding to different rows may be different, and the number of columns corresponding to different The number of rows can also be different.
  • Step 120 Adjust a corresponding cell in the standard table based on a user's touch operation on the standard form in the display screen.
  • the user's writing trajectory is continuously acquired and recognized. If the recognized writing trajectory is a text trajectory, the printed text data of the text trajectory is displayed in the cell in which the writing trajectory is located. If the recognition writing track is not a text track, it is confirmed that the writing track is a touch operation of adjusting a corresponding cell in the standard table.
  • the adjusting cell includes: adjusting a column width of the cell, adjusting a row width of the cell, merging the cell, splitting the cell, modifying a background parameter of the cell, deleting the cell, deleting the cell, and displaying the cell At least one of the data and the display parameters that change the data displayed in the cell.
  • the at least one corresponding touch operation when the cell is adjusted is preset.
  • the adjustment item corresponding to the touch operation and the cell to be adjusted are identified, and the cells to be adjusted are adjusted accordingly.
  • the specific setting mode and setting content of the touch operation may be set according to actual conditions.
  • the adjustment mode may be flexible when the cell is adjusted. Compared to tables in Excel or Word, the adjustment method can be simpler.
  • the standard form is saved as editable data in a format.
  • the execution manner of the save instruction is not limited in this embodiment. For example, when it is detected that the current display interface is closed, it is determined that the save instruction is received, and the standard table is saved as editable data in a set format, or when it is detected that the save button is clicked, it is determined that the save command is received. Save the standard table as editable data in a format.
  • the technical solution provided by the embodiment provides a technical method for adjusting a standard table in a display screen by forming a standard form of a user's handwritten form track, and adjusting a corresponding cell in the standard form based on a user's touch operation on the standard form.
  • the shaping of the handwritten table trajectory is realized, and the standard table can be adjusted by touching the standard form of the display screen. For example, in the meeting scene, when the user needs to draw the table, there is no need to open the table separately. Drawing software can also get standard table data, which enhances the user experience.
  • FIG. 5 is a flowchart of a table control method according to another embodiment. This embodiment is embodied on the basis of the above embodiment. Referring to FIG. 5, the table control method provided in this embodiment includes the following steps.
  • step 2010 the handwritten table track written by the user in the display screen is recorded in real time.
  • the current writing trajectory of the user is set to default to the handwritten table trajectory.
  • the interactive smart tablet determines the position of the plurality of touch points in the writing track and the corresponding time stamp.
  • the handwritten table track obtained by the user writes and the track mark of the standard track in the standard form obtained by the shaping are different, and the interactive smart tablet can distinguish the handwritten table track and the standard track in the display screen by the track identifier.
  • the writing track in the display screen may only be partially a handwritten table track, and the remaining writing tracks are used to display other contents input by the user. At this time, the display screen needs to use a handwritten form track and a writing track for displaying other contents.
  • the distinguishing manner may be: setting the table writing mode. When the table writing mode is turned on, the writing trajectory obtained before the default table writing mode starts until the user stops writing is a handwritten table trajectory.
  • Step 2020 When it is confirmed that the user stops writing, the attribute information of the standard table is determined based on all the handwritten table trajectories currently recorded.
  • the set length of time may be set according to actual conditions, such as 1 minute or 2 minutes.
  • the shaping model determines whether the handwritten table trajectory can form a table according to the position point of the handwritten table trajectory and the time stamp, if the form can be formed
  • the attribute information of the table is determined.
  • the attribute information includes a peripheral matrix coordinate of the table, a number of rows, a number of columns, a number of cells, a position of each edge in the table, and a background parameter of the cell.
  • the edges are row edges and column edges in a standard table.
  • a rectangle surrounded by a plurality of edges of the handwritten table track is determined and the rectangle is shaped to determine the peripheral matrix coordinates.
  • the number and position of the row and column edges inside the rectangle are determined, thereby determining the number of rows, the number of columns, the number of cells, and the position of each edge in the table.
  • the handwritten table trajectory input during the user writing process may not be standard, such as the handwritten table trajectory shown in FIG. 2, in FIG. 2, some handwritten table trajectories are not smooth straight lines, and some handwritten table trajectories are not horizontal. Axis or vertical axis.
  • the error range can be set. When the handwritten table track is within the error range, the default is the effective track.
  • the standard table obtained by the shaping model contains only the row and column edges, and does not include the beveled edges.
  • Step 2030 Delete the handwritten table track in the display screen, and display a corresponding standard table in the display screen based on the attribute information.
  • the specific manner of deleting the handwritten table track is not limited in this embodiment.
  • all handwritten table tracks are deleted at the same time, or the handwritten table track is deleted according to the time stamp.
  • Deleting handwritten table tracks and displaying standard forms can be performed simultaneously or sequentially.
  • the specific manner of displaying the standard form is not limited in this embodiment. For example, all cells in the standard table are displayed at the same time.
  • a standard table can be thought of as a trajectory that is redrawn based on a handwritten table trajectory. Since it is a trajectory, the standard form may be unintentionally erased by the user. For example, when the user erases the display data of a cell by using the electronic rubber eraser, the edge of the cell is unintentionally erased. At this time, the interactive smart tablet is set to repair the cell by itself to ensure the integrity of the cell edge. For example, when the interactive smart panel detects that the edge of the cell is synchronized with the display data in the cell and is erased by the electronic eraser, the erased edge is recorded and the erased edge is restored after the erase is completed.
  • Step 2040 Record attribute information corresponding to the standard table in the attribute comparison table.
  • an attribute comparison table is set for the standard form.
  • each standard form corresponds to an attribute comparison table.
  • the storage location and naming format of the attribute comparison table can be set according to actual conditions.
  • the attribute table matches standard table locations, cell locations, and attribute information for each cell. When the interactive smart tablet wants to find a cell, it only needs to determine the location of the cell and the attribute information according to the attribute comparison table.
  • Step 2050 Detect a touch operation input by the user in the display screen.
  • the touch operation when it is determined that the writing track is a touch operation, the touch operation is resolved.
  • the specific analysis manner of the touch operation may be set according to actual conditions.
  • determining a corresponding adjustment item according to the touch operation includes the following steps.
  • Step 2060 If the starting position of the touch operation input by the user in the display screen coincides with the vertex position of any vertex in the standard table, the standard table is scaled according to the touch operation. And step 2120 is performed.
  • the drawn standard table outline shape is a rectangle containing 4 vertices. If it is determined that the start position coincides with the vertex position corresponding to any vertex in the standard table, it is determined that the operation of scaling the standard table is performed. In an embodiment, if the touch operation is to move to the inside of the standard table based on the starting position, the standard form is reduced, and the vertex is controlled to coincide with the current position of the touch operation in real time to reduce the standard form in real time. If the touch operation is to move outside the standard table based on the starting position, the zoom standard table is determined, and the vertex is controlled to coincide with the current position point of the touch operation in real time to enlarge the standard table in real time.
  • the first pressing duration is set, and if the coincidence time of the starting position and the vertex position exceeds the first pressing duration, it is determined to perform the scaling standard table operation. For example, after displaying the standard table in the display screen, if it is determined that a certain point is pressed by the user, and the point coincides with a vertex position of the standard table, and the coincidence time exceeds the first pressing duration, it is determined that the touch operation is received. And the touch operation is used to scale the standard table. In an embodiment, after the first pressing duration is exceeded, the vertex is controlled in real time to coincide with the current position of the touch operation to achieve standard table scaling.
  • Step 2070 If the starting position of the touch operation input by the user in the display screen coincides with the intersection position of the intersection point of any cell in the standard table, the edge containing the cell intersection point is moved according to the touch operation to adjust the inclusion The first cell of the edge. And step 2120 is performed.
  • the intersection of cells refers to other intersections in the standard table except for the four vertices. Taking the standard table in Figure 3 as an example, the standard table includes 12 cell intersection points. In one embodiment, if it is determined that the intersection of the starting position and the intersection of any of the cells in the standard table coincides, it is determined that the edge of the intersection is adjusted.
  • the edges are row edges and/or column edges. In general, each intersection corresponds to one row edge and one column edge.
  • a row edge refers to an edge on the same horizontal axis corresponding to a row of cells, that is, a row of cells includes two row edges.
  • a column edge refers to an edge on the same vertical axis corresponding to a column of cells, that is, a column of cells includes two column edges.
  • the second pressing duration is set, and if the coincidence time of the starting position and the vertex position exceeds the second pressing duration, it is determined that the operation of moving the edge is performed.
  • the size of the first cell that contains the edge changes.
  • the adjustment amplitude is related to a current location point of the touch operation.
  • moving the edge line including the cell intersection point according to the touch operation includes the following steps.
  • Step 20710 Determine a connection between a current touch position and a start position of the touch operation.
  • connection can be selectively displayed in the display according to actual conditions.
  • Step 20720 Determine a moving direction according to an angle between a line and a line where the cell intersects, and the axis includes a horizontal axis and/or a vertical axis.
  • an exemplary representation is made with a horizontal axis as an example, and a row edge including a cell intersection point is a horizontal axis.
  • the angle between the line and the horizontal axis is calculated, and the direction of movement of the intersection of the cells is determined based on the angle.
  • the moving direction corresponding to the different angle range is preset, and the moving direction corresponding to the angle is determined according to the angle range of the angle. This has the advantage of preventing the user from accurately adjusting the first cell at an angle. For example, the user wants to move the line edge upwards, but the user may not be able to ensure that the selected cell intersection point moves vertically upwards in the actual operation. Therefore, setting the angle range can reduce the user's operation. Accuracy.
  • the moving direction corresponding to different angle ranges may be based on actual conditions.
  • FIG. 6 is a schematic diagram of an angle range provided by an embodiment.
  • the angle range is determined according to the horizontal axis 21, and when the clip is angled into the included angle range A, it is determined that the moving direction is moving to the right.
  • the corner of the clip enters the angle range B, it is determined that the moving direction is upward.
  • the clip corner enters the included angle range C, it is determined that the moving direction is moving to the left.
  • the corner of the clip enters the angle range D it is determined that the moving direction is downward.
  • FIG. 7 is a schematic diagram of an angle range provided by another embodiment.
  • the angle range is determined according to the horizontal axis 22, and when the clip corner enters the included angle range E, it is determined that the moving direction is moving to the right.
  • the corner of the clip enters the angle range F it is determined that the moving direction is moving in the upper right direction.
  • the clip corner enters the included angle range G it is determined that the moving direction is moving upward.
  • the corner of the clip enters the angle range H it is determined that the moving direction is moving to the upper left direction.
  • the corner of the clip enters the angle range I it is determined that the moving direction is moving to the left.
  • the corner of the clip enters the angle range J it is determined that the moving direction is moving to the lower left direction.
  • the corner of the clip enters the angle range K it is determined that the moving direction is downward.
  • the corner of the clip enters the angle range L it is determined that the moving direction is moving to the lower right direction.
  • the moving direction is determined in the same manner as the horizontal axis, and details are not described herein.
  • Step 20730 Calculate the distance between the current touch position and the start position.
  • the distance includes a horizontal distance and/or a vertical distance, and the distance may be represented by the number of pixel points. For example, it is determined that the current touch position and the start position are spaced apart by the number of pixel points in the horizontal direction to obtain a horizontal distance. The number of pixel points in the vertical direction of the current touch position and the start position is determined to obtain a vertical distance. In an embodiment, if the current touch position is on the same horizontal axis as the start position, the distance includes only the horizontal distance. If the current touch position is on the same vertical axis as the start position, the distance is only included. Vertical distance.
  • the distance In order to reduce the amount of calculation when calculating the distance, it is set to determine the specific content included in the distance according to the moving direction. For example, when the moving direction is moving upward, only the vertical distance needs to be calculated. When the direction of movement is to the right, only the horizontal distance needs to be calculated. When moving in the direction of moving to the left, you need to calculate the horizontal distance and the vertical distance.
  • Step 20740 Select an edge according to the moving direction, and move the selected edge according to the distance.
  • the corresponding edge when the moving direction is moving upward or downward, the corresponding edge is a line edge.
  • the corresponding edge When the moving direction is moving to the left or moving to the right, the corresponding edge is the column edge.
  • the moving direction is other directions, such as the upper left direction or the lower right direction, and the corresponding edge lines are row edge and column edge.
  • the interactive smart tablet adjusts the corresponding edge according to the current touch position in real time.
  • FIG. 8 is a schematic diagram of a display screen of a display screen according to another embodiment.
  • the cell intersection point Z coincides with the starting position and the coincidence time exceeds the second set time period.
  • the angle between the line connecting the Z point and the Y point and the line edge 23 where the Z point is located is calculated, and the moving direction is determined to be upward according to the angle range of the included angle.
  • the vertical distance between the Z point and the Y point is calculated, and the line edge 23 containing the Z point is moved upward according to the vertical distance.
  • FIG. 9 is a schematic diagram of a display screen of a display screen according to another embodiment.
  • the size information of the first cell 24 including the row edge 23 changes after the Z point is moved.
  • the angle between the line connecting the Z point and the W point and the line edge 23 of the Z point is calculated, and according to the angle range of the angle, the moving direction is determined to be the lower right direction.
  • the vertical and horizontal distances of the Z and W points are calculated, the line side line 23 containing the Z point is moved downward according to the vertical distance, and the column side line 25 containing the Z point is moved to the right according to the horizontal distance.
  • FIG. 10 is a schematic diagram of a display screen of a display screen according to another embodiment. It can be seen from FIG. 10 that the size information of the first cell 26 including the row edge 23 and the column edge 25 changes after the Z point is moved.
  • Step 2080 If the starting position of the touch operation input by the user in the display screen is located on the border line of any cell and the position is fixed within the set time period, the frame line is moved according to the touch operation to adjust the frame line included The second cell. And step 2120 is performed.
  • one cell contains four border lines, and any two adjacent cells have one border line.
  • Each edge is made up of a certain number of border lines. For example, referring to the standard table in Figure 4, each edge contains 3 border lines.
  • each border line includes two endpoints, and the starting position on the border line means that the starting position is at a non-end point in the border line.
  • the duration is set in advance, and if the dwell time of the start position on the border line exceeds the length of time, it is determined that the operation of moving the border line is performed.
  • the set duration is a third set duration.
  • the border line is a vertical border line and the current touch position is on the left side of the start position, it is determined that the vertical border line is moved to the left, and the current touch position and the start position are calculated. Horizontal distance to move the border line to the left according to the horizontal distance. The way to move the border line to the right is similar to the way to move the border line to the left, and will not be described here. If the border line is a horizontal border line and the current touch position is above the start position, it is determined that the horizontal border line is moved upward, and the vertical distance between the current touch position and the start position is calculated to be up according to the vertical distance. Move the border line.
  • the way to move the border line down is similar to the way the border line is moved up, and will not be described here.
  • the border line can only move in the vertical or horizontal direction.
  • the distance calculation method mentioned above is the same as the distance calculation method described in step 20730, and details are not described herein.
  • FIG. 11 is a schematic diagram of a display screen of a display screen according to another embodiment. As can be seen from FIG. 11, after the frame line 27 moves to the P point, the size information of the second cell 28 including the P point changes.
  • Step 2090 If the start position and the end position of the touch operation input by the user in the display screen are located in different cells, all the third cells through which the touch operation passes are merged. And step 2120 is performed.
  • the cell where the starting position is located and the cell where the end position is located are determined, and a plurality of cells included in the horizontal direction between the two cells and a plurality of cells included in the vertical direction are determined.
  • the cell, and each cell contained is recorded as the third cell, and then all third cells are merged.
  • the touch track corresponding to the touch operation is a straight line or a curved line.
  • step 2090 includes the following steps:
  • Step 20910 retrieve an editable operation line.
  • the line of operation is a line that adjusts the position of the end point.
  • the manner of retrieving the operation line is not limited in this embodiment, such as displaying a tool box of the operation line in the display screen, and when it is determined that the tool box is selected, the operation line is displayed in the display screen. In an embodiment, the line of operation is displayed outside of the standard form.
  • Step 20920 Adjust the operation line based on the touch operation input by the user in the display screen.
  • the user adjusts the two end positions of the operation line by a touch operation. For example, when an endpoint is clicked and dragged by a user, the endpoint is moved synchronously according to the user's drag.
  • Step 20930 Determine a plurality of third cells that the adjusted operation line passes, and merge the plurality of third cells.
  • FIG. 12 is a schematic diagram of a display screen display interface provided by another embodiment. Referring to FIG.
  • the cell h merged by the operation line contains all columns of the row. At this time, the display of the display is displayed. Refer to Figure 13 for the interface.
  • Step 2100 If the start position and the end position of the touch operation input by the user in the display are located on different border lines of the same cell, the fourth cell corresponding to the touch operation is split according to the touch operation. And step 2120 is performed.
  • setting the cell split includes: horizontal splitting, vertical splitting, and bevel splitting.
  • FIG. 14 is a schematic diagram of a display screen display interface provided by another embodiment.
  • the start position c and the end position d of the touch operation are located at both ends of the fourth cell 29, and the fourth cell 29 is beveled according to the line between the start position c and the end position d. Divided into two cells.
  • the cells may be split by calling the operation line. At this time, as long as the operation lines are located in the same cell, the cells may be split according to the operation lines.
  • Step 2110 If multiple positions of the touch operation input by the user in the display screen are all located inside the same cell, determine an operation instruction corresponding to the touch track generated based on the touch operation, and adjust the touch according to the operation instruction. Control the fifth cell corresponding to the track. And step 2120 is performed.
  • the operation instruction includes at least one of: replacing a background parameter of the cell, deleting the display data in the cell, deleting the cell, and changing the display parameter of the display data in the cell.
  • the display data in the cell is deleted synchronously when the cell is deleted.
  • the outermost cell of the standard table set in this embodiment can be deleted.
  • the display parameters include: a font size, a color, a font, and the like of the display data.
  • the correspondence between the touch track and the operation command may be set according to actual conditions.
  • the touch track is set to be a cross track
  • the corresponding operation command is to delete the cell.
  • FIG. 15 is a schematic diagram of a display screen display interface provided by another embodiment. Referring to FIG. 15, the touch track 2001 is detected as a cross track, and in the cell 2002, at this time, the operation command is determined to be the delete cell 2002.
  • the deletion operation line may be set. At this time, all cells passing through the deletion operation line are deleted according to the start position and the end position of the deletion operation line.
  • the operation process of deleting the operation line is similar to the operation process of the operation line when merging the cells, and details are not described herein.
  • the starting position information of the touch operation is located at any position including the vertex, the intersection point, and the border line, and the dwell time exceeds the set time length, it is determined that the touch operation is an operation of adjusting the cell size. At this time, the size of the corresponding cell is adjusted according to the touch operation. If the starting position information of the touch operation is located at any position including the vertex, the intersection point, and the border line, and the dwell time is not set to the length of time, it may be determined that the touch operation is other control operations for the cell, and the corresponding control operation is performed.
  • a touch operation when the cell is not adjusted by the operation line, a touch operation may include multiple touch tracks in the actual application, wherein one touch track has the same touch track as the other touch operations. At this time, in order to distinguish, the time interval can be set. If another touch track is not received within the set time interval after the completion of one touch track input, it is confirmed that the touch operation ends, and if the reception is received To another touch track, it is confirmed that the other touch track received is the same touch operation as the touch track.
  • Step 2120 Modify the attribute information recorded by the attribute comparison table according to the adjustment result.
  • the attribute information of the adjusted cell is synchronously updated in the attribute comparison table to ensure the timeliness of the attribute comparison table.
  • the technical solution provided by the embodiment is to display a standard table in the display screen by forming a standard form of the user's handwritten form, and simultaneously record attribute information of the plurality of cells in the attribute comparison table, and then based on the standard for the user.
  • the touch operation of the table adjusts the corresponding cells in the standard table, and the technical means of updating the attribute comparison table after adjustment, realizes shaping the handwritten table track in the interactive smart tablet and can adjust the standard table, for example, in the meeting.
  • the standard form can be obtained without opening the table drawing software.
  • the standard table is adjusted by using the touch function of the display, so that the user can adjust the standard form in real time, and the adjustment flexibility is added. , to enhance the user experience.
  • the attribute information table is used to facilitate statistics and management of attribute information of multiple cells in the standard table.
  • FIG. 16 is a schematic structural diagram of a table control apparatus according to an embodiment.
  • the table control apparatus provided in this embodiment includes: a table shaping module 301 and a table adjustment module 302.
  • the table shaping module 301 is configured to display a standard table generated based on the handwritten table track in the display screen; and the table adjusting module 302 is configured to adjust the standard table based on the touch operation of the standard table for the user in the display screen. The corresponding cell in .
  • the technical solution provided by the embodiment provides a technical method for adjusting a standard table in a display screen by forming a standard form of a user's handwritten form track, and adjusting a corresponding cell in the standard form based on a user's touch operation on the standard form.
  • the shaping of the handwritten table trajectory is realized in the interactive smart tablet, and the standard table can be adjusted by touching the standard form of the display screen. For example, in the meeting scene, when the user needs to draw the table, no additional Open the table drawing software can also get the standard form data, which improves the user experience.
  • the table adjustment module 302 is configured to: if the starting position of the touch operation input by the user in the display screen coincides with the vertex position of any vertex in the standard table, zoom according to the touch operation Standard form.
  • the table adjustment module 302 is configured to: if the position of the intersection of the touch operation input by the user in the display screen and any cell in the standard table coincides, according to the touch The operation moves the edge containing the intersection of the cells to adjust the first cell containing the edge; wherein the edge is a row edge and/or a column edge.
  • the table adjustment module 302 includes: a connection determination unit configured to overlap the intersection of the start position of the touch operation input with any cell in the standard table in the display screen, And determining a connection between the current touch position and the start position of the touch operation; the direction determining unit is configured to determine a moving direction according to an angle between the line connecting the line and the intersection point of the cell; wherein the axis includes the horizontal axis and/or Or a vertical axis; the distance calculating unit is configured to calculate a distance between the current touch position and the starting position; wherein the distance includes a horizontal distance and/or a vertical distance; the edge moving unit is set to select an edge according to the moving direction, and according to The distance moves the selected edge to adjust the size information of the first cell containing the edge; wherein the edge is a row edge and/or a column edge.
  • the table adjustment module 302 is configured to: if the user inputs the start position of the touch operation in the display screen on the border line of any cell and the position is fixed within the set time period, Move the border line according to the touch operation to adjust the second cell that contains the border line.
  • the table adjustment module 302 is configured to: if the start position and the end position of the touch operation input by the user in the display screen are located in different cells, merge the touch operation All third cells.
  • the table adjustment module 302 includes: an operation line retrieval unit configured to retrieve an editable operation line; and an operation line adjustment unit configured to adjust the touch operation based on the user inputting in the display screen.
  • the operation line; the merging unit is configured to determine a plurality of third cells through which the adjusted operation line passes, and merge the plurality of third cells.
  • the table adjustment module 302 is configured to: if the start position and the end position of the touch operation input by the user in the display screen are on different border lines of the same cell, according to the touch The fourth cell corresponding to the split touch operation is operated.
  • the table adjustment module 302 is configured to: if the plurality of location points of the touch operation input by the user in the display screen are all located inside the same cell, determine the touch generated by the touch operation. The operation instruction corresponding to the track is adjusted, and the fifth cell corresponding to the touch track is adjusted according to the operation instruction.
  • the operation command includes at least one of the following: replacing the background parameter of the cell, deleting the display data in the cell, deleting the cell, and changing the display parameter of the display data in the cell.
  • the table shaping module 301 includes: a track record unit configured to record the handwritten table track written by the user in the display screen in real time; and an information determining unit configured to be based on the current record when confirming that the user stops writing All of the handwritten table tracks determine the table attribute information; the table display unit is configured to delete the handwritten table track in the display screen and display the corresponding standard form in the display based on the attribute information.
  • the table control apparatus further includes: an attribute recording module configured to record in the attribute comparison table before adjusting the corresponding cell in the standard table based on the touch operation of the standard table for the user in the display screen The attribute information corresponding to the standard table; the attribute modification module is configured to modify the attribute information recorded by the attribute comparison table according to the adjustment result after adjusting the corresponding cell in the standard table based on the touch operation of the standard table for the user in the display screen.
  • the table control device provided in this embodiment is used to execute the table control method provided by any of the above embodiments, and has corresponding functions and beneficial effects.
  • FIG. 17 is a schematic structural diagram of an apparatus according to an embodiment.
  • the device includes a processor 40, a memory 41, an input device 42, an output device 43, and a display screen 44.
  • the number of processors 40 in the device may be one or more, and one processor 40 in FIG.
  • the processor 40, the memory 41, the input device 42, the output device 43, and the display screen 44 in the device may be connected by a bus or other means, and the bus connection is taken as an example in FIG.
  • the memory 41 is a computer readable storage medium, and may be a storage software program, a computer executable program, and a module, such as a program control module corresponding to the table control method according to any embodiment of the present disclosure (for example, in a table control device)
  • the table shaping module 301 and the table adjustment module 302) The processor 40 executes the above-described table control method by executing software programs, instructions, and modules stored in the memory 41, thereby performing various functional applications and data processing of the device.
  • the memory 41 may mainly include a storage program area and an storage data area, wherein the storage program area may store an operating system, an application required for at least one function; the storage data area may store data created according to usage of the device, and the like. Further, the memory 41 may include a high speed random access memory, and may also include a nonvolatile memory such as at least one magnetic disk storage device, flash memory device, or other nonvolatile solid state storage device. In some examples, memory 41 may include memory remotely located relative to processor 40, which may be connected to the device over a network. Examples of such networks include, but are not limited to, the Internet, intranets, local area networks, mobile communication networks, and combinations thereof.
  • Input device 42 can be configured to receive input numeric or character information and to generate key signal inputs related to user settings and function controls of the device.
  • the output device 43 may include an audio device such as a speaker and a buzzer.
  • the display screen 44 is arranged to display a handwritten table track and a standard form, and is also configured to receive a touch operation.
  • the device provided by this embodiment may be used to execute the table control method provided by any of the foregoing embodiments, and has corresponding functions and beneficial effects.
  • the embodiment further provides a storage medium containing computer executable instructions for executing a form control method when executed by a computer processor, the form control method comprising: displaying the display based on the display A standard form generated by handwritten table tracks; the corresponding cells in the standard table are adjusted based on the user's touch operations on the standard form in the display.
  • a storage medium containing computer executable instructions are not limited to the table control method operations as described above, and may also perform related operations in the table control method provided by any embodiment of the present disclosure. Operation, and with the corresponding functions and benefits.
  • the present disclosure can be implemented by software and necessary general hardware, and of course can also be implemented by hardware, but in many cases, the former is a better implementation.
  • the technical solution of the present disclosure may be embodied in the form of a software product, which may be stored in a computer readable storage medium, such as a computer floppy disk, a read-only memory (ROM), Random access memory (RAM), flash memory (FLASH), hard disk or optical disk, etc., including a plurality of instructions for causing a computer device (which may be a robot, a personal computer, a server, a network device, etc.) to perform the present disclosure
  • a computer device which may be a robot, a personal computer, a server, a network device, etc.

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Human Computer Interaction (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

Procédé de commande de tableau, dispositif, appareil et support d'informations. Le procédé de commande de tableau comprend les étapes consistant : à afficher sur un écran un tableau standard généré sur la base d'une trajectoire de tableau manuscrite ; et à ajuster des cellules correspondantes dans le tableau standard selon une opération de commande tactile qu'un utilisateur a effectuée sur l'écran quant au tableau standard.
PCT/CN2018/114343 2018-01-19 2018-11-07 Procédé de commande de tableau, dispositif, appareil et support d'informations WO2019140987A1 (fr)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201810054298.2A CN108334486B (zh) 2018-01-19 2018-01-19 表格控制方法、装置、设备及存储介质
CN201810054298.2 2018-01-19

Publications (1)

Publication Number Publication Date
WO2019140987A1 true WO2019140987A1 (fr) 2019-07-25

Family

ID=62925305

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2018/114343 WO2019140987A1 (fr) 2018-01-19 2018-11-07 Procédé de commande de tableau, dispositif, appareil et support d'informations

Country Status (2)

Country Link
CN (1) CN108334486B (fr)
WO (1) WO2019140987A1 (fr)

Families Citing this family (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108334486B (zh) * 2018-01-19 2021-02-09 广州视源电子科技股份有限公司 表格控制方法、装置、设备及存储介质
CN109284494A (zh) * 2018-09-07 2019-01-29 广州视源电子科技股份有限公司 一种动态调整表格的方法、装置、设备及存储介质
CN110163198B (zh) * 2018-09-27 2022-03-08 腾讯科技（深圳）有限公司 一种表格识别重建方法、装置和存储介质
CN109600594B (zh) * 2019-01-03 2021-05-18 歌尔科技有限公司 基于投影的触控点定位方法、投影设备及存储介质
CN109858000B (zh) * 2019-01-10 2021-09-07 广州视源电子科技股份有限公司 表格处理方法、装置、系统、存储介质及交互智能平板
CN111784800A (zh) * 2019-04-03 2020-10-16 珠海金山办公软件有限公司 一种图形对象选中方法、装置、电子设备及存储介质
CN111859874B (zh) * 2019-04-17 2023-06-13 百度在线网络技术（北京）有限公司 表格生成方法及其系统、视频播放设备和计算机可读介质
CN111310424B (zh) * 2020-01-16 2023-09-22 海信视像科技股份有限公司 表格生成方法及显示设备
CN112241624A (zh) * 2020-10-26 2021-01-19 深圳市皓丽智能科技有限公司 表格控制方法、装置及计算机存储介质
CN112394859A (zh) * 2020-11-12 2021-02-23 青岛海信商用显示股份有限公司 表格动态调整方法和终端设备
CN112363663B (zh) * 2020-11-27 2022-04-12 深圳集智数字科技有限公司 一种数据展示方法及装置
CN115048028A (zh) * 2022-05-13 2022-09-13 长沙朗源电子科技有限公司 一种电子白板的智能表格的控制方法、装置及存储介质

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120260152A1 (en) * 2011-03-01 2012-10-11 Ubiquitous Entertainment Inc. Spreadsheet control program, spreadsheet control apparatus and spreadsheet control method
CN105824548A (zh) * 2015-01-05 2016-08-03 珠海金山办公软件有限公司 一种电子表格单元格合并、拆分方法及装置
CN106293436A (zh) * 2015-05-27 2017-01-04 仁宝电脑工业股份有限公司 图表绘制方法
CN108334486A (zh) * 2018-01-19 2018-07-27 广州视源电子科技股份有限公司 表格控制方法、装置、设备及存储介质

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8786559B2 (en) * 2010-01-06 2014-07-22 Apple Inc. Device, method, and graphical user interface for manipulating tables using multi-contact gestures
KR20140073398A (ko) * 2012-12-06 2014-06-16 삼성전자주식회사 디스플레이 장치 및 그 제어 방법
CA2838165A1 (fr) * 2012-12-31 2014-06-30 Smart Technologies Ulc Procede de manipulation de tableaux dans un systeme d'entree interactif et systeme d'entree interactif executant le procede
JP2015049618A (ja) * 2013-08-30 2015-03-16 株式会社東芝 手書き文書処理装置、手書き文書処理方法及び手書き文書処理プログラム
US10025452B2 (en) * 2015-09-14 2018-07-17 Adobe Systems Incorporated Physics-based cell layout redesign
US10540435B2 (en) * 2015-11-02 2020-01-21 Microsoft Technology Licensing, Llc Decks, cards, and mobile UI

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120260152A1 (en) * 2011-03-01 2012-10-11 Ubiquitous Entertainment Inc. Spreadsheet control program, spreadsheet control apparatus and spreadsheet control method
CN105824548A (zh) * 2015-01-05 2016-08-03 珠海金山办公软件有限公司 一种电子表格单元格合并、拆分方法及装置
CN106293436A (zh) * 2015-05-27 2017-01-04 仁宝电脑工业股份有限公司 图表绘制方法
CN108334486A (zh) * 2018-01-19 2018-07-27 广州视源电子科技股份有限公司 表格控制方法、装置、设备及存储介质

Also Published As

Publication number Publication date
CN108334486A (zh) 2018-07-27
CN108334486B (zh) 2021-02-09

Similar Documents

Publication Publication Date Title
WO2019140987A1 (fr) Procédé de commande de tableau, dispositif, appareil et support d'informations
CN110069204B (zh) 基于书写轨迹的图形处理方法、装置、设备及存储介质
CN110045909B (zh) 基于书写轨迹的椭圆处理方法、装置、设备及存储介质
US9207858B2 (en) Method and apparatus for drawing and erasing calligraphic ink objects on a display surface
CN109445676B (zh) 在手写设备上删除用户输入的手写笔画信息的方法
CN108304132B (zh) 图形显示方法、装置、设备及存储介质
WO2019000681A1 (fr) Procédé, dispositif, appareil et support de stockage informatique pour disposer des informations
CN109407954B (zh) 一种书写轨迹的擦除方法和系统
CN111580714A (zh) 智能交互平板的页面编辑方法、装置、设备和存储介质
CN108874275B (zh) 一种笔迹擦除方法、装置、终端和计算机可读存储介质
US20140189482A1 (en) Method for manipulating tables on an interactive input system and interactive input system executing the method
WO2021068366A1 (fr) Procédé et dispositif d'opération d'écriture pour tableau blanc interactif intelligent, appareil et support de mémoire
CN105511794A (zh) 一种支持多点触控手势操作的标绘系统及其方法
US20130321350A1 (en) Virtual ruler for stylus input
KR102075433B1 (ko) 필기 입력 장치 및 그 제어 방법
CN110045840A (zh) 一种书写轨迹关联的方法、装置、终端设备和存储介质
CN109814787B (zh) 关键信息确定方法、装置、设备及存储介质
CN111580903B (zh) 实时投票方法、装置、终端设备和存储介质
WO2020143387A1 (fr) Procédé, dispositif et système de traitement de tables, et support de stockage et tablette interactive intelligente
WO2019218622A1 (fr) Procédé, appareil et dispositif de commande d'éléments, et support de stockage
US10127704B2 (en) Information processing device, program, and recording medium
JP2009116727A (ja) 画像入力表示装置
WO2023174369A1 (fr) Procédé de sélection de texte, appareil de sélection de texte, dispositif électronique et support de stockage lisible
JP2018067298A (ja) 手書き内容編集装置および手書き内容編集方法
CN109358799B (zh) 在手写设备上添加用户输入的手写批注信息的方法

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 18900796

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 24.11.2020)

122 Ep: pct application non-entry in european phase

Ref document number: 18900796

Country of ref document: EP

Kind code of ref document: A1