CN102855228A - Processing method and terminal for numeric strings in cell - Google Patents
Processing method and terminal for numeric strings in cell Download PDFInfo
- Publication number
- CN102855228A CN102855228A CN201210348981XA CN201210348981A CN102855228A CN 102855228 A CN102855228 A CN 102855228A CN 201210348981X A CN201210348981X A CN 201210348981XA CN 201210348981 A CN201210348981 A CN 201210348981A CN 102855228 A CN102855228 A CN 102855228A
- Authority
- CN
- China
- Prior art keywords
- character string
- numeric character
- cell
- length
- numeric
- 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.)
- Granted
Links
Images
Landscapes
- Machine Translation (AREA)
Abstract
The invention discloses a processing method for numeric strings in a cell. The processing method includes receiving a numeric string input in a cell by a user; detecting the length of the numeric string after receiving an input completion instruction of the numeric string; and displaying each character in the numeric string in the cell when the length of the numeric string is detected to be not smaller than a preset length threshold. According to the technical scheme, all the input numeric characters in the numeric string can be displayed in the cell.
Description
Technical field
The present invention relates to electronic technology field, be specifically related to disposal route and the terminal of numeric character string in a kind of cell.
Background technology
Often run into the numeric character strings more than 15 or 15 such as in electronic form unit grid, inputting ID (identity number) card No., bank's card number, supermarket card number, student number in the work.These numeric character strings show with " science counting " form after input, and the numeral after 15 becomes 0.
The scheme of prior art can't show all numeric characters in the numeric character string of inputting in electronic form unit grid.
Summary of the invention
The embodiment of the invention provides the disposal route of numeric character string in a kind of cell, can show all numeric characters in the numeric character string of inputting in cell.
Embodiment of the invention first aspect provides the disposal route of numeric character string in a kind of cell, comprising:
Receive the numeric character string that the user inputs in cell;
After instruction is finished in the input that receives described numeric character string, detect the length of described numeric character string;
When the length that detects described numeric character string during more than or equal to the presetting length thresholding, in described cell, show each character in the described numeric character string.
In conjunction with first aspect, in the possible implementation of the first, described length when detecting described numeric character string shows each character in the described numeric character string during more than or equal to the presetting length thresholding in described cell, specifically comprise:
When the length of described numeric character string more than or equal to the presetting length thresholding, and during greater than 15, in described cell, show each character in the described numeric character string with text formatting.
In conjunction with first aspect, in the possible implementation of the second, described length when detecting described numeric character string shows each character in the described numeric character string during more than or equal to the presetting length thresholding in described cell, specifically comprise:
When the length of described numeric character string more than or equal to the presetting length thresholding, and greater than 11 and during less than or equal to 15, in described cell, show each character in the described numeric character string with numeric format.
In conjunction with first aspect, first aspect the first or the possible implementation of the second, in the third possible implementation, described disposal route also comprises:
Receive described presetting length thresholding modify instruction;
Reset described presetting length thresholding.
Embodiment of the invention second aspect provides a kind of terminal, comprising:
Receiving element be used for to receive numeric character string that the user inputs at cell and the input of described numeric character string and finishes instruction;
Detecting unit is used for detecting the length of described numeric character string after instruction is finished in the input that described receiving element receives described numeric character string;
Display unit, the length that is used for detecting described numeric character string when described detecting unit be during more than or equal to the presetting length thresholding, each character in described cell in the described numeric character string of demonstration.
In conjunction with second aspect, in the possible implementation of the first,
Described display unit, the concrete length that is used for detecting described numeric character string when described detecting unit be more than or equal to the presetting length thresholding, and during greater than 15, shows each character in the described numeric character string with text formatting in described cell.
In conjunction with second aspect, in the possible implementation of the second,
Described display unit, concrete being used for detects the length of described numeric character string more than or equal to the presetting length thresholding when described detecting unit, and greater than 11 and during less than or equal to 15, in described cell, show each character in the described numeric character string with numeric format.
In conjunction with second aspect, second aspect the first or the possible implementation of the second, in the third possible implementation,
Described terminal also comprises reset cell,
Described receiving element is used for receiving described presetting length thresholding modify instruction;
Described reset cell is used for resetting described presetting length thresholding after described receiving element receives described presetting length thresholding modify instruction.
The embodiment of the invention adopts and receive the numeric character string that the user inputs in cell; After instruction is finished in the input that receives described numeric character string, detect the length of described numeric character string; When the length that detects described numeric character string during more than or equal to the presetting length thresholding, in described cell, show each character in the described numeric character string.When input during several numeric character, just can't show all that all numeric characters in the numeric character string of input are compared compared with prior art, the disposal route that the embodiment of the invention provides can be with the whole complete demonstrations of the numeric character string in the cell.
Description of drawings
Fig. 1 is an embodiment synoptic diagram of the disposal route of the numeric character string that provides of the embodiment of the invention;
Fig. 2 is an embodiment synoptic diagram of the terminal that provides of the embodiment of the invention;
Fig. 3 is another embodiment synoptic diagram of the terminal that provides of the embodiment of the invention.
Embodiment
The embodiment of the invention provides the disposal route of numeric character string in a kind of cell, can be with the whole complete demonstrations of the numeric character string in the cell.The embodiment of the invention also provides corresponding terminal.Below be elaborated respectively.
Consult Fig. 1, an embodiment of the disposal route of numeric character string comprises in the cell that this law embodiment provides:
101, receive the numeric character string that the user inputs in cell.
102, after instruction is finished in the input that receives described numeric character string, detect the length of described numeric character string.
After a character string input is finished, the user knocks enter key, terminal will receive an input and finish instruction, after receiving numeric character string input and finishing instruction, terminal can detect the length of this numeric character string, in the embodiment of the invention, the length of numeric character string refers to the figure place of numeric character string, is 15 such as the length of numerical value character string 123456789123456.
103, when the length that detects described numeric character string during more than or equal to the presetting length thresholding, in described cell, show each character in the described numeric character string.
Described length when detecting described numeric character string shows each character in the described numeric character string during more than or equal to the presetting length thresholding in described cell, specifically comprise:
When the length of described numeric character string more than or equal to the presetting length thresholding, and during greater than 15, in described cell, show each character in the described numeric character string with text formatting.
In the prior art, when the numeric character of input more than 15, the numeric character that demonstrates in the cell all is 0, reduced the precision of numeric character string, the method that the embodiment of the invention provides, when the length that detects the numeric character string during greater than 15, be text formatting with the format conversion of cell, thereby can guarantee that described numeric character string can show fully.
Described length when detecting described numeric character string shows each character in the described numeric character string during more than or equal to the presetting length thresholding in described cell, specifically comprise:
When the length of described numeric character string more than or equal to the presetting length thresholding, and greater than 11 and during less than or equal to 15, in described cell, show each character in the described numeric character string with numeric format.
In the prior art, when in cell, inputting 12 to 15 numeric character string, all be that form with scientific notation shows from 12 to 15, be unfavorable for that the data in the cell participate in calculating, the method that the embodiment of the invention provides, the length of numeric character string is greater than 11 and during less than or equal to 15, shows with numeric format each character in the described numeric character string can not have influence on calculating.
Numeric character string in the embodiment of the invention is long number value character string, and the figure place of prevailing value character string is all more than 15, and certainly, the embodiment of the invention is not construed as limiting this.
The embodiment of the invention adopts and receive the numeric character string that the user inputs in cell; After instruction is finished in the input that receives described numeric character string, detect the length of described numeric character string; When the length that detects described numeric character string during more than or equal to the presetting length thresholding, in described cell, show each character in the described numeric character string.When input during several numeric character, just can't show all that all numeric characters in the numeric character string of input are compared compared with prior art, the disposal route that the embodiment of the invention provides can be with the whole complete demonstrations of the numeric character string in the cell.
On the basis of above-mentioned optional embodiment, the embodiment of the invention also comprises: receive described presetting length thresholding modify instruction; Reset described presetting length thresholding.
Terminal can be revised the presetting length thresholding in the embodiment of the invention, when terminal receives described presetting length thresholding modify instruction; Reset described presetting length thresholding.The presetting length thresholding can arrange voluntarily according to user's demand.
Consult Fig. 2, an embodiment of the terminal that the embodiment of the invention provides comprises: receiving element 201, detecting unit 202 and display unit 203.
Receiving element 201 be used for to receive numeric character string that the user inputs at cell and the input of described numeric character string and finishes instruction;
Detecting unit 202 is used for detecting the length of described numeric character string after instruction is finished in the input that described receiving element 201 receives described numeric character string;
In the embodiment of the invention, instruction is finished in the numeric character string that receiving element 201 reception users input in cell and the input of described numeric character string; Detecting unit 202 detects the length of described numeric character string after instruction is finished in the input that described receiving element 201 receives described numeric character string; The length that display unit 203 detects described numeric character string when described detecting unit 202 shows each character in the described numeric character string during more than or equal to the presetting length thresholding in described cell.Compared with prior art, the terminal that the embodiment of the invention provides can be with the whole complete demonstrations of the numeric character string in the cell.
On the basis of embodiment corresponding to above-mentioned Fig. 2, in the embodiment of the invention,
Described display unit 203, the concrete length that is used for detecting described numeric character string when described detecting unit 202 be more than or equal to the presetting length thresholding, and during greater than 15, shows each character in the described numeric character string with text formatting in described cell.
On the basis of embodiment corresponding to above-mentioned Fig. 2, in the embodiment of the invention,
Described display unit 203, concrete being used for detects the length of described numeric character string more than or equal to the presetting length thresholding when described detecting unit 202, and greater than 11 and during less than or equal to 15, in described cell, show each character in the described numeric character string with numeric format.
On the basis of optional embodiment corresponding to embodiment corresponding to above-mentioned Fig. 2 and Fig. 2, consult Fig. 3, among another embodiment of the terminal that the embodiment of the invention provides, also comprise reset cell 204;
Described receiving element 201 is used for receiving described presetting length thresholding modify instruction;
Described reset cell 204 is used for resetting described presetting length thresholding after described receiving element 201 receives described presetting length thresholding modify instruction.
One of ordinary skill in the art will appreciate that all or part of step in the whole bag of tricks of above-described embodiment is to come the relevant hardware of instruction finish by program, this program can be stored in the computer-readable recording medium, and storage medium can comprise: ROM, RAM, disk or CD etc.
More than in the cell that the embodiment of the invention is provided disposal route and the terminal of numeric character string be described in detail, used specific case herein principle of the present invention and embodiment are set forth, the explanation of above embodiment just is used for helping to understand method of the present invention and core concept thereof; Simultaneously, for one of ordinary skill in the art, according to thought of the present invention, all will change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention.
Claims (8)
1. the disposal route of numeric character string in the cell is characterized in that, comprising:
Receive the numeric character string that the user inputs in cell;
After instruction is finished in the input that receives described numeric character string, detect the length of described numeric character string;
When the length that detects described numeric character string during more than or equal to the presetting length thresholding, in described cell, show each character in the described numeric character string.
2. disposal route according to claim 1 is characterized in that, described length when detecting described numeric character string shows each character in the described numeric character string during more than or equal to the presetting length thresholding in described cell, specifically comprise:
When the length of described numeric character string more than or equal to the presetting length thresholding, and during greater than 15, in described cell, show each character in the described numeric character string with text formatting.
3. disposal route according to claim 1 is characterized in that, described length when detecting described numeric character string shows each character in the described numeric character string during more than or equal to the presetting length thresholding in described cell, specifically comprise:
When the length of described numeric character string more than or equal to the presetting length thresholding, and greater than 11 and during less than or equal to 15, in described cell, show each character in the described numeric character string with numeric format.
4. the described disposal route of any one is characterized in that according to claim 1 ~ 3, and described disposal route also comprises:
Receive described presetting length thresholding modify instruction;
Reset described presetting length thresholding.
5. a terminal is characterized in that, comprising:
Receiving element be used for to receive numeric character string that the user inputs at cell and the input of described numeric character string and finishes instruction;
Detecting unit is used for detecting the length of described numeric character string after instruction is finished in the input that described receiving element receives described numeric character string;
Display unit, the length that is used for detecting described numeric character string when described detecting unit be during more than or equal to the presetting length thresholding, each character in described cell in the described numeric character string of demonstration.
6. terminal according to claim 5 is characterized in that,
Described display unit, the concrete length that is used for detecting described numeric character string when described detecting unit be more than or equal to the presetting length thresholding, and during greater than 15, shows each character in the described numeric character string with text formatting in described cell.
7. terminal according to claim 5 is characterized in that,
Described display unit, concrete being used for detects the length of described numeric character string more than or equal to the presetting length thresholding when described detecting unit, and greater than 11 and during less than or equal to 15, in described cell, show each character in the described numeric character string with numeric format.
8. the described terminal of any one is characterized in that according to claim 5 ~ 7, and described terminal also comprises reset cell,
Described receiving element is used for receiving described presetting length thresholding modify instruction;
Described reset cell is used for resetting described presetting length thresholding after described receiving element receives described presetting length thresholding modify instruction.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210348981.XA CN102855228B (en) | 2012-09-18 | 2012-09-18 | The disposal route of numeric character string and treating apparatus in cell |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210348981.XA CN102855228B (en) | 2012-09-18 | 2012-09-18 | The disposal route of numeric character string and treating apparatus in cell |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102855228A true CN102855228A (en) | 2013-01-02 |
| CN102855228B CN102855228B (en) | 2016-03-30 |
Family
ID=47401822
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210348981.XA Active CN102855228B (en) | 2012-09-18 | 2012-09-18 | The disposal route of numeric character string and treating apparatus in cell |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102855228B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106445481A (en) * | 2015-08-12 | 2017-02-22 | 北京国双科技有限公司 | Data generation method and apparatus |
| CN106557452A (en) * | 2015-09-25 | 2017-04-05 | 阿里巴巴集团控股有限公司 | For the display packing of numeric character or character string, device, equipment and system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1161499A (en) * | 1996-01-05 | 1997-10-08 | 株式会社吉姆帝王 | Device and method for processing letters and marks information |
| JPH09305601A (en) * | 1996-05-17 | 1997-11-28 | Canon Inc | Method and device for processing character and graphic |
| JPH1049528A (en) * | 1996-08-07 | 1998-02-20 | Niigata Nippon Denki Software Kk | Automatic agate setting method and system therefor |
-
2012
- 2012-09-18 CN CN201210348981.XA patent/CN102855228B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1161499A (en) * | 1996-01-05 | 1997-10-08 | 株式会社吉姆帝王 | Device and method for processing letters and marks information |
| JPH09305601A (en) * | 1996-05-17 | 1997-11-28 | Canon Inc | Method and device for processing character and graphic |
| JPH1049528A (en) * | 1996-08-07 | 1998-02-20 | Niigata Nippon Denki Software Kk | Automatic agate setting method and system therefor |
Non-Patent Citations (3)
| Title |
|---|
| 侯雪莲等: "巧用Excel中的"条件格式"和"公式"", 《电脑知识与技术》, vol. 6, no. 7, 5 March 2010 (2010-03-05), pages 1712 - 1713 * |
| 张卓: "高效率办公手把手(六)-财务Excel篇(二)", 《微电脑世界》, no. 4, 10 March 2007 (2007-03-10), pages 153 - 155 * |
| 钟阳春: "正确导入新一代身份证号码的解决方案", 《办公自动化》, 23 September 2008 (2008-09-23), pages 55 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106445481A (en) * | 2015-08-12 | 2017-02-22 | 北京国双科技有限公司 | Data generation method and apparatus |
| CN106557452A (en) * | 2015-09-25 | 2017-04-05 | 阿里巴巴集团控股有限公司 | For the display packing of numeric character or character string, device, equipment and system |
| CN106557452B (en) * | 2015-09-25 | 2020-08-11 | 阿里巴巴集团控股有限公司 | Display method, device, equipment and system for numerical characters or character strings |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102855228B (en) | 2016-03-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8782549B2 (en) | Incremental feature-based gesture-keyboard decoding | |
| CN104169909B (en) | Context resolution device and context resolution method | |
| CN105122185A (en) | Text suggestion output using past interaction data | |
| RU2014129212A (en) | METHOD AND DEVICE OF INPUT PROCESSING | |
| CN102629160A (en) | Input method, input device and terminal | |
| CN105164616A (en) | Consistent text suggestion output | |
| CN103914209B (en) | A kind of information processing method and electronic equipment | |
| CN102411432A (en) | Binary syllabification input method of Chinese characters | |
| CN105512256A (en) | Method and device for pushing lecturer information | |
| US8908972B2 (en) | Electronic device capable of recovering garbled characters and method for recovering garbled characters | |
| CN106601256B (en) | The method and mobile terminal of speech recognition | |
| CN102929394B (en) | A kind of Braille input method based on gesture identification | |
| CN104298654A (en) | Method and device for displaying information | |
| CN103577388A (en) | Excel template based data processing method and device | |
| JP5619979B2 (en) | Electronic device including a mind map user interface, and a mind map creation method using the same | |
| CN103649944B (en) | Chinese word input unit and method | |
| CN102855228A (en) | Processing method and terminal for numeric strings in cell | |
| CN103049082A (en) | Braille input method suitable for touch panel | |
| CN102707811B (en) | A kind of method and system of Chinese charater input | |
| CN105700704A (en) | Method and device for inputting characters to mini-size screen | |
| CN102902659B (en) | The processing method of numeric character string and terminal in electrical form | |
| JP6060039B2 (en) | Specific point name determination device, specific point name determination method, and specific point name determination program | |
| CN109727591B (en) | Voice search method and device | |
| CN102929850A (en) | Report data processing device and report data processing method | |
| KR20110112116A (en) | Searching method and system based on topic |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C56 | Change in the name or address of the patentee | ||
| CP01 | Change in the name or title of a patent holder |
Address after: Jinshan software building No. 8 Jingshan Hill Road, Lane 519015 Lianshan Jida Zhuhai city in Guangdong Province Patentee after: Zhuhai Kingsoft Office Software Co., Ltd. Patentee after: Beijing Kingsoft office software Limited by Share Ltd Address before: Jinshan software building No. 8 Jingshan Hill Road, Lane 519015 Lianshan Jida Zhuhai city in Guangdong Province Patentee before: Zhuhai Kingsoft Office Software Co., Ltd. Patentee before: Beijing Kingsoft WPS Office Co., Ltd. |