CN102243624A - Several new functions of spreadsheet - Google Patents
Several new functions of spreadsheet Download PDFInfo
- Publication number
- CN102243624A CN102243624A CN2010105286933A CN201010528693A CN102243624A CN 102243624 A CN102243624 A CN 102243624A CN 2010105286933 A CN2010105286933 A CN 2010105286933A CN 201010528693 A CN201010528693 A CN 201010528693A CN 102243624 A CN102243624 A CN 102243624A
- Authority
- CN
- China
- Prior art keywords
- cell
- row
- several new
- line number
- electrical form
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Landscapes
- User Interface Of Digital Computer (AREA)
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
The invention belongs to computer office software.
Background technology
The user of form Excel or Wps of using a computer at present is more and more many, and these softwares are reduced to the operation of simple mouse menu to the function that needs the complex operations of database processing, greatly facilitate layman's use.But people have also found some defectives and inconvenience when using these softwares.Line number such as the cell of Excel2003 acquiescence is 65536, at most and minimum all is these numbers, for some data, such as the maximum hundreds ofs of address list capable be a waste, and use inadequately for the user of some big data; Excel2007 is increased to more than 100 ten thousand to line number quickly, though solved the not enough disadvantage of data cells, has brought new problem, only opens the document of very little a excel2007, needs the long period, is a serious waste to computer resource.Be exactly the merging, English character and the Chinese character that lack cell and the deletion of numeric character in addition, the number of times screening that occurs according to number of characters etc. function; These functions are through commonly used.
Summary of the invention
Purpose of the present invention is exactly these are commonly used but the function that did not have originally is increased in the electrical form, and is user-friendly.The form of the logical plug-in unit of the present invention is loaded into general software Excel or Wps; The present invention can be user-friendly to, and improves office efficiency.
Description of drawings
Fig. 1 is a dialogue block diagram of the present invention
Embodiment
Engage concrete real example in detail below:
1 mouse selected cell lattice A row, B row are clicked right button.Eject the dialog box of Fig. 1, choose " Merge Cells ", A row, B row are merged into row.2 choose the dialog box of " line number is set at 10000,20000...1,000,000 ", click is selected " behind 20000 row, line number increases or 20000.
The dialog box of " deleting 2. 3. 4. symbol of numeral of Chinese character of 1. English character " appears in 3 a mouse click right buttons, and the item number that mouse is chosen comprises that content selected is all deleted in the cell, and other guide is constant; Once can only select content one time.
4 choose cell the time, a mouse click right button, occur " number of times of the identical appearance of screening content: 2,3,4, 〉=5 cell; Mouse is chosen item number wherein, and cell content is selected.
Claims (5)
1. several new function of electrical form, it is characterized in that: it be at present general electrical form such as softwares such as excel or WPS on, the line number that has increased merging, the form of cell can self-definedly be determined, the deletion of English Chinese character and numeric character, the number of times screening function that occurs according to number of characters.
2. several new function of electrical form according to claim 1, it is characterized in that, when 2 row in elected or multiple row cell, a mouse click right button, the dialog box that " row that merging is chosen " occur, after the click " affirmation ", 2 row or the multiple row cell chosen are merged into row, and the content of cell originally is constant.
3. several new function of electrical form according to claim 1, it is characterized in that, the acquiescence line number of newly-established electrical form is 10,000, when clicking the mouse right button, the dialog box of " choose the line number of row is set at 10000,20000...1,000; 000 " appears, click is selected " after the line number, line number increases or reduces to the line number of setting, and the minimum number that line number increases or reduces is 10000.
4. several new function of electrical form according to claim 1, when it is characterized in that to the cell chosen, a mouse click right button, the dialog box that " deleting 2. 3. 4. symbol of numeral of Chinese character of 1. English character " occur, the item number that mouse is chosen, what cell was interior comprises that content selected is all deleted, and other guide is constant; Once can only select content one time.
2,3,4 5. several new function of electrical form according to claim 1, when it is characterized in that to the cell chosen, a mouse click right button, occur " number of times of the identical appearance of screening content:, 〉=5 cell; Mouse is chosen item number wherein, and cell content is selected.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010105286933A CN102243624A (en) | 2010-11-02 | 2010-11-02 | Several new functions of spreadsheet |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010105286933A CN102243624A (en) | 2010-11-02 | 2010-11-02 | Several new functions of spreadsheet |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102243624A true CN102243624A (en) | 2011-11-16 |
Family
ID=44961687
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010105286933A Pending CN102243624A (en) | 2010-11-02 | 2010-11-02 | Several new functions of spreadsheet |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102243624A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102902659A (en) * | 2012-09-18 | 2013-01-30 | 珠海金山办公软件有限公司 | Method and terminal for processing numeric character strings in electronic form |
| CN107436918A (en) * | 2017-06-19 | 2017-12-05 | 阿里巴巴集团控股有限公司 | Database implementation method, device and equipment |
| US9996518B2 (en) | 2016-08-08 | 2018-06-12 | International Business Machines Corporation | Inserting new elements in a tabular data structure |
| CN111444689A (en) * | 2020-06-17 | 2020-07-24 | 广州市玄武无线科技股份有限公司 | Data-based table cell merging method and system |
-
2010
- 2010-11-02 CN CN2010105286933A patent/CN102243624A/en active Pending
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102902659A (en) * | 2012-09-18 | 2013-01-30 | 珠海金山办公软件有限公司 | Method and terminal for processing numeric character strings in electronic form |
| US9996518B2 (en) | 2016-08-08 | 2018-06-12 | International Business Machines Corporation | Inserting new elements in a tabular data structure |
| US10025768B2 (en) | 2016-08-08 | 2018-07-17 | International Business Machines Corporation | Inserting new elements in a tabular data structure |
| US10204094B2 (en) | 2016-08-08 | 2019-02-12 | International Business Machines Corporation | Inserting new elements in a tabular data structure |
| CN107436918A (en) * | 2017-06-19 | 2017-12-05 | 阿里巴巴集团控股有限公司 | Database implementation method, device and equipment |
| CN107436918B (en) * | 2017-06-19 | 2020-08-11 | 阿里巴巴集团控股有限公司 | Database implementation method, device and equipment |
| CN111444689A (en) * | 2020-06-17 | 2020-07-24 | 广州市玄武无线科技股份有限公司 | Data-based table cell merging method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101639765B (en) | Method for efficient print operations | |
| CN105468364A (en) | Processing method for notification messages of application programs and mobile terminal | |
| CN105068726B (en) | Information processing method and terminal | |
| CN107193476B (en) | Information input method and device, computer equipment and readable medium | |
| CN104881211A (en) | Folder classifying method, system and mobile terminal | |
| CN102323873B (en) | In order to trigger the method and system that icon is replied in instant messaging | |
| CN101504585B (en) | Sliding type input method of touch screen | |
| CN103914441A (en) | Method for editing files on touch screens through gestures | |
| CN103869931A (en) | Method and device for controlling user interface through voice | |
| CN102243624A (en) | Several new functions of spreadsheet | |
| CN102591471A (en) | Method and device for rapidly inputting emoticons | |
| CN110889056B (en) | Page marking method and device | |
| CN104536768A (en) | Method for improving user-friendly operation of software user interface | |
| CN103365637A (en) | Desktop icon management method and system | |
| CN105183347A (en) | Input method operation method and electronic terminal | |
| CN102937948A (en) | Image-text data editing method for mobile terminal | |
| JP2017045238A (en) | Information processing system, information processing device, and information processing method | |
| EP3975010A1 (en) | Online collaborative document processing method and device | |
| CN111338556B (en) | Input method, input device, terminal equipment and storage medium | |
| CN202067243U (en) | Touch display system for imitating mouse button by fingerprint identification | |
| CN103885787A (en) | Hierarchical design method and device of operational orders | |
| CN202025295U (en) | Device for rapidly inputting emoticons | |
| CN104715010A (en) | Method, terminal and system for calling out associated data through characters | |
| CN103713836A (en) | Method for unlocking screen by aid of multiple contacts | |
| CN107977154A (en) | A kind of file management system under touch-control state |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| DD01 | Delivery of document by public notice |
Addressee: Siyang Tianqin Software Technology Co., Ltd. Document name: Notification of before Expiration of Request of Examination as to Substance |
|
| DD01 | Delivery of document by public notice |
Addressee: Zhou Ge Document name: Notification that Application Deemed to be Withdrawn |
|
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20111116 |