Several new functions of spreadsheet

Abstract

The invention discloses several new functions of a spreadsheet. On the basis of the currently general spreadsheet software such as excel or wps and the like, several new functions of combining cells, increasing lines of the spreadsheet, deleting English characters, Chinese characters and numeric characters, screening according to occurrence number of characters and the like are added. According to the new functions disclosed by the invention, service efficiency of a user can be improved, and unnecessary space waste of the spreadsheet is reduced.

Description

technical field [0001] The invention belongs to computer office software. Background technique [0002] At present, there are more and more users using computer tables Excel or Wps. These software simplify the functions of complex operations that require database processing into simple mouse menu operations, which greatly facilitates the use of non-professionals. But when people use these softwares, they also find some defects and inconveniences. For example, the default number of rows in a cell in Excel2003 is 65536, which is the maximum and minimum number. For some data, such as address book, the maximum number of hundreds of rows is a waste, but it is not enough for some users with large data; It suddenly increased to more than 1 million. Although it solved the problem of insufficient data cells, it brought new problems. It took a long time to open only a small excel2007 document, which was a serious waste of computer resources. There is also a lack of functions such as...

AI Technical Summary

Problems solved by technology

However, when people use these software, they also find some defects and inconveniences

For example, the default number of rows in a cell in Excel2003 is 65536, which is the maximum and minimum number. For some data, such as address book, the maximum number of hundreds of rows is a waste, but it is not enough for some users with large data; It suddenly increased to more than 1 million. Although it solved the problem of insufficient data cells, it brought new problems. It takes a long time to open only a small excel2007 document, which is a serious waste of computer resources.

There is also a lack of functions such as merging of cells, deletion of English characters and Chinese characters and number symbols, and filtering according to the number of occurrences of the number of characters; these functions are often used

Images