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

Method and terminal for screening columns in spreadsheet

A spreadsheet and terminal technology, which is applied in the fields of electrical digital data processing, instruments, calculations, etc., and can solve the problems of cumbersome and easy operation errors.

Pending Publication Date: 2020-05-05
ZHUHAI KINGSOFT OFFICE SOFTWARE +2
View PDF3 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This process is very cumbersome, especially when there are many columns and the columns to be viewed are scattered, it is easy to make mistakes

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 screening columns in spreadsheet
  • Method and terminal for screening columns in spreadsheet
  • Method and terminal for screening columns in spreadsheet

Examples

Experimental program
Comparison scheme
Effect test

Embodiment approach

[0050] As an implementation, the above method further includes: after selecting the title to be displayed from the extracted titles, saving the selected title to be displayed as a history column screening record, which is convenient for later reuse, and figure 2 Take the table shown as an example, the saved history column filter records can be as follows Figure 6 As shown, the saved historical filtering records can be all historical filtering records; the user can also further manually filter all the saved historical filtering records, so the final saved historical filtering records can also be part of the historical filtering records filtered by the user.

[0051] As an implementation, the above method also includes:

[0052]After the titles are extracted from the title row of the spreadsheet, the titles containing the keywords are searched from the extracted titles by keywords, and the titles to be displayed are selected from the searched titles containing the keywords. W...

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 discloses a method and a terminal for screening columns in a spreadsheet, and the method comprises the steps: extracting a title from a title line of the spreadsheet; selecting a title to be displayed from the extracted titles; and displaying the column corresponding to the selected title, and hiding the column corresponding to the unselected title. According to the method, the columns to be displayed in the spreadsheet can be automatically and conveniently screened.

Description

technical field [0001] The invention relates to an electronic form editing technology, in particular to a method and a terminal for screening columns in an electronic form. Background technique [0002] Today, the spreadsheets exported by the system contain more and more information, so it is no surprise that the number of columns in the spreadsheet may have dozens, hundreds, or even hundreds of columns. A spreadsheet can record all kinds of information as comprehensively as possible through so many columns, but data users often only need to view a part of the column content. [0003] At present, if a data user wants to view certain columns of information in a large spreadsheet, they can only manually select the columns that do not need to be viewed block by block, and then hide them. This process is very cumbersome, especially when there are many columns and the columns to be viewed are scattered, and it is easy to make mistakes. Contents of the invention [0004] In or...

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): G06F40/177G06F40/174G06F40/258
Inventor 陈波陆斐超何文甲
Owner ZHUHAI KINGSOFT OFFICE SOFTWARE