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

Formula reference switching method and device, mobile device

A technology that refers to switching and mobile devices, which is applied in the fields of instruments, electrical digital data processing, and data processing input/output processes, and can solve problems such as misoperation, increased operational complexity, and usage thresholds.

Active Publication Date: 2016-01-13
ZHUHAI KINGSOFT OFFICE SOFTWARE +1
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] On a PC (personal computer), Microsoft Excel provides a shortcut key of F4 to switch the formula reference mode. By pressing the F4 shortcut key, the status of "absolute reference", "mixed reference" and "relative reference" of the formula can be realized. Switching is convenient for the user to quickly switch the reference of the formula, but this design may need multiple switching between the target reference method and the original reference method to complete, which is not suitable for mobile devices, because there is no corresponding shortcut key on the mobile device, if Replacing the combination of keys on the mobile device will increase the complexity of the operation and the threshold of use, and the way of triggering or pressing a specific key multiple times at the same time is likely to cause misuse

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
  • Formula reference switching method and device, mobile device
  • Formula reference switching method and device, mobile device
  • Formula reference switching method and device, mobile device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0026] see figure 1 As shown, it is a schematic flowchart of an embodiment of the formula reference switching method of the present invention. Such as figure 1 As shown, the formula reference switching method in this embodiment includes the following steps:

[0027] Step S101: Detect whether the cell reference button is triggered, and when the trigger action of the cell reference button is detected, enter step S102, wherein the cell reference button needs to be defined in advance, and the cell reference button is displayed on the operation interface , defining and detecting whether the cell reference button is triggered can be implemented in an existing way, so I won’t go into details here;

[0028] Step S102: Locate the reference area in the electronic form, and proceed to step S103, wherein the positioning of the reference area can be realized in an existing way, which will not be described in detail here;

[0029] Step S103: and judge whether the cell reference button is...

Embodiment 2

[0047] According to the formula citation switching method of the present invention, the present invention further provides a formula citation switching device.

[0048] Such as Figure 4 As shown, it is a schematic structural diagram of an embodiment of the formula quoting switching device of the present invention, which includes:

[0049] The detection module 201 is used to detect whether the preset cell reference button is triggered. When the trigger action of the cell reference button is detected, a judgment instruction is sent to the judgment module 202, and a positioning instruction is sent to the positioning module 203. The cell reference button is defined in advance, and the button is displayed on the operation interface. The definition and detection of the button can be done in the existing way in the prior art, which will not be repeated here;

[0050] A judging module 202, configured to judge whether the cell reference button is selected when the judging instruction...

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 invention provides a formula reference switching method, a formula reference switching device which are used on a movable device and the movable device with the formula reference switching device. The formula reference switching method comprises the following steps: when touching action of a unit sheet reference button is detected, a user locates a reference area in a spreadsheet and judges whether the unit sheet reference button is picked on. If the button is picked on, a relative reference mold list is showed according to the reference area; if not, then the unit sheet reference button is picked on. The formula reference switching method, the formula reference switching device which are used on the movable device and the movable device with the formula reference switching device are convenient and fast to switch the formula reference mold and is intuitive and easy to operate. The switch of the formula reference mold is fast achieved, and the spreadsheet system is improved. Efficiency of operating the spreadsheet for users is improved.

Description

technical field [0001] The present invention relates to the technical field of mobile devices, in particular to a formula reference switching method and device, and a mobile device. Background technique [0002] For a spreadsheet document, the row and column information of a cell is the most important position feedback information. The advantage of the spreadsheet is that it can complete a large number of calculations. The calculation requires a value, and the value corresponds to a certain cell. To find the value of the cell, you must first find the row and column position information of the cell. Then The row and column position information of the cells referenced in the formula becomes extremely important. [0003] On a PC (personal computer), Microsoft Excel provides a shortcut key of F4 to switch the formula reference mode. By pressing the F4 shortcut key, the status of "absolute reference", "mixed reference" and "relative reference" of the formula can be realized. Sw...

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/0481
Inventor 张伶俐王晖
Owner ZHUHAI KINGSOFT OFFICE SOFTWARE