CN1862528A - Method for displaying data object discriptive information - Google Patents
Method for displaying data object discriptive information Download PDFInfo
- Publication number
- CN1862528A CN1862528A CN 200610083590 CN200610083590A CN1862528A CN 1862528 A CN1862528 A CN 1862528A CN 200610083590 CN200610083590 CN 200610083590 CN 200610083590 A CN200610083590 A CN 200610083590A CN 1862528 A CN1862528 A CN 1862528A
- Authority
- CN
- China
- Prior art keywords
- information
- cell
- project name
- data object
- name information
- 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
Images
Landscapes
- User Interface Of Digital Computer (AREA)
Abstract
The present invention relates to a display method of descriptive information of data object. Said method includes the following steps: after the activated information of unit check on electronic table page is received by customer end module, the customer end module can send a request information for displaying descriptive information of data object in current activated unit check into electronic table application program; the electronic table application program can read the address information of current activated unit check, utilize the address information of said unit check to obtain the address of line head and column head correspondent to said unit check, then read the data information correspondent to line head and column head and write the literal information which is represented by data information and is used for describing data object message into display position, then send the indication information for displaying descriptive information of data object in display position into customer end module; the customer end module can display literal information in display position.
Description
Technical field
The present invention relates to a kind of display packing of descriptive information of data object, especially a kind of in the page or formula bar of electrical form, show the method for the Word message of the implication be used for the data of description object to belong to field of computer technology.
Background technology
Because electrical form has the convenience of storage data and the logic of video data, therefore, in work, life, obtained using widely, the user can write down a large amount of grouped datas by electrical form, for example, every financial information such as the income by electrical form each month of writing down certain company in certain period, expenditure, profit; And for example, write down certain family every spending situation of every day by electrical form.
At present, in the use of electrical form, when the cell at a certain data object place with can on same screen, show the time with the first trip of this descriptive information of data object and first cell, the user can clearly know the implication that this data object is represented, for example, descriptor in the first trip cell corresponding with the cell at this data object place is " income ", descriptor in first cell is " in January, 2005 ", intersect data object in the corresponding cell during for " 50 yuan " by this first trip and first cell, and then Biao Shi implication is that the income in January, 2005 is 50 yuan.But, when the residing cell of a certain data object in the electrical form and the pairing first trip of this cell and first cell are not presented on the same screen, be in the time of to show the residing cell of first trip, first cell and this data object on the screen simultaneously, the user knows the descriptive information of data object in this cell if desired, can first trip and first cell be freezed by " freezing pane " function.But, electrical form can only be split as two parts by " freezing pane " function shows, can't continue to split by the forms freezing function again with freezing later pane, like this, when the user need handle simultaneously a plurality of can't be on same screen the data presented object, and when the first trip of each data object and first all might also can't show on same screen, the user just can't be known these descriptive information of data object easily, brought great inconvenience for user's use.
Summary of the invention
Technical matters to be solved by this invention is, can't know the shortcomings and deficiencies of the information of data object in the electrical form easily at user in the prior art, a kind of display packing of descriptive information of data object is provided, can be in the information of the display position video data object of formula bar or cell or other appointment, thereby avoid the user to know and the information of data object made things convenient for the user by troublesome operation.
The display packing of a kind of descriptive information of data object provided by the invention, carry out following steps:
Behind the active information of the cell on step 1, the client modules electron gain form page, send the solicited message that shows the descriptive information of data object in the current cell that is activated to spreadsheet applications, comprise display position information in this solicited message;
Step 4, spreadsheet applications read and described wardrobe and a row corresponding data message, and the Word message that described data object implication is described in represented being used to of this data message write described display position, be sent in the indication information that described display position shows described descriptive information of data object to client modules then;
Step 5, client modules show described Word message at described display position.
In the technique scheme, also comprise before the described step 1: steps A, client modules send predefined display region information on the described file page to spreadsheet applications, and this display region information comprises the row number and row information of describing this viewing area marginal position; Step B, spreadsheet applications are preserved described display region information.
Also comprise between described step B and the described step 1: the project name information that in the first trip of described viewing area and/or first cell, writes the described data message of expression.
Further comprising the steps of between described step 2 and the step 3: step 21, spreadsheet applications judge according to the address information of the current cell that is activated whether the current cell that is activated is in the described viewing area, are that then execution in step 22; Otherwise, execution in step 3; Step 22, obtain the first trip corresponding with this cell in the described viewing area and the address of first cell according to the address information of the current cell that is activated, execution in step 4 then.
In the described step 4, when described project name information is write described display position, also write the separator that is used to isolate this first project name information and the second project name information between the second project name information in the first project name information in the first trip cell of described viewing area and first cell of described viewing area.
In addition, in the described step 1, when spreadsheet applications send the solicited message that shows the descriptive information of data object in the current cell that is activated, also be sent in the solicited message that described display position shows described data object simultaneously.In the described step 4, when the Word message that described data object implication is described in represented being used to of described project name information writes described display position, also described data object is write described display position.In the described step 4, read with the corresponding first project name information in the address of described wardrobe cell and during with the corresponding second project name information in the address of described row head, also read described data object information, and Word message and the described data object information that described data object implication is described in the described first project name information and represented being used to of the described second project name information write described display position.In the described step 5, when client modules shows described Word message at described display position, also show described data object information at described display position.
Described step 4 comprises: step 41, spreadsheet applications obtain described first project name information and the described second project name information, and described first project name information and the described second project name information are write described display position; Step 42, spreadsheet applications judge in the current cell that is activated whether have formula, if there is execution in step 43; Otherwise, execution in step 45; Step 43, spreadsheet applications read the cell address in the described formula, judge whether the cell of this cell address correspondence all belongs to described viewing area, are execution in step 44; Otherwise, execution in step 45; Step 44, spreadsheet applications replace with the project information corresponding with this cell address with the cell address in the described formula, and the new formula that will obtain after will replacing writes described display position, send the indication information that shows the described first project name information, the described second project name information and described new formula to client modules, execution in step 5 then; Step 45, spreadsheet applications send the indication information that shows described first project name information and the described second project name information to client modules.
Described step 5 is specially: show the described first project name information, the described second project name information and described new formula.
In the described step 43, if the cell of cell address correspondence all belongs to described viewing area in the formula, then whether the cell of cell address correspondence and the current cell that is activated all belong to delegation or same row in the spreadsheet applications judgment formula, be that then execution in step 44; Otherwise, execution in step 45.
Based on technique scheme, when the user moves to cell on the file page by mouse or keyboard, the active information that client modules just can obtain this cell cooperates the descriptive information of data object that realizes reading automatically in this cell and it is presented at preassigned display position with spreadsheet applications, in formula bar or cell, make the user can clearly know the practical significance of this data object, be very easy to the user.
Below by drawings and Examples, technical scheme of the present invention is described in further detail.
Description of drawings
Fig. 1 is the basic flow sheet of the display packing of descriptive information of data object of the present invention;
Fig. 2 is the process flow diagram of the display packing embodiment of descriptive information of data object of the present invention.
Embodiment
Figure 1 shows that a basic flow sheet of the display packing of descriptive information of data object of the present invention, it may further comprise the steps:
Step 1, when the button by mouse or keyboard moves to cursor a certain cell on the electrical form page, this cell is activated, after client modules detects the active information of this cell, be sent in the display position of appointment to spreadsheet applications, for example formula bar, the current cell that is activated or other position, the solicited message that shows this descriptive information of data object has been carried display position information in this solicited message;
Step 4, spreadsheet applications read and wardrobe and a row corresponding data message, and the Word message that is used for data of description object implication that this data message is represented writes display position, is sent in the indication information of the descriptor of this display position video data object then to client modules.According to the example in the step 3, suppose that the data message in the wardrobe (5:5) is " income ", data message in the row heads (C:C) is " in January, 2005 ", the display position of appointment is the formula bar in the electrical form, spreadsheet applications read data information " income " from wardrobe (5:5) then, read data information " in January, 2005 " from row heads (C:C), and data message " income " and " in January, 2005 " write in the formula bar, be sent in the descriptor " income " of formula bar video data object and the indication information in " in January, 2005 " to client modules then;
Step 5, client modules show that at corresponding display position the Word message that is used for data of description object implication is a descriptor according to indication information.According to step 4, client modules is video data information " income " and " in January, 2005 " in formula bar.
Under some situation, the user only uses the subregion in the electrical form, for example: (C3:G8), can adopt method provided by the invention only to show the descriptive information of data object that is arranged in this zone, at this moment, need zone (abbreviation viewing area) information of the descriptor of definition video data object earlier, definition procedure is as follows: steps A, the display region information of client modules descriptor of predefined video data object on the page of spreadsheet applications transmission electrical form, for example: (C3:G8), this display region information comprises row number and the row information of describing this viewing area marginal position, that is: minimum row number, maximum line number, minimum row number and maximum column information; Step B, spreadsheet applications are kept at display region information in system's table.Then, in the first trip of viewing area and first cell (be minimum row number with minimum row number corresponding cell), write project name information (being data message), for example: cuit name information " income ", " expenditure " in the first trip cell of viewing area, cuit name information in first cell of viewing area " in January, 2005 ", " in February, 2005 " etc.For simplicity, claim that the project name information in the first trip cell is the first project name information, claim that the project name information in first cell is the second project name information.
Figure 2 shows that the process flow diagram of the display packing embodiment of descriptive information of data object of the present invention, it may further comprise the steps:
When the user chooses in the viewing area data object in a certain cell by mouse or keyboard, system is just automatically in the reading displayed zone in the first trip and first cell corresponding with this cell, be used to describe the Word message of the actual expression meaning of this data object, and it is presented in the cell or formula bar at this data object place, the perhaps display position of other any appointments, make the user can clearly know the practical significance of this data object, for example, according to embodiment shown in Figure 2, when cursor moves to the E5 cell, when pointing to " 1000 ", just can show " profit/2005 year March " information in the formula bar of electrical form, this data object represents is " in March, the 2005 " information of " profit " for knowing of making that the user can be clear and definite, is very easy to the user.
In addition, when the descriptor of appointed positions video data object, also can show this data object simultaneously, at this moment, in the step 201, when client modules is sent in the solicited message of the descriptor of video data object " 1000 " in the formula bar to application program, also be sent in the solicited message of video data object in this formula bar; In the step 4, spreadsheet applications are with data message " profit " and " in March, 2005 " when writing in the formula bar, also data object " 1000 " is write write in this formula bar fashionable, can adopt one to isolate symbol equally, for example: bracket, data message and data object information are isolated, for example, can be written as " (profit/2005 year March) 1000 ", be sent in the indication information of this formula bar video data information and date object then to client modules; In the step 205, during video data information, go back data object information simultaneously, for example: (profit/2005 year March) 1000; In the step 207,, then only show " 1000 " if do not have a data message in wardrobe (5:5) and the row head (E:E).
In the step 204, with the first project name information " profit " and the second project name information " in March, 2005 " when writing in the formula bar, also whether there is formula among the cell E5 at judgment data object " 1000 " place, if there is no, be sent in the indication information that formula bar shows " profit " and " in March, 2005 " to client modules; If exist, spreadsheet applications read the cell address in the formula, for example: retrieval unit lattice address E3 and E4 from formula " E3-E4 ", whether judging unit lattice address E3 and E4 belong to viewing area (C3:C8) then, if do not belong to, be sent in the indication information that formula bar shows " profit " and " in March, 2005 " to client modules; If belong to, spreadsheet applications replace with the project name information corresponding with this cell address with the cell address in the formula, send the indication information that shows the first project name information, the second project name information and this new formula to client modules then.For example: if contain formula " E3-E4 " among the current cell E5 that is activated, the corresponding project name information in the first trip corresponding with E5 and first cell address is respectively " profit " and " in March, 2005 ", project name information in the first trip cell of cell address E3 is " income ", project name information among the E4 of cell address is " expenditure ", then " E3-E4 " replaced with " income-expenditure ", in formula bar, write " (profit/2005 year March) income-expenditure " then.In the step 205, client modules shows " (profit/2005 year March) income-expenditure " according to indication information in formula bar.
In addition, in the step 204 of the foregoing description, if the cell address in the formula belongs to viewing area (C3:C8), then whether the cell and the current cell that is activated of the cell address correspondence in the also further judgment formula of spreadsheet applications belong to delegation or same row, if do not belong to same delegation, and do not belong to same row yet, then be sent in the indication information that formula bar shows " profit " and " in March, 2005 " to client modules; If the cell and the current cell that is activated of the cell address correspondence in the formula all belong to delegation or same row, then spreadsheet applications read the project name information of the cell address correspondence in the formula, and just the cell address in the formula replaces with the project name information corresponding with this cell address.Send the indication information that shows the first project name information, the second project name information and this new formula to client modules then.For example: if contain formula " C3+D3+E3 " among the current cell F3 that is activated.The first project name information corresponding with F3, the second project name information are respectively " income " and " first season/2006 ", the second project name information of cell C3 correspondence is " in January, 2005 ", the second project name information of cell D3 correspondence is " in February, 2005 ", the second project name information of cell E3 correspondence is " in March, 2005 ", then " C3+D3+E3 " replaced with " year February+2005, in January, 2005+2005 year March ", in formula bar, write " year February+2005, (income/first season/2006) in January, 2005+2005 year March " then.In the step 205, client modules shows " year February+2005, (income/first season/2006) in January, 2005+2005 year March " according to indication information in formula bar.
It should be noted last that, above embodiment is only unrestricted in order to technical scheme of the present invention to be described, although the present invention is had been described in detail with reference to preferred embodiment, those of ordinary skill in the art is to be understood that, can make amendment or be equal to replacement technical scheme of the present invention, and not break away from the spirit and scope of technical solution of the present invention.
Claims (12)
1, a kind of display packing of descriptive information of data object, wherein, carry out following steps:
Behind the active information of the cell on step 1, the client modules electron gain form page, send the solicited message that shows the descriptive information of data object in the current cell that is activated to spreadsheet applications, comprise display position information in this solicited message;
Step 2, spreadsheet applications read the address information of the current cell that is activated;
Step 3, spreadsheet applications obtain the address of pairing wardrobe of this cell and row head according to the address information of the current cell that is activated;
Step 4, spreadsheet applications read and described wardrobe and a row corresponding data message, and the Word message that described data object implication is described in represented being used to of this data message write described display position, be sent in the indication information that described display position shows described descriptive information of data object to client modules then;
Step 5, client modules show described Word message at described display position.
2, method according to claim 1 wherein, also comprises before the described step 1:
Steps A, client modules send predefined display region information on the described file page to spreadsheet applications, and this display region information comprises row number and the row information of describing this viewing area marginal position;
Step B, spreadsheet applications are preserved described display region information.
3, method according to claim 2 wherein, also comprises between described step B and the described step 1:
In the first trip of described viewing area and/or first cell, write the project name information of the described data message of expression.
4, method according to claim 3, wherein, further comprising the steps of between described step 2 and the step 3:
Step 21, spreadsheet applications judge according to the address information of the current cell that is activated whether the current cell that is activated is in the described viewing area, are that then execution in step 22; Otherwise, execution in step 3;
Step 22, obtain the first trip corresponding with this cell in the described viewing area and the address of first cell according to the address information of the current cell that is activated, execution in step 4 then.
5, method according to claim 4, wherein, in the described step 4, when described project name information is write described display position, also write the separator that is used to isolate this first project name information and the second project name information between the second project name information in the first project name information in the first trip cell of described viewing area and first cell of described viewing area.
6, method according to claim 4, wherein, in the described step 1, when spreadsheet applications send the solicited message that shows the descriptive information of data object in the current cell that is activated, also be sent in the solicited message that described display position shows described data object simultaneously.
7, method according to claim 4 wherein, in the described step 4, when the Word message that described data object implication is described in represented being used to of described project name information writes described display position, also writes described display position with described data object.
8, method according to claim 7, wherein, in the described step 4, read with the corresponding first project name information in the address of described wardrobe cell and during with the corresponding second project name information in the address of described row head, also read described data object information, and Word message and the described data object information that described data object implication is described in the described first project name information and represented being used to of the described second project name information write described display position.
9, method according to claim 8 wherein, in the described step 5, when client modules shows described Word message at described display position, also shows described data object information at described display position.
10, method according to claim 3, wherein, described step 4 comprises:
Step 41, spreadsheet applications obtain described first project name information and the described second project name information, and described first project name information and the described second project name information are write described display position;
Step 42, spreadsheet applications judge in the current cell that is activated whether have formula, if there is execution in step 43; Otherwise, execution in step 45;
Step 43, spreadsheet applications read the cell address in the described formula, judge whether the cell of this cell address correspondence belongs to described viewing area, are execution in step 44; Otherwise, execution in step 45;
Step 44, spreadsheet applications replace with the project information corresponding with this cell address with the cell address in the described formula, and the new formula that will obtain after will replacing writes described display position, send the indication information that shows the described first project name information, the described second project name information and described new formula to client modules, execution in step 5 then;
Step 45, spreadsheet applications send the indication information that shows described first project name information and the described second project name information to client modules.
11, method according to claim 10, wherein, described step 5 is specially: show the described first project name information, the described second project name information and described new formula.
12, method according to claim 10, wherein, in the described step 43, if the cell of cell address correspondence belongs to described viewing area in the formula, then whether the cell of cell address correspondence and the current cell that is activated belong to delegation or same row in the spreadsheet applications judgment formula, be that then execution in step 44; Otherwise, execution in step 45.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200610083590 CN1862528A (en) | 2006-06-09 | 2006-06-09 | Method for displaying data object discriptive information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200610083590 CN1862528A (en) | 2006-06-09 | 2006-06-09 | Method for displaying data object discriptive information |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1862528A true CN1862528A (en) | 2006-11-15 |
Family
ID=37389960
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200610083590 Pending CN1862528A (en) | 2006-06-09 | 2006-06-09 | Method for displaying data object discriptive information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1862528A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103136167A (en) * | 2011-12-05 | 2013-06-05 | 英顺源（上海）科技有限公司 | Sheet capturing system used in paging of spreadsheet and method thereof |
| CN115840539A (en) * | 2023-01-31 | 2023-03-24 | 天津南大通用数据技术股份有限公司 | Data processing method and device, electronic equipment and storage medium |
| WO2023143071A3 (en) * | 2022-01-27 | 2023-09-14 | 北京字跳网络技术有限公司 | Content display method and apparatus, electronic device and storage medium |
-
2006
- 2006-06-09 CN CN 200610083590 patent/CN1862528A/en active Pending
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103136167A (en) * | 2011-12-05 | 2013-06-05 | 英顺源（上海）科技有限公司 | Sheet capturing system used in paging of spreadsheet and method thereof |
| WO2023143071A3 (en) * | 2022-01-27 | 2023-09-14 | 北京字跳网络技术有限公司 | Content display method and apparatus, electronic device and storage medium |
| CN115840539A (en) * | 2023-01-31 | 2023-03-24 | 天津南大通用数据技术股份有限公司 | Data processing method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9244833B2 (en) | Data-storage device and flash memory control method | |
| US10157173B2 (en) | Optimizing rendering of data tables | |
| US20040119760A1 (en) | Contact user interface | |
| CN1677356A (en) | Method and medium and method for recovering data using a timeline-based computing environment | |
| CN1604025A (en) | Hierarchical in-place menus | |
| CN1179284C (en) | Target management container and its managing method | |
| CN101464908A (en) | Log recording method and device | |
| CN102609337A (en) | Rapid data recovery method for memory database | |
| KR20090122953A (en) | Techniques to share information between application programs | |
| CN103106266A (en) | Folder management and display method and mobile terminal based on android system | |
| WO2006026680A2 (en) | Systems and methods for organizing and mapping data | |
| US20060179066A1 (en) | Flexible file format for updating an address book | |
| CN100507921C (en) | Words display process in embedded system and system thereof | |
| CN101246409A (en) | Graded in-place menu with navigation menu | |
| US20080301195A1 (en) | Method, apparatus and system for reverting fat cluster number to file id and offset of non-fat flash file system | |
| CN102779138A (en) | Hard disk access method of real time data | |
| CN1821978A (en) | Method for operating data in non-volatile storage in embedded system | |
| CN1862528A (en) | Method for displaying data object discriptive information | |
| CN102169497B (en) | Method and device for managing metadata through bitmaps | |
| CN103548005A (en) | Method and device for replacing cache objects | |
| CN113360324B (en) | Data backup device based on distributed file data | |
| CN1492330A (en) | Method for general windows program to operate journal information record | |
| CN1311338C (en) | Method for reducing holding of internal memory in using table | |
| CN1808423A (en) | Webpage search display method and its client device | |
| CN1311330C (en) | Method for processing information in the process of utilizing interface display information |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |