CN1217269C - Method of using electronic table unit as data target memory and linking - Google Patents
Method of using electronic table unit as data target memory and linking Download PDFInfo
- Publication number
- CN1217269C CN1217269C CN 01134154 CN01134154A CN1217269C CN 1217269 C CN1217269 C CN 1217269C CN 01134154 CN01134154 CN 01134154 CN 01134154 A CN01134154 A CN 01134154A CN 1217269 C CN1217269 C CN 1217269C
- Authority
- CN
- China
- Prior art keywords
- data object
- data
- unit
- links
- row
- 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.)
- Expired - Fee Related
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a method for using electronic table units as data object storages and links. In the method, each unit stores a data object, electronic tables serve as data object storages, the tables are two-dimensional, every two columns cross to form a unit, and electronic table units serve as data object storages to store data; the row number and the column number of each electronic table unit serve as a storage unit. The data objects are divided into three different types: a basic type, a compound type and a unit type. Data links in Office application are rapidly established by using the paste link command which links data sources in goal objects to the goal objects. The electronic tables serve as the data object storages, based on which the software technique can automatically, rapidly and accurately correct the data. The present invention has obvious advantages of no error link, short response time and guarantee of data synchronism and uniformity.
Description
Technical field
The present invention relates to a kind of basis instrument method, relate in particular to the method that data object storage library and electronic table unit link integrated office software.
Background technology
Method to set up to office procedure software, Office with Microsoft is representative, but integrated between each application software of Office software such as Word, Excel, the software packages such as PowerPoint, Access, all there is obstacle in the integrated application between Database applications software and the Office.Though provide OLE (data object link) technology as Microsoft, solved the data link between word processing and two stand-alone programs of electrical form.But this data object chain technology of scratching is made mistakes easily, and when insert delegation be linked to the C3 cell data of word processing from electrical form before after, the cell address changes C4 into regard to mountain C3, but word processing still is linked to the old address of C3, rather than C4.This changes the address just as your the back notice post office of moving, but old address will your mail be delivered in the post office, gives you with the preceding tenant's in your present address mail.This obviously is wrong.Here it is except speed is slow, and the user is reluctant to use the main cause of this data object chained technology (OLE).Because each application software of Office software all has its original convenience, for the user, database and data should be utilized by each application software and be unlikely to make mistakes and could guarantee convenience in the use.The domestic notion that also relates to integrated office software as WPS2000, but its form also only is to use and handles four types data object, promptly digital, date, formula and text label, some electrical form manufacturers have comprised the data object of other type in their product, but they are stored in the electrical form outside, not in the cell of electrical form.The Office application software of not seeing other has the consideration of this respect.
Summary of the invention
The method that provides a kind of data object storage library and electronic table unit to link is provided the object of the invention, as integrated basis between each application software of Office software, overcome the obstacle that exists in the integrated application between Database applications software and the Office, with software integrated office software such as word processing, electrical form, briefing preparation, personal information management, picture makings, comprise simultaneously the method is used for Email and Internet.The present invention also aims to guarantee Office software, Email and Internet software can be automatically, correction data more quickly and accurately, do not have the link that makes mistakes again; Response time is short; Guarantee data synchronization and consistance.
Technical solution of the present invention is: the method that provides a kind of data object storage library and electronic table unit to link, the electrical form here is made of one or more row and one or more row, and arbitrary row and the mutual unit that all constitutes electrical form that intersects of arbitrary row; The unit is used to store data object, all unit composition data object storage libraries; Data object is original simple data, or from the data object address information of other cell links, or the application software information that described original simple data is operated, perhaps its arbitrary combination.
For can recorded electronic form corresponding line corresponding to the information of database respective record and electrical form respective column information corresponding to the database respective field, in the wardrobe array of electrical form and a row array, a mark is set respectively, and sets up electronic table unit and link with described database respective field;
When the data object of said units storage is handled, the spreadsheet program begin or this unit of initialization in the software program of this data object of processing of storing.
Above-mentioned processing also comprises from setting up the respective field of the database respective record that links with this unit reads original simple data, and it is presented at step in the pairing unit.
In order to finish the various functions of electrical form, above-mentioned processing comprises execution " paste link " order, paste in the object element being replicated the data object of storing in the unit, set up object element identical with the data object that is replicated unit storage, with the linking of described database respective field; Also comprise the step that the wardrobe array and the mark in the row array of electrical form are made amendment, deleted or add; Specifically be by deletion, revise or add order and upgrade described database, simultaneously, judge the wardrobe array of also upgrading electrical form and the mark in the row array, itself and database maintenance are linked; All data objects leave in another worksheet with the address mode of " book title ten work table numbers ten row number ten row number ", and are shown in appointed positions.
Except above-mentioned data object, the data object of this name also comprise original simple data scaling information and with the corresponding display icon of this data object, when the former shows described original simple data in application program, adjust shown zone according to this scaling information; The latter then shows the icon that is used to represent this data object data type when not showing the data content of described data object.Application software information is the memory address of software program or the URL information of software program.
With electronic table unit as the data object storage library, each unit stored data object, electrical form uses as the data object storage library, and form is two-dimentional, every row all constitutes a unit with intersecting of every row, and electronic table unit is as data object storage library stored data; Electronic table unit with row and column number as a storage unit, data object be divided into three kinds dissimilar: basic, compound, combination.Master data is to liking a cell that comprises original simple data.These data are not quoted any data object in other cells.Data splitting is to liking a cell, and it has comprised from other cells; The address of the data object that chain fetches and scaling, but itself does not comprise any data.The complex data object not only has the data of oneself, and from the data object of other Cell Link any kinds.
Electronic table unit is as a storage unit, and they can synchronous operation when the user handles numeral, text and chart etc., leaves the document in hard disk somewhere in.Check this picture up to customer requirements, program is just opened the document, reads image data with electronic format, and is presented in its residing cell.
Data object has the icon display of simple declaration title, they generally do not need to be presented on the screen, have only when customer requirements shows or handles, they just are read into internal memory, internal memory (or being written into the time that the big data quantity document is consumed) that like this can saves valuable and screen space (or sacrifice the response time and handle and video data).
Data object can float and show on screen, look as them not in cell, in fact, leave in another Zhang Gong's tabulation by the address mode of " book title ten work table numbers ten row number ten row number ", it can show in user's appointed positions.
Of the present invention further developing is: the data link between the Office application is set up in use " paste link " order fast, and the present invention's " paste link " order is because we believe that this order of use links or the integral data object will be very frequent.Use " paste link " order, the data source in the destination object is truly to be linked to destination object, and therefore, no matter how data source changes, and all data objects that link (or quoting) with it all can change automatically.Data integration that Here it is.We believe that this order will be very useful.
The link that remains between electrical form and database is important measures of the present invention: the record that takes out in the database table (Record) can read in the electrical form of all office softwares on the market.But, in case seeing through, they duplicate or inquire about the electrical form that is read into office software, software program and user just can't know which has linked which bar record in the database, and which row has linked which field (field).What we made is exactly to add a mark in the wardrobe array of electrical form, and this mark has comprised the general information about row, is used for representing that this row has comprised a record from database table.We are used for representing that also add a mark in a row array these row have linked a specific fields of database table.
After having known that whether whether row link with field with record linkage, row, you can judge the cell of arbitrary row, column point of crossing easily.Whether the data that it makes the user understand amicably and is checked are record, and are what fields.Simultaneously, the user can be by carrying out a deletion or revise order, or add the method that records in the database table that stores the hard disk somewhere, easily new database more.Except judge row whether with record linkage, record identifier can also represent that whether it be a new record, modification or had record by what database was deleted.So, the user can have an opportunity to cancel dangerous operation by deletion record in database, and the record in the electrical form still exists.The user can often be updated to new record with which row or they are added back in the database table.
Keep this link in electrical form, data-base recording can not only read in electrical form from database table easily by a querying command, need not write the grand of complexity but it also can upgrade database table at an easy rate.Many office softwares or electrical form user do not write grand ability or were not subjected to the training of this aspect.
Of the present invention further developing also comprises: the cell of each electrical form all is a software program or product, and when having a software program or product in each cell, we just regard each cell as a data object.The user can store software program or product in cell, perhaps quote it by URL (Universal Resource Locator).When cursor positioning during in this cell, the user can begin or this software program of initialization.
Each electronic form unit grid is not only the memory location that can be used as data, also can be the stored position of application software.Application software in this element lattice can be used other electronic form unit grids as its inputoutput data zone, the content of exporting from this application can be stored in the electrical form that has this cell or other cells.
Use electrical form as the data object storage library, software engineering on this basis can be automatically, correction data more quickly and accurately.Here it is, and we use the reason of cell address process all-links.
Make in this way advantage clearly: do not have the link that makes mistakes again; Aspect the response time, the time also is very short; The most important thing is, can guarantee data synchronization and consistance.Have only service-strong technology and correct solution, application just can be widely used.
Description of drawings
Fig. 1 is an embodiments of the invention screen interface synoptic diagram, and electrical form storage unit screen interface shows that data object is to have the icon display that the simple declaration mark belongs to.
FB(flow block) when Fig. 2 uses for the inventive method: the electrical form storage unit, the document in hard disk somewhere is left in synchronous operation in when handling numeral, text and chart etc., checks this picture up to customer requirements, and program is just opened the document.
For picture (Picture), the chart (Chart) of EIO, link area (Link Range) can be provided with display icon or real image by following.
FB(flow block) when Fig. 3 uses for the inventive method: one does not need the electrical form storage unit to be presented on the screen, has only when customer requirements shows or handles, and they just are read into internal memory.
Word processing and briefing preparation, the processing procedure and the text processing application of briefing preparation profile are similar.
FB(flow block) when Fig. 4 uses for the inventive method: when the cell of electrical form is stored a software program or product, just each cell is regarded as a data object.The user can store software program or product in cell, perhaps quote it by URL (Universal Resource Locator).When cursor positioning during in this cell, the user can begin into this software program of initialization.For other multimedia file, similar as video file processing procedure and Fig. 4 flow process.
FB(flow block) when Fig. 5 uses for the inventive method: the data link between the Office application is set up in " paste link " order fast, and the present invention's " paste link " order links or the integral data object.
Embodiment
As shown in Figure 1, as the data object storage library, each unit is energy stored data object all with electronic table unit, and promptly electrical form uses as the data object storage library.Form is two-dimentional, and every row all constitutes a unit with intersecting of every row, electronic table unit with row and column number as a storage unit.Data object can float and show on screen, looks as them not in cell.In fact, leave in another Zhang Gong's tabulation by the address mode of " book title ten work table numbers ten row number ten row number ", it can show in user's appointed positions.Electrical form is on user interface on the screen, and the icon that shows in the electrical form provides corresponding various data or program.As shown in the figure, overlap the user interface more and be compressed and be included in a general and consistent user interface, replace every kind of application program to use the situation at a cover user interface.As: the command menu of word processing, electrical form, briefing preparation and other application and dialog box are merged into a cover menu and a dialog box.Other all Application Software Program that are stored in the electronic form unit grid can be by adding menu item or using same set of menu bar to show in the mode of menu in menu bar.
Multimedia data object also can deposit in arbitrary electronic form unit grid.Before they are activated, screen on display icon; The icon active mode; Start the multimedia software program when being cursor pointing, with the multimedia office software of software program design, after the activation, multimedia data object, for example sound, video, picture, cartoon etc., they can synchronous operation when the user handles numeral, text and chart etc.With the multimedia office software of a software program design, these functions are all finished in a software program.
These data objects comprise: 1, master data object: only comprise the data object of self, not nested other data object that comprises, as numeral, date, text label, picture or photo, audio-frequency music, video are sheared, URL address, icon, other; 2, data splitting object: do not have any its data, data content is made up of many other data of different types objects, as business graphic, desk-top publishing page or leaf, webpage, presentation slides, zone, list, other; 3, complex data object: have its data to use simultaneously or comprise other data objects: as paragraph, formula etc.
All data objects are placed in the electrical form, just do not have again the wrong situation of link to take place.For example, if insert delegation at the third line, then formula B2=C3 * D4 just changes B2=C4 * D5 into.By electronic table unit address reference service data object linking; Use is with the chained technology of electrical form as the data object storage library, and this mechanism is very good.Because the link of data object can not safeguarded by the third party, the OLE technology supported of Microsoft for example, when occurring in a data change in the application and causing Data Update in the Another Application, this provisional technology makes renewal speed slack-off, and, it does not know correct address, can't notify Another Application correctly to change the address automatically to guarantee correct link or to quote.
The order of the data link between the Office application is set up in " paste link " order fast, and the present invention's " link is pasted " order links or the integral data object.Because all data objects all use special address to be stored in electrical form inside, therefore, by this specific address location with obtain data.Show the FB(flow block) when the present invention uses as Fig. 5: the data link between the Office application is set up in " paste link " order fast, and the present invention's " paste link " order links or the integral data object.
Data object can nested (link) be gone into other data objects, for example combination and compound type data object.When link or the cell address modification quoted or when mobile, all uses or the data object of quoting this address must upgrade or refresh, to keep correct address and link.
Claims (8)
1, the method that links of a kind of data object storage library and electronic table unit, it is characterized in that: described electrical form is made of one or more row and one or more row, and arbitrary row and the mutual unit that all constitutes electrical form that intersects of arbitrary row; The unit is used to store data object, all unit composition data object storage libraries; Data object is original simple data, or from the data object address information of other cell links, or the application software information that described original simple data is operated, perhaps its arbitrary combination;
In the wardrobe array of electrical form and a row array mark is set respectively, recorded electronic form corresponding line is corresponding to the information of database respective record and the electrical form respective column information corresponding to the database respective field respectively; Setting up electronic table unit links with described database respective field;
When the data object of said units storage is handled, the spreadsheet program begin or this unit of initialization in the software program of this data object of processing of storing.
2, the method that links of data object storage library according to claim 1 and electronic table unit, it is characterized in that: described processing also comprises from setting up the respective field of the database respective record that links with this unit reads original simple data, and it is presented at step in the pairing unit.
3, the method that links of data object storage library according to claim 1 and electronic table unit, it is characterized in that: described processing is to carry out " paste link " order, paste in the object element being replicated the data object of storing in the unit, set up object element identical with the data object that is replicated unit storage, with the linking of described database respective field.
4, data object storage library according to claim 1 and the method that electronic table unit links is characterized in that: described processing also comprises the step that the mark in the wardrobe array of electrical form and the row array is made amendment, deleted or adds; Specifically be by deletion, revise or add order and upgrade described database, simultaneously, judge the wardrobe array of also upgrading electrical form and the mark in the row array, itself and database maintenance are linked.
5, the method that links of data object storage library according to claim 1 and electronic table unit, it is characterized in that: described data object also comprises the scaling information of original simple data, when application program shows described original simple data, adjust shown zone according to this scaling information.
6, the method that links of data object storage library according to claim 1 and electronic table unit, it is characterized in that: described data object also comprises and the corresponding display icon of this data object, when not showing the data content of described data object, then show the icon that is used to represent this data object data type.
7, data object storage library according to claim 1 and the method that electronic table unit links is characterized in that: the memory address that described application software information is software program or the URL information of software program.
8, the method that links according to claim 1,5,6 or 7 described data object storage libraries and electronic table unit, it is characterized in that: described data object leaves in another worksheet with the address mode of " book title ten work table numbers ten row number ten row number ", and is shown in appointed positions.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 01134154 CN1217269C (en) | 2001-11-07 | 2001-11-07 | Method of using electronic table unit as data target memory and linking |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 01134154 CN1217269C (en) | 2001-11-07 | 2001-11-07 | Method of using electronic table unit as data target memory and linking |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1348135A CN1348135A (en) | 2002-05-08 |
| CN1217269C true CN1217269C (en) | 2005-08-31 |
Family
ID=4672286
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 01134154 Expired - Fee Related CN1217269C (en) | 2001-11-07 | 2001-11-07 | Method of using electronic table unit as data target memory and linking |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1217269C (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100504849C (en) * | 2002-10-24 | 2009-06-24 | 国际商业机器公司 | Data conversion method and device |
| CN100356330C (en) * | 2006-01-26 | 2007-12-19 | 无锡永中科技有限公司 | Paste link processing method based on object memory database and past link processor |
| CN105585414B (en) * | 2014-10-22 | 2019-11-12 | 中国石油化工股份有限公司 | A kind of method of synthesis of vinyl norbornene |
| EP3079079B8 (en) * | 2015-04-07 | 2022-04-27 | Huawei Technologies Co., Ltd. | Method, apparatus and data structure for copying values of a table of a database |
| US11023668B2 (en) | 2015-11-02 | 2021-06-01 | Microsoft Technology Licensing, Llc | Enriched compound data objects |
| US10599764B2 (en) | 2015-11-02 | 2020-03-24 | Microsoft Technology Licensing, Llc | Operations on images associated with cells in spreadsheets |
-
2001
- 2001-11-07 CN CN 01134154 patent/CN1217269C/en not_active Expired - Fee Related
Also Published As
| Publication number | Publication date |
|---|---|
| CN1348135A (en) | 2002-05-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| AU2018236875B2 (en) | Graphical user interface that simplifies user creation of custom calculations for data visualizations | |
| US10104082B2 (en) | Aggregated information access and control using a personal unifying taxonomy | |
| CN100517315C (en) | Management and use of data in a computer-generated document | |
| JP2005508552A (en) | Memory system for data objects | |
| US20110249003A1 (en) | Configurable framework for rich data visualization | |
| US8892501B2 (en) | Capturing OLAP analysis thread as refreshable business intelligence data | |
| CN111602120B (en) | Displaying an indication of changes made to content at a source | |
| CN116383546B (en) | File processing method, system, computer device and computer readable storage medium | |
| US20070255722A1 (en) | Data-driven page layout | |
| JP2022041865A (en) | Online working system for template-based excel documents | |
| CN1217269C (en) | Method of using electronic table unit as data target memory and linking | |
| WO2005064497A2 (en) | System and method for content structure adaptation | |
| US8091016B2 (en) | Visually manipulating instance collections | |
| US20080263018A1 (en) | Method and System for Mapping Business Objects to Relational Database Tables | |
| US7937656B2 (en) | Method for rendering information on a display | |
| US7546526B2 (en) | Efficient extensible markup language namespace parsing for editing | |
| CN1725211A (en) | Device for displaying and operating book in electronic form | |
| Jerez et al. | The multi-faceted use of the OAI-PMH in the LANL Repository | |
| Haimerl | Database design and technical solutions for the management, calculation, and visualization of dialect mass data | |
| Chen | Digital preservation: Organizational commitment, archival stability, and technological continuity | |
| KR20090018481A (en) | A system for composing report, a method & a system for providing a made-to-order report | |
| Parker | Staying Relevant in a Competitive World: Using the SAS Output Delivery System to Enhance, Customize, and Render Reports | |
| Tanaka et al. | Meme media and Topica architectures for editing, distributing, and managing intellectual assets | |
| Renfro et al. | Several Historical Considerations | |
| Bellekom | Building preservation functionality in a digital archive: the National Library of the Netherlands |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C06 | Publication | ||
| PB01 | Publication | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C17 | Cessation of patent right | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20050831 Termination date: 20091207 |