CN102981706B - Formula quoting switching method and apparatus, mobile device - Google Patents
Formula quoting switching method and apparatus, mobile device Download PDFInfo
- Publication number
- CN102981706B CN102981706B CN201210454115.9A CN201210454115A CN102981706B CN 102981706 B CN102981706 B CN 102981706B CN 201210454115 A CN201210454115 A CN 201210454115A CN 102981706 B CN102981706 B CN 102981706B
- Authority
- CN
- China
- Prior art keywords
- reference type
- cell
- quoting
- region
- window
- 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.)
- Active
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention provides a kind of can be applicable to mobile device formula quoting changing method, formula quoting switching device shifter and there is the mobile device of formula quoting switching device shifter, its formula quoting changing method comprises step: when the trigger action of cell reference button being detected, in electrical form, region is quoted in location, and judges that whether described cell reference button is selected; If so, the reference type list that region display is corresponding is quoted described in basis; If not, then described cell reference button is chosen.The present invention switches formula quoting type quickly and easily, intuitively easy to operate, and realizes the switching of formula quoting type rapidly, also perfect spreadsheet systems, and improves the efficiency of user operation electrical form.
Description
Technical field
The present invention relates to mobile device technical field, particularly relate to a kind of formula quoting switching method and apparatus, mobile device.
Background technology
For a electronic form document, the row, column information of cell is a center-stage feedback information.Electrical form highlights its advantage because completing a large amount of calculating, calculate and just need numerical value, and numerical value correspond to certain cell, find the numerical value of cell just first must find the row, column positional information of cell, so in formula, the row, column positional information of precedents just becomes of crucial importance.
At PC (personalcomputer, people's computing machine) on, the Excel of Microsoft provides this shortcut of F4 and switches formula quoting mode, formula " absolute reference " is realized by pressing f4 shortcut, the switching of " mixing is quoted " and " rdative quotation " state, facilitate user and switch quoting of formula fast, but this design may need repeatedly to switch just can complete between target way of reference and former way of reference, be not suitable for mobile device, this is because without corresponding shortcut on mobile device, if utilize the Macintosh replacement on mobile device can increase the complexity of operation and the threshold of use, repeatedly trigger simultaneously or press the mode of some particular key, easily cause and grasping by mistake.
Summary of the invention
The object of the present invention is to provide a kind of can be applicable to mobile device formula quoting changing method, formula quoting switching device shifter and there is the mobile device of formula quoting switching device shifter.
Object of the present invention is achieved through the following technical solutions:
A kind of formula quoting changing method, comprises the steps:
When the trigger action of cell reference button being detected, in electrical form, region is quoted in location, and judges that whether described cell reference button is selected;
If so, the reference type list that region display is corresponding is quoted described in basis;
If not, then described cell reference button is chosen.
A kind of formula quoting switching device shifter, comprises the steps:
Detection module, quotes the trigger action of button for detecting unit lattice, when the trigger action of cell reference button being detected, sending decision instruction to judge module, sending positioning instruction to locating module;
Judge module, for when receiving described decision instruction, judges that whether described cell reference button is selected;
Locating module, during for receiving described positioning instruction, in electrical form, region is quoted in location;
Display module, for quoting reference type list corresponding to region display described in basis;
Choose module, for choosing described cell reference button when the result of determination of described judge module is no.
A kind of mobile device, comprises formula quoting switching device shifter as above.
According to the scheme of the invention described above, after user triggers cell reference button, the present invention program detects the trigger action of this cell reference button, in electrical form, region is quoted in location, and judge that whether this cell reference button is selected, if not, then choose this cell reference button, if, then quote region and show corresponding reference type list according to this automatically and for user, reference type is switched, when user needs to switch formula quoting type, only need to choose required reference type in reference type list, thus can facilitate, switch formula quoting type quickly, which is intuitively easy to operate, and user realizes the switching of formula quoting type rapidly, also perfect spreadsheet systems, and improve the efficiency of user operation electrical form.
Accompanying drawing explanation
Fig. 1 is the schematic flow sheet of formula quoting changing method embodiment of the present invention;
Fig. 2 is the picture view under a kind of mode of Second Window;
Fig. 3 is the picture view under the another kind of mode of Second Window;
Fig. 4 is the structural representation of the system of formula quoting changing method embodiment of the present invention;
Fig. 5 is the structural representation of display module in Fig. 4;
Fig. 6 is the structural representation of the system of another embodiment of formula quoting changing method of the present invention.
Embodiment
Below in conjunction with embodiment and accompanying drawing, the present invention will be described in detail, but embodiments of the present invention are not limited thereto.
Embodiment 1
Shown in Figure 1, be the schematic flow sheet of formula quoting changing method embodiment of the present invention.As shown in Figure 1, the formula quoting changing method in the present embodiment comprises the steps:
Step S101: whether detecting unit lattice are quoted button and be triggered, when the trigger action of this cell reference button being detected, enter step S102, wherein, need pre-defined cell reference button, and on operation interface, show this cell reference button, define and detect this cell reference button and whether be triggered and can adopt existing mode to realize, do not repeat them here;
Step S102: region is quoted in location in electrical form, enters step S103, wherein, location is quoted region and can be adopted existing mode to realize, and does not repeat them here;
Step S103: and judge that whether described cell reference button is selected, if so, enter step S104, if not, enter step S105;
Step S104: quote reference type list corresponding to region display according to described, reference type list lists the option quoting each reference type in region corresponding to this, chooses for user;
Step S105: choose described cell reference button, namely when cell reference button is not selected, selected after this cell reference button is triggered.
Accordingly, according to the scheme of above-mentioned the present embodiment, after user triggers cell reference button, the present invention program detects the trigger action of this cell reference button, in electrical form, region is quoted in location, and judge that whether described cell reference button is selected, if not, then choose this cell reference button, if the region of quoting according to location shows corresponding reference type list automatically, for user, reference type is switched, when user needs to switch formula quoting type, only need to choose required reference type in reference type list, thus can facilitate, switch formula quoting type quickly, which is intuitively easy to operate, and user realizes the switching of formula quoting type rapidly, also perfect spreadsheet systems, and improve the efficiency of user operation electrical form.
Wherein, in above-mentioned steps, location is quoted region, is judged that the whether selected process of described cell reference button can be do not adopt above-mentioned sequencing, can carry out simultaneously.
The form of reference type list is generally according to being that individual unit lattice are quoted or multiple cell reference (region is quoted) and different, is mainly divided into two kinds of different forms according to both of these case:
If described in quote region and comprise a cell, when namely individual unit lattice are quoted, then display comprises the first window of the reference type list corresponding with this cell, wherein, when individual unit lattice are quoted, reference type generally comprises four kinds, be absolute reference respectively, rdative quotation, mixing quote (two kinds), the reference type as the cell of the D row in corresponding electrical form, the 9th row comprises: D9 (rdative quotation), $ D $ 9 (absolute reference), $ D9 (mixing is quoted) and D $ 9 (mixing is quoted);
If described in quote region and comprise one group and (at least comprise two cells, can be a line or one row also may be rectangle etc.) cell, also when namely region is quoted, then display comprises the Second Window of reference type list corresponding to this group cell, because one group of cell generally at least needs two cells to characterize its position, from aforementioned, the reference type that each cell is corresponding has four kinds, then these two cell reference type combination get up to characterize the reference type quoted in region should 16 kinds, therefore, the reference type that corresponding region is quoted should have 16 kinds at least.
For above-mentioned first window, because reference type is few, directly can demonstrate each reference type to choose for user, real-time detection is only needed whether to have user to trigger the operation of reference type, the reference type be triggered if determine, then carry out reference type switching according to the reference type be triggered, namely current reference type will be switched to the reference type that user triggers.
For above-mentioned Second Window, because needs at least provide 16 kinds of reference types to choose for user, but, the screen size of mobile device is limited, thus the scope of operation interface is also limited, be difficult to realize 16 kinds of reference types to be all presented on this Second Window, common practices, definition scroll bar can be selected, Second Window only shows a part for corresponding reference type list, and move scroll bar according to user and show the different piece of reference type list, but, because reference type is relatively a lot, the scope of operation scroll bar movement is also just very large, inconvenient operation, also easily maloperation is caused, for this problem, the present invention proposes following embodiment.
Wherein in an embodiment, on aforementioned base, the formula quoting changing method of the embodiment of the present invention can also comprise step: when showing Second Window, on described Second Window, display comprises the reference type list of first row list item and secondary series list item, described first row list item quotes reference type corresponding to the start element lattice in region described in listing, described secondary series list item list described in quote reference type corresponding to the end unit lattice in region; And on described Second Window, show the mobile operating portion of corresponding first row list item and secondary series list item respectively, when the action of described mobile operating portion being detected, the option of quoting controlled in corresponding list items moves.Wherein, start element lattice, end unit lattice can specify according to actual conditions, such as, are defined under user faces and quote areas case, being in the cell quoting the upper left corner in region is start element lattice, and being in the cell quoting the lower right corner in region is end unit lattice, Second Window shows the mobile operating portion of corresponding first row list item and secondary series list item respectively, refer to the mobile operating portion of the reference type movement having control two list items respectively, Fig. 2, Fig. 3 shows the mode (for cell A3 to cell A6 for quoting region) that two kinds of mobile operating portions control two list items, shown in Fig. 2 is above shift button (in figure upper triangle) and lower shift button (in the figure time triangle) mode as mobile operating portion, shown in Fig. 3 is with scroll bar the square bar of the left and right sides (in the figure), but be also not limited to this two kinds of modes, because start element lattice and option of quoting corresponding to end unit lattice are divided into two groups, often group only has four reference types, and user can be moved this option of quoting of two groups respectively by the different mobile operating portion of operation, the scope of movement is little, swift to operate, simultaneously, user by operating the mobile operating portion of corresponding first row list item and secondary series list item respectively, can make the reference type independent assortment in two list items, but also can define predeterminated position quote the reference type that option is current selection, as the reference type that the predeterminated position reference type that is corresponding respectively start element lattice in Fig. 2 or Fig. 3 between thick line and end unit lattice is quoted as current region.
In addition, formula quoting changing method wherein in an embodiment can also comprise step: when the trigger action in the region outside described first window/described Second Window being detected, close described first window/described Second Window, this embodiment gives a kind of a kind of implementation triggering first window or Second Window and exit, but be also not limited thereto mode.
Formula quoting changing method of the present invention is preferably applied to mobile device, good application prospect can be had.This is because, along with function constantly perfect of mobile device, user more and more dotes in being completed some daily matters operations by mobile device, and the routine use rate of electrical form is high, also the efficiency that improve user operation electrical form is just badly in need of, and formula quoting changing method of the present invention is easy and simple to handle, operation interface directly perceived, can switch formula quoting type quickly and easily, which is intuitively easy to operate.
According to the solution of the present invention as above, wherein in a specific implementation, so that formula quoting changing method of the present invention is applied to mobile device, this concrete implementation does not form the restriction to the present invention program, and concrete formula quoting changing method can be as described below:
When user operates electrical form on the mobile apparatus, operation interface has default cell reference button, whether associated process can detect this cell reference button in real time and be triggered, if user clicks this cell reference button, this clicking operation is detected as the trigger action of this cell reference button, then in electrical form, region is quoted in location, and judges that whether this cell reference button is selected; When judging that this cell reference button is not selected, choose this cell reference button; When judging that this cell reference button is selected, quote reference type list corresponding to region display according to described;
Before basis quotes reference type list corresponding to region display, first difference is that individual unit lattice are quoted or region is quoted, namely to judge the number quoting cell in region, if individual unit lattice are quoted, then display comprises the first window of the reference type list corresponding with this cell, lists should four kinds of reference types of cell in the reference type list corresponding with this cell; And whether detection in real time has user to trigger the operation of reference type, the reference type be triggered if determine, then carry out reference type switching according to the reference type be triggered; If when the trigger action in the region outside first window being detected, close this first window;
If region is quoted, display comprises the Second Window of reference type list corresponding to this group cell, on this Second Window, display comprises the reference type list of first row list item and secondary series list item, described first row list item quotes reference type corresponding to the start element lattice in region described in listing, described secondary series list item list described in quote reference type corresponding to the end unit lattice in region; And on described Second Window, show the mobile operating portion of corresponding first row list item and secondary series list item respectively, when the action of described mobile operating portion being detected, the option of quoting controlled in corresponding list items moves; If when the trigger action in the region outside Second Window being detected, close Second Window described in this.
Embodiment 2
According to the formula quoting changing method of the invention described above, the present invention also provides a kind of formula quoting switching device shifter.
As shown in Figure 4, be the structural representation of formula quoting switching device shifter embodiment of the present invention, it comprises:
Detection module 201, whether be triggered for detecting default cell reference button, when the trigger action of this cell reference button being detected, send decision instruction to judge module 202, send positioning instruction to locating module 203, wherein, need pre-defined cell reference button, and on operation interface, show this button, defining and detect this button can be adopt existing mode in prior art, does not repeat them here;
Judge module 202, for when receiving described decision instruction, judges that whether described cell reference button is selected;
Locating module 203, quotes region for locating in electrical form when receiving described positioning instruction, and wherein, it can be adopt existing mode in prior art that region is quoted in location, does not repeat them here;
Display module 204, for quoting reference type list corresponding to region display described in basis, reference type list lists the option that correspondence quotes each reference type in region and chooses for user;
Choose module 205, for choosing described cell reference button when the result of determination of described judge module is no, namely when cell reference button is not selected, selected after this button is triggered.
Accordingly, according to the scheme of above-mentioned the present embodiment, after user triggers cell reference button, after detection module 201 detects the trigger action of this cell reference button, judge module 202 judges that whether this cell reference button is selected, if not, module 205 is then chosen to choose this cell reference button, if, then locating module 203 is located and is quoted region in electrical form, display module 204 is quoted region and is shown corresponding reference type list according to this automatically and switch reference type for user, when user needs to switch formula quoting type, only need to choose required reference type in reference type list, thus can facilitate, switch formula quoting type quickly, which is intuitively easy to operate, and user realizes the switching of formula quoting type rapidly, also perfect spreadsheet systems, and improve the efficiency of user operation electrical form.
The form of reference type list is generally according to being that individual unit lattice are quoted or multiple cell reference (region is quoted) and different, is mainly divided into two kinds of different forms according to both of these case.Wherein in an embodiment, as shown in Figure 5, display module 204 can comprise judging unit 301, first display unit 302, second display unit 2043, wherein:
Judging unit 301, comprises a cell or one group of cell for quoting region described in judging;
First display unit 302, for being when comprising a cell in the result of determination of judging unit 301, display comprises the first window of the reference type list corresponding with this cell, wherein, when individual unit lattice are quoted, reference type generally comprises four kinds, be absolute reference respectively, rdative quotation, mixing quote (two kinds), the reference type as the cell of the D row in corresponding electrical form, the 9th row comprises: D9 (rdative quotation), $ D $ 9 (absolute reference), $ D9 (mixing is quoted) and D $ 9 (mixing is quoted);
Second display unit 303, for being when comprising one group of cell in the result of determination of judging unit 301, display comprises the Second Window of the reference type list corresponding with this group cell, because one group of cell generally at least needs two cells to characterize its position, from aforementioned, the reference type that each cell is corresponding has four kinds, then these two cell reference type combination get up to characterize the reference type quoted in region should 16 kinds, therefore, the reference type that corresponding region is quoted should have 16 kinds at least.
Wherein, for the first display unit 302, because reference type is few, directly can demonstrate each reference type to choose for user, as shown in Figure 6, formula quoting switching device shifter of the present invention can also comprise the first control module 206 be connected with the first display unit 302, for when the trigger action of reference type being detected, carry out reference type switching according to the reference type be triggered, namely current reference type will be switched to the reference type that user triggers.
On the other hand, because the second display unit 303 at least needs to provide 16 kinds of reference types to choose for user, but, the screen size of mobile device is limited, thus the scope of operation interface is also limited, be difficult to realize 16 kinds of reference types to be all presented on this Second Window, common practices, definition scroll bar can be selected, Second Window only shows a part for corresponding reference type list, and move scroll bar according to user and show the different piece of reference type list, but, because reference type is relatively a lot, the scope of operation scroll bar movement is also just very large, inconvenient operation, also easily maloperation is caused, for this problem, the present invention proposes following embodiment.
As shown in Figure 7, formula quoting switching device shifter of the present invention can also comprise and to can further include the first list item display unit 401, second list item with the second control module 207, second display unit 303 that the second display unit 303 is connected and show single 402 and mobile operating portion 403 corresponding with the first list item display unit 401, second list item display unit 402 respectively; First list item display unit 401 is for showing first row list item, described first row list item quotes reference type corresponding to the start element lattice in region described in listing, second list item display unit 402 for showing secondary series list item, described first row list item list described in quote reference type corresponding to the end unit lattice in region; Second control module 207 is for when the trigger action of mobile operating portion 403 being detected, and the option of quoting controlled in corresponding list items moves.Wherein, start element lattice, end unit lattice can specify according to actual conditions, such as, are defined under user faces and quote areas case, being in the cell quoting the upper left corner in region is start element lattice, and being in the cell quoting the lower right corner in region is end unit lattice; Mobile operating portion 403 can have the different forms of expression, such as, and upper shift button shown in Figure 2 and lower shift button, or scroll bar shown in Figure 3, or other feasible modes; Because start element lattice and option of quoting corresponding to end unit lattice are divided into two groups, often group only has four reference types, and user can be moved this option of quoting of two groups respectively by the different mobile operating portion of operation, the scope of movement is little, swift to operate, simultaneously, user by operating the mobile operating portion of corresponding first row list item and secondary series list item respectively, can make the reference type independent assortment in two list items; But also can define predeterminated position quote the reference type that option is current selection, as the reference type that the predeterminated position reference type that is corresponding respectively start element lattice in Fig. 2 or Fig. 3 between thick line and end unit lattice is quoted as current region.
In addition, formula quoting switching device shifter wherein in an embodiment, also comprise and exit module, for when the trigger action in the region outside described first window/described Second Window being detected, close described first window/described Second Window, this embodiment gives a kind of a kind of implementation triggering first window or Second Window and exit, but be also not limited thereto mode.
Embodiment 3
According to the formula quoting switching device shifter of the invention described above, the present invention also provides a kind of mobile device, it includes the formula quoting switching device shifter of the invention described above, and this formula quoting switching device shifter application mode in a mobile device can be described above, do not repeat them here.
The above embodiment only have expressed several embodiment of the present invention, and it describes comparatively concrete and detailed, but therefore can not be interpreted as the restriction to the scope of the claims of the present invention.It should be pointed out that for the person of ordinary skill of the art, without departing from the inventive concept of the premise, can also make some distortion and improvement, these all belong to protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be as the criterion with claims.
Claims (9)
1. a formula quoting changing method, is characterized in that, this formula quoting changing method is used for mobile device, and described method comprises the steps:
When the trigger action of cell reference button being detected, in electrical form, region is quoted in location, and judges that whether described cell reference button is selected;
If so, quote the reference type list that region display is corresponding described in basis, described reference type list lists the option quoting each reference type in region corresponding to this, chooses for user;
If not, then described cell reference button is chosen.
2. formula quoting changing method according to claim 1, is characterized in that, the reference type list of quoting region display described in described basis corresponding comprises the steps:
If described in quote region and comprise a cell, then display comprises the first window of the reference type list corresponding with this cell;
If described in quote region and comprise one group of cell, then display comprises the Second Window of the reference type list corresponding with this group cell.
3. formula quoting changing method according to claim 2, is characterized in that:
After the described first window step of display, also comprise step: the trigger action detecting reference type, when after the reference type determining to be triggered, carry out reference type switching according to the reference type be triggered;
Or/and
The Second Window that described display comprises the reference type list corresponding with this group cell comprises step: on described Second Window, show the reference type list comprising first row list item and secondary series list item, described first row list item quotes reference type corresponding to the start element lattice in region described in listing, described secondary series list item quotes reference type corresponding to the end unit lattice in region described in listing, and described Second Window also shows the mobile operating portion of corresponding first row list item and secondary series list item respectively; After this Second Window step of display, also comprise step: when the trigger action of described mobile operating portion being detected, the option of quoting controlled in corresponding list items moves.
4. formula quoting changing method according to claim 2, is characterized in that, when the trigger action in the region outside described first window/described Second Window being detected, closes described first window/described Second Window.
5. a formula quoting switching device shifter, is characterized in that, is applied to mobile device, and described device comprises:
Detection module, quotes the trigger action of button for detecting unit lattice, when the trigger action of cell reference button being detected, sending decision instruction to judge module, sending positioning instruction to locating module;
Judge module, for when receiving described decision instruction, judges that whether described cell reference button is selected;
Locating module, during for receiving described positioning instruction, in electrical form, region is quoted in location;
Display module, for quoting reference type list corresponding to region display described in basis, described reference type list lists the option that correspondence quotes each reference type in region and chooses for user;
Choose module, for choosing described cell reference button when the result of determination of described judge module is no.
6. formula quoting switching device shifter according to claim 5, is characterized in that, described display module comprises:
Judging unit is a cell or one group of cell for quoting region described in judging;
First display unit, for when the result of determination of described judging unit is a cell, display comprises the first window of the reference type list corresponding with this cell;
Second display unit, for when the result of determination of described judging unit is one group of cell, display comprises the Second Window of the reference type list corresponding with this group cell.
7. formula quoting switching device shifter according to claim 6, is characterized in that:
Also comprising the first control module be connected with described first display unit, for when the trigger action of reference type being detected, carrying out reference type switching according to the reference type be triggered;
Or/and
Also comprise the second control module be connected with described second display unit; Described second display unit comprise the first list item display unit, the second list item display unit and respectively with the first list item display unit, mobile operating portion that the second list item display unit is corresponding; First list item display unit is for showing first row list item, described first row list item quotes reference type corresponding to the start element lattice in region described in listing, second list item display unit for showing secondary series list item, described first row list item list described in quote reference type corresponding to the end unit lattice in region; Described second control module is used for when the trigger action of described mobile operating portion being detected, and the option of quoting controlled in corresponding list items moves.
8. the formula quoting switching device shifter according to claim 6 or 7, is characterized in that, also comprises and exits module, for when the trigger action in the region outside described first window/described Second Window being detected, closes described first window/described Second Window.
9. a mobile device, is characterized in that, comprises the formula quoting switching device shifter that one of claim 5 to 8 is described.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210454115.9A CN102981706B (en) | 2012-11-13 | 2012-11-13 | Formula quoting switching method and apparatus, mobile device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210454115.9A CN102981706B (en) | 2012-11-13 | 2012-11-13 | Formula quoting switching method and apparatus, mobile device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102981706A CN102981706A (en) | 2013-03-20 |
| CN102981706B true CN102981706B (en) | 2016-01-13 |
Family
ID=47855805
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210454115.9A Active CN102981706B (en) | 2012-11-13 | 2012-11-13 | Formula quoting switching method and apparatus, mobile device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102981706B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10192329B2 (en) * | 2014-09-19 | 2019-01-29 | Casio Computer Co., Ltd. | Electronic device which displays and outputs function formula data, data output method, and computer readable medium |
| US10599764B2 (en) | 2015-11-02 | 2020-03-24 | Microsoft Technology Licensing, Llc | Operations on images associated with cells in spreadsheets |
| CN108292295B (en) * | 2016-02-01 | 2022-09-30 | 微软技术许可有限责任公司 | Parameterization and processing of mathematical equations in spreadsheet applications |
| CN107506457B (en) * | 2017-08-29 | 2020-10-02 | 姜博 | Data processing method and device |
| CN111859880B (en) * | 2019-04-29 | 2023-06-27 | 珠海金山办公软件有限公司 | Method, system, storage medium and terminal for locating cells |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1755679A (en) * | 2004-09-30 | 2006-04-05 | 微软公司 | Method and implementation for referencing of dynamic data within spreadsheet formulas |
| CN102436498A (en) * | 2011-11-14 | 2012-05-02 | 深圳市华力特电气股份有限公司 | Report form generating method and relative device |
-
2012
- 2012-11-13 CN CN201210454115.9A patent/CN102981706B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1755679A (en) * | 2004-09-30 | 2006-04-05 | 微软公司 | Method and implementation for referencing of dynamic data within spreadsheet formulas |
| CN102436498A (en) * | 2011-11-14 | 2012-05-02 | 深圳市华力特电气股份有限公司 | Report form generating method and relative device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102981706A (en) | 2013-03-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102981706B (en) | Formula quoting switching method and apparatus, mobile device | |
| CN101739204B (en) | Method and device for selecting multiple objects in batches and touch screen terminal | |
| CN103544021B (en) | The screenshotss method and its device of a kind of mobile terminal screen content | |
| CN102946462A (en) | Contact information grouping method based on mobile phone and mobile phone | |
| CN103513870B (en) | The list interface of intelligent terminal selects the method and device of multinomial entry | |
| CN103561338B (en) | Instruction mode switching method and device based on intelligent television interface | |
| CN105426082B (en) | A kind of application interface windows switching method and terminal | |
| CN104346050A (en) | Information processing method and electronic equipment | |
| CN102902481A (en) | Terminal and terminal operation method | |
| CN103246445A (en) | Method and communication terminal for switching application programs | |
| CN102662584A (en) | Multi-application execution method and mobile terminal | |
| CN103955329A (en) | Intelligent terminal, mobile terminal and operating method thereof | |
| CN104820619B (en) | A kind of application programe switch-over method and device of mobile terminal | |
| CN105528148A (en) | Mobile terminal, mobile terminal operation method and mobile terminal operation device | |
| KR20180048927A (en) | Method, apparatus and storage medium for controlling a screen between terminals | |
| CN103034408A (en) | Page-switching method for user interface and mobile terminal | |
| CN105630288A (en) | Management method and device of application icon | |
| CN105630481A (en) | Data processing method, data processing device and terminal | |
| CN105573655A (en) | Terminal operation method and device and terminal | |
| CN106155503A (en) | A kind of icon page fast switch over method, system and terminal | |
| CN102830919A (en) | Method for switching candidate pages in input method of mobile terminal as well as mobile terminal | |
| CN104506732B (en) | System switching method and device based on contact person | |
| CN112148168A (en) | Icon moving method and device and electronic equipment | |
| CN105159764A (en) | Control method for application switching of mobile terminal and mobile terminal | |
| CN104346119A (en) | Method for displaying and electronic equipment |
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. |