Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and device for displaying background color in electronic form

A spreadsheet and background color technology, applied in the field of background color display, can solve problems such as poor highlighting effect

Active Publication Date: 2012-11-14
YOZOSOFT
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] In the prior art, the selected cells are highlighted, and the highlighting effect is poor

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for displaying background color in electronic form
  • Method and device for displaying background color in electronic form
  • Method and device for displaying background color in electronic form

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0091] In this embodiment, the user selects a cell area, which is composed of a cell, such as Figure 2A As shown, the details are as follows:

[0092] Step 1: Collect drawing data when the mouse or keyboard selects a cell.

[0093] Obtain the mouse point coordinates when the mouse is pressed, and calculate the row and column numbers of the cell corresponding to the mouse point coordinates by accumulating the row height and column width of the table.

[0094] Step 2: Calculate the coordinate data of the cell on the view according to the row and column numbers of the selected cell, and construct the coordinate data into a rectangle (Rectangle) object. Calculate the coordinate data of the first rectangular area to be clipped composed of cells in the row where the cell is located and the second rectangular area to be clipped composed of cells in the column where the cell area is located, the first rectangular area to be clipped and the second rectangular area to be clipped The re...

Embodiment 2

[0103] In this embodiment, the user selects two cell areas, and each cell area is composed of a cell, such as Figure 3A As shown, the details are as follows:

[0104] Step 1: Collect drawing data when the mouse or keyboard selects a cell.

[0105] For multi-selection operation, hold down the ctrl key and click the left mouse button on two non-adjacent cells.

[0106] The coordinates of the mouse point are obtained each time the left mouse button is pressed, and the row and column numbers of the cell corresponding to each mouse point coordinate are calculated by accumulating the row height and column width of the table.

[0107] Step 2: According to the row and column numbers of the cells corresponding to the coordinates of each mouse point, calculate the coordinate data of each cell on the view, and construct the obtained coordinate data into a Rectangle object. For the coordinate data of each cell saved in the Rectangle object, calculate the first rectangular area to be cl...

Embodiment 3

[0118] In this embodiment, the user selects a cell area, which is composed of multiple cells, such as Figure 4A As shown, the details are as follows:

[0119] Step 1: Collect drawing data when the mouse or keyboard selects a cell.

[0120] When the mouse is pressed and dragged to an adjacent cell, the coordinates of the mouse point when the mouse is pressed and the coordinates of the mouse point when the mouse is released are obtained, and the distance between the two mouse points is calculated by accumulating the row height and column width of the table. The row and column numbers of the selected cells. Represented by a basicRange object, which records the row and column numbers of the cell where the mouse point is located when the mouse is pressed and the row and column number of the cell where the mouse point is located when the mouse is released;

[0121] Step 2: According to the row and column numbers recorded in the basicRange object, calculate the coordinate data of ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The embodiment of the invention discloses a method and a device for displaying a background color in an electronic form, which relate to the field of electronic office, and are used for improving the highlight effect on cells in the electronic form. The method comprises the following steps of: determining a cell region selected by a user, and determining a first rectangular region to be cut, which is formed by cells in a row where the cell region is positioned, and a second rectangular region to be cut, which is formed by cells in a column where the cell region is positioned; determining a rectangular region to be filled, which is left after the overlapped region of the first rectangular region to be cut and second rectangular region to be cut is cut; and displaying the background color of cells in the rectangular region to be filled as a preset color different from the background color of other unselected cells. By the method and the device, the highlight effect on the cells in the electronic form can be effectively improved.

Description

technical field [0001] The invention relates to the field of electronic office, in particular to a background color display method and device in an electronic form. Background technique [0002] In the current spreadsheet office software, such as Excel, when the user selects a cell in the spreadsheet, the background color of the cell will be changed to a color different from the background color of other unselected cells. And thicken and blacken the border of the cell to highlight the selected cell. [0003] When the user selects multiple adjacent cells in the spreadsheet by dragging the mouse, the background color of the active cell in the multiple adjacent cells will be changed to be different from the background color of other unselected cells , change the background color of the inactive cell among the multiple adjacent cells to a color different from the background color of the active cell and the background color of other unselected cells, and set the multiple adjacen...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F3/048G06F17/21G06F3/0481G06F3/0484
Inventor 黄亮
Owner YOZOSOFT