Method and terminal for pointing out relative rank and column values in spreadsheet

A technology of spreadsheets and row and column values, applied in the information field, can solve the problems of poor flexibility and inability to provide prompts in spreadsheets, and achieve the effect of enhancing flexibility and improving editing efficiency

Active Publication Date: 2013-10-02
ZHUHAI KINGSOFT OFFICE SOFTWARE +1
View PDF4 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The purpose of the present invention is to overcome the deficiencies in the prior art, provide a method and terminal for determining relative row and column values ​​in an electronic form, and solve the problem in the pri

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 terminal for pointing out relative rank and column values in spreadsheet
  • Method and terminal for pointing out relative rank and column values in spreadsheet
  • Method and terminal for pointing out relative rank and column values in spreadsheet

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0026] figure 1 It is a flow chart of the method of Embodiment 1 of the present invention, such as figure 1 As shown, the method includes:

[0027] S101. The terminal monitors the input command, and obtains the input table area parameter and relative position information parameter, and the relative position information parameter is a relative row label value, or a relative column label value, or a relative row label value and a relative column label value;

[0028] The terminal monitors the user's input instruction, and obtains the form area parameters and relative position information parameters input by the user. Among them, the table area parameter represents a user-defined table area, and the table area is composed of multiple cells, and each cell has its specific row and column label value. The table area parameter is in a fixed format, for example: "D5:O14", which means that in the table area, the upper left cell's position information is "D5", that is, the row label i...

Embodiment 2

[0107] image 3 is the composition diagram of the terminal in Embodiment 2 of the present invention, such as image 3 As shown, the terminal includes:

[0108] The acquisition unit 701 is used to monitor the input instruction, and acquire the input table area parameters and relative position information parameters, the relative position information parameters are relative row label values, or relative column label values, or relative row label values ​​and relative column label values value;

[0109] A determining unit 702, configured to read the selection area corresponding to the table area parameter, determine the relative position information within the selection area and the absolute position information corresponding to the relative position information, the absolute position information includes an absolute column label value , or an absolute column label value, or an absolute row label value and an absolute column label value;

[0110] A judging unit 703, configured...

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 method for pointing out relative rank and column values in a spreadsheet. The method for pointing out the relative rank and column values in the spreadsheet comprises the following steps that a terminal obtains input relative position information parameters and sheet area parameters, the terminal determines relative position information in a selected area and absolute position information corresponding to the relative position information, and the terminal converts the relative position information into absolute position information and displays the absolute position information as a prompt message. Correspondingly, the invention further provides the terminal for determining the position information of a designated area in the spreadsheet. The method and terminal for pointing out the relative rank and column values in the spreadsheet has the advantages that the problem that the spreadsheet is poor in flexibility due to the fact that a prompt message of the relative rank and column values cannot be provided in the prior art is solved, the flexibility of the spreadsheet is improved, and the editing efficiency of the spreadsheet is improved.

Description

technical field [0001] The invention relates to the field of information technology, in particular to a method and a terminal for prompting relative row and column values ​​in an electronic form. Background technique [0002] In spreadsheet files, functions are the most commonly used and most useful tools, which can help users return the required calculation results in a portable manner. There are many types of functions, and there are many functions that need to determine the position information of rows and columns in spreadsheet files. For example, functions such as Vlookup, Hlookup, Offset, Index, Dget, DSum, DAverage, DMin, DMax, DStdev, and Dvar all require The user gives the relative row and column information value when using it. [0003] Some functions need to provide the location information of the specified area when inputting, but at this time, the row number and column label on the worksheet cannot provide such convenience. Take the Vlookup function as an exam...

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
IPC IPC(8): G06F17/24
Inventor 王晖张伶俐景奇
Owner ZHUHAI KINGSOFT OFFICE SOFTWARE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap