CN103605917A - Spreadsheet system based on multi-user environment and implementation method of spreadsheet system - Google Patents
Spreadsheet system based on multi-user environment and implementation method of spreadsheet system Download PDFInfo
- Publication number
- CN103605917A CN103605917A CN201310668494.6A CN201310668494A CN103605917A CN 103605917 A CN103605917 A CN 103605917A CN 201310668494 A CN201310668494 A CN 201310668494A CN 103605917 A CN103605917 A CN 103605917A
- Authority
- CN
- China
- Prior art keywords
- user
- module
- vba
- script
- worksheet
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/30—Authentication, i.e. establishing the identity or authorisation of security principals
- G06F21/31—User authentication
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computer Security & Cryptography (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Computer Hardware Design (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Document Processing Apparatus (AREA)
Abstract
The invention discloses a spreadsheet system based on multi-user environment and an implementation method of the spreadsheet system. The spreadsheet system comprises a data storage module, a macro driving module, a VBA (Visual Basic for Applications) driving script module and a function module, wherein the data storage module comprises an Excel worksheet, a data source sheet, a macro sheet and a user prompt sheet; the macro driving module reads the macro sheet when a user logs in, drives macro script to judge whether to forbid macro and responds; the VBA driving script module encrypts the worksheet and forbids a user to open a VBE (Visual Basic Editor), judges whether login of the user is legal and responds; the function module acquires and analyzes user function, and then, calls an ExcelCOM interface to search data in a reference data source sheet, and returns back to result to fill and display cells. The implementation method comprises a step of creating the data storage module, the function module, the macro driving module and the VBA driving script module. The spreadsheet system based on multi-user environment and the implementation method of the spreadsheet system have extremely high flexibility, usability and practicability, and can greatly improve working efficiency of managers.
Description
Technical field
The invention belongs to electronic document technical field, be specifically related to a kind of spreadsheet systems and its implementation in multi-user environment with security, dirigibility, ease for use and practicality.
Background technology
Microsoft Excel is one of the assembly of the office software Microsoft office of Microsoft, because formula functions a large amount of in Excel can supply application choice, make Excel can carry out data message list and the data information chart production in calculating, analytical information managing electronic form or webpage, can realize many functions easily, bring user convenient, be widely used in the various fields such as management, statistics finance and economics, finance.
Excel is owing to can only whole book or single worksheet being encrypted, be difficult to realize multi-user's access control, therefore mostly by complicated Access or dedicated management software, realize the access control under multi-user environment, both be difficult to operation, and the large transmission inconvenience of volume, and dedicated management software overhead is high, most of use that adopts C/S model to be difficult to adapt to the non-on-line customer who scatters.
Wage detailed data is the important raw data of the work such as statistics salary appropriate to a special post income situation, making salary bill.In many large enterprises, the management mode of wage is carried out gross pay and is controlled, right of distribution is issued to the management mode in each factory or workshop, in company's aspect, monthly salary appropriate to a special post will be distributed to salary appropriate to a special post detailed data constituent parts under company after providing income in time, so that constituent parts is made the work such as salary bill, statistics income of non-agricultural workers situation.Wage data belong to security information, disposal route is before the wages clerk of company sorts monthly earnings detailed data by unit after, again the salary appropriate to a special post data Replica of same unit is pasted in a newly-built Excel worksheet, and save as Excel file, there are how many units just by this step repeatable operation, to create one by one how many Excel files; Afterwards also will be respectively the Excel file creating be above distributed to constituent parts under company one by one by Instant Messenger (IM) software or Email, does so very loaded down with trivial details, time-consuming, inefficiency, if things go on like this also make wages clerk feel uninteresting, dull deeply.
Summary of the invention
The first object of the present invention is to provide a kind of spreadsheet systems based on multi-user environment with security, dirigibility, ease for use and practicality; The second object is to provide a kind of first object spreadsheet systems implementation method that realizes.
The first object of the present invention is achieved in that and comprises that data memory module, grand driver module, VBA drive script module, function module, wherein:
Described data memory module comprises according to multiple Excel worksheets of number of users storage and data source table, macro sheet, user's prompt table;
Described grand driver module is the macro sheet in reading out data memory module driving grand script wherein when user logins, and judges whether user forbids the macroefficiency of described spreadsheet systems, and forbidding exits user's login;
Described VBA drives script module to generate VBA and drives script, with each worksheet in Excel data memory module described in the VBA script encryption generating and forbid that user opens Visual Basic editing machine, when logining, user judges that whether user is legal, legal according to corresponding worksheet in VBA script deciphering Excel data memory module, do not conform to rule and read and show the user's prompt table in described data memory module;
Described function module gathers the user function that VBA drives script module mapping, after analysis user function, according to user function calling excel com interface, search the data in the table of reference data source in described data memory module, by the filling that has returned results cell of user function and the demonstration in Excel.
The second object of the present invention is achieved in that and comprises that data memory module creates, function module creates, grand driver module creates, VBA drives script module to create, and concrete steps are:
A, data memory module create: according to number of users, creates and preserve Excel workbook file, and create therein multiple Excel worksheets of inquiring about for users and data source table, macro sheet, user's prompt table;
B, function module create: according to the data of the required inquiry of user, in Excel worksheet, write utility function, the data in the table of described utility function reference data source are as the information that offers user's inquiry;
C, grand driver module create: in described macro sheet, write macrocode, if realize user, forbid grandly when opening Excel workbook, close Excel workbook;
D, VBA drive script module to create: write VBA program the worksheet of step B is encrypted to mandate, realize different user with the corresponding data of cipher inquiry, forbid that user opens Visual Basic editing machine.
The present invention drives script module and grand driver module that Excel system is developed and expanded by creating VBA, by writing VBA, drive script module to encrypt to each worksheet in same Excel workbook, use grand driver module to read and drive macrocode, when limited subscriber is opened this workbook, must carry out " enabling grand " function; By VBA, drive script module to forbid that user opens Visual Basic editing machine, to prevent that user from using Visual Basic editing machine to check, revise, destroy the VBA program of being write simultaneously.Like this, when user opens the corresponding worksheet of workbook of this Excel system, only have the password of each worksheet of input just can enter corresponding worksheet, by function module, gather and analyze the user function that VBA drives script module mapping, data in the table of corresponding reference data source, inquire about the data of this worksheet, realize in Excel system a workbook file in multi-user environment with cipher inquiry data.
The present invention has following advantages and effect:
1, can meet in multi-user environment, same Excel workbook, by subscriber authorisation is realized with cipher inquiry data, simple to operate, use flexibly.
2, can solve as meeting a plurality of users and inquire about desired data and repeatedly carry out the operation that copies, pastes and create Excel file, solve how many users simultaneously and will create how many Excel files, and the loaded down with trivial details work that a plurality of different Excel files is distributed to one by one to a plurality of different users.The present invention only need create an Excel file, and mass-sending is this Excel file once.Can effectively reduce managerial personnel workload, increase work efficiency.
3, only need make simple modification to Excel worksheet and VBA program and can meet the regulatory requirement in different management environment.
Accompanying drawing explanation
Fig. 1 is spreadsheet systems logic diagram of the present invention;
In figure: 10-human-computer interaction module, 20-VBA drives script module, the grand driver module of 30-, 40-function module, 50-data memory module;
Fig. 2 is spreadsheet systems implementation method process flow diagram of the present invention.
Embodiment
Below in conjunction with embodiment, the invention will be further described, but never in any form the present invention is limited, and any conversion of doing based on training centre of the present invention, all falls into protection domain of the present invention.
As shown in Figure 1, the spreadsheet systems based on multi-user environment of the present invention, comprises that data memory module, grand driver module, VBA drive script module, function module, wherein:
Described data memory module comprises according to multiple Excel worksheets of number of users storage and data source table, macro sheet, user's prompt table;
Described grand driver module is the macro sheet in reading out data memory module driving grand script wherein when user logins, and judges whether user forbids the macroefficiency of described spreadsheet systems, and forbidding exits user's login;
Described VBA drives script module to generate VBA and drives script, with each worksheet in Excel data memory module described in the VBA script encryption generating and forbid that user opens Visual Basic editing machine, when logining, user judges that whether user is legal, legal according to corresponding worksheet in VBA script deciphering Excel data memory module, do not conform to rule and read and show the user's prompt table in described data memory module;
Described function module gathers the user function that VBA drives script module mapping, after analysis user function, according to user function calling excel com interface, search the data in the table of reference data source in described data memory module, by the filling that has returned results cell of user function and the demonstration in Excel.
The user function that described function module gathers the mapping of VBA driving script module is Lookup () function, by Lookup () function, searches the data of quoting data source table in described data memory module;
The grand script that described grand driver module reads and drives is by checking whether the type of error that returns of grand function RUN (" TestMacro ") is 4, judges whether user has forbidden macroefficiency, and result is that True exits user's login.
Described VBA drives in script module with each worksheet in data memory module described in the VBA script encryption of generation and judges that whether login user is legal, it is the Activate event that triggers while clicking worksheet by user, to the Set font of work at present table, be invisible, hide the content of work at present table and eject cryptographic session frame, prompting user inputs password, if Password Input is correct, is perceived color by the Set font of work at present table, Password Input mistake is user's prompt table in return data memory module, forbids that user enters.
Described VBA drives in script module and opens Visual Basic editing machine with the VBA script blocking user who generates, be by VBA script open event in add windows and monitor, once Visual Basic editing machine is opened and just moved VBEwindow process, and call CheckVBE_Event procedure coercion and close Visual Basic editing machine.
As shown in Figure 2, the spreadsheet systems implementation method based on multi-user environment of the present invention, comprises that data memory module creates, function module creates, grand driver module creates, VBA drives script module to create, and concrete steps are:
A, data memory module create: according to number of users, creates and preserve Excel workbook file, and create therein multiple Excel worksheets of inquiring about for users and data source table, macro sheet, user's prompt table;
B, function module create: according to the data of the required inquiry of user, in Excel worksheet, write utility function, the data in the table of described utility function reference data source are as the information that offers user's inquiry;
C, grand driver module create: in described macro sheet, write macrocode, if realize user, forbid grandly when opening Excel workbook, close Excel workbook;
D, VBA drive script module to create: write VBA program the worksheet of step B is encrypted to mandate, realize different user with the corresponding data of cipher inquiry, forbid that user opens Visual Basic editing machine.
Shown in VBA to drive in script module foundation step data source table to be set to keeper's service data special-purpose, be encrypted as administrator's password.
Spreadsheet systems implementation method based on multi-user environment of the present invention also comprises worksheet protection step, described worksheet protection step be the macro sheet in step C be set to not allow user to operate and/or step B in worksheet be set to only allow that user is selected, Copied Cells.
Spreadsheet systems implementation method based on multi-user environment of the present invention also comprises user's prompt table edit step, described user's prompt table edit step is compilation operation prompting in the user's prompt table creating in steps A, for the operation steps to this multi-user electronic form of instruction manual.
Macrocode in described step C is by checking whether the type of error that returns of grand function RUN (" TestMacro ") is 4, if result is True, judges that user forbids macroefficiency and close current Excel book.
In described step D, worksheet is encrypted to mandate, realizing different user is when user clicks worksheet, to trigger Activate event with the corresponding data of cipher inquiry, first event code is invisible by the Set font of work at present table, eject afterwards cryptographic session frame, whether prompting user inputs password and examines password correct, if Password Input is correct, by the Set font of work at present table, is perceived color; If Password Input mistake, returns to described user's prompt table and forbids that user enters.
In described step D, forbid that it is in opening event, to add windows to monitor that user opens Visual Basic editing machine, once Visual Basic editing machine is opened, and moves VBEwindow process, call CheckVBE_Event procedure coercion and close current Visual Basic editing machine.
embodiment 1:
The implementation procedure of the wage detail list of 18Ge subordinate unit of ,Yi Mou iron company is example as shown in Figure 2.
S101: according to number of users and the demand to data query thereof, create Excel workbook file, and this Excel workbook file is named as to " constituent parts wage detail list " is saved in disk;
S102: create 20 Excel worksheets in the Excel workbook having created, first Zhang Gong's tabulation Sheet1 is as user's prompt table, in this table, write brief and concise operation indicating, to the operation steps of this multi-user electronic form of instruction manual, and rename the title of worksheet as " prompting "; The wage data use of our units is inquired about by the 2nd to 19 Zhang Gong's tabulation Gong18Jia units, and worksheet names is renamed as to the title of 18Jia unit; Last worksheet, for store data source, renames " data " as.
S103: will work as monthly salary detailed data and copy in data worksheet, personnel's numbering of Jiang18Jia unit, name copy to respectively in the worksheet of constituent parts, use Lookup () function the data in data source to be referred to respectively in the worksheet of 18Jia unit;
S104: create an excel macro table in this Excel workbook, write macrocode in excel macro table, effect is when opening Excel file, grand if user has been forbidden, and closes this workbook.
S105: above step ready-made each worksheet of institute and macro sheet are protected, and for " prompting " worksheet and macro sheet, protection option is set to not allow user to do any operation; The worksheet of using for Gong18Jia unit's data query, protection option is set to only allow that user is selected, Copied Cells.
S106: write worksheet and " data " data source table that VBA program ,Dui18Jia unit data query uses and be encrypted mandate, allow user with cipher inquiry data, " data " data source table is for wages clerk's service data.
S107: write VBA program, forbid that user opens Visual Basic editing machine, to prevent that user is in using the process of this multi-user electronic form, use Visual Basic editing machine to check, revise, destroy write VBA program.
So far, complete the design of multi-user electronic form system, later wages clerk only needed work as monthly salary data Replica and arrived in data source worksheet " data " every month, then this Excel file group sending Gei18Jia unit was completed to the work of the detailed data of minute paying out wages.
Claims (10)
1. the spreadsheet systems based on multi-user environment, is characterized in that comprising that data memory module, grand driver module, VBA drive script module, function module, wherein:
Described data memory module comprises according to multiple Excel worksheets of number of users storage and data source table, macro sheet, user's prompt table;
Described grand driver module is the macro sheet in reading out data memory module driving grand script wherein when user logins, and judges whether user forbids the macroefficiency of described spreadsheet systems, and forbidding exits user's login;
Described VBA drives script module to generate VBA and drives script, with each worksheet in Excel data memory module described in the VBA script encryption generating and forbid that user opens Visual Basic editing machine, when logining, user judges that whether user is legal, legal according to corresponding worksheet in VBA script deciphering Excel data memory module, do not conform to rule and read and show the user's prompt table in described data memory module;
Described function module gathers the user function that VBA drives script module mapping, after analysis user function, according to user function calling excel com interface, search the data in the table of reference data source in described data memory module, by the filling that has returned results cell of user function and the demonstration in Excel.
2. the spreadsheet systems based on multi-user environment according to claim 1, it is characterized in that grand script that described grand driver module reads and drive is by checking whether the type of error that returns of grand function RUN (" TestMacro ") is 4, judge whether user has forbidden macroefficiency, result is that True exits user's login.
3. the spreadsheet systems based on multi-user environment according to claim 1, it is characterized in that described VBA drives in script module with each worksheet in data memory module described in the VBA script encryption of generation and judges that whether login user is legal, it is the Activate event that triggers while clicking worksheet by user, to the Set font of work at present table, be invisible, hide the content of work at present table and eject cryptographic session frame, prompting user inputs password, if Password Input is correct, is perceived color by the Set font of work at present table, Password Input mistake is user's prompt table in return data memory module, forbid that user enters.
4. according to the spreadsheet systems based on multi-user environment described in claim 1 or 3, it is characterized in that with the VBA script blocking user who generates, opening Visual Basic editing machine in described VBA driving script module, be by VBA script open event in add windows and monitor, once Visual Basic editing machine is opened and just moved VBEwindow process, and call CheckVBE_Event procedure coercion and close Visual Basic editing machine.
5. the spreadsheet systems implementation method based on multi-user environment, is characterized in that comprising that data memory module creates, function module creates, grand driver module creates, VBA drives script module to create, and concrete steps are:
A, data memory module create: according to number of users, creates and preserve Excel workbook file, and create therein multiple Excel worksheets of inquiring about for users and data source table, macro sheet, user's prompt table;
B, function module create: according to the data of the required inquiry of user, in Excel worksheet, write utility function, the data in the table of described utility function reference data source are as the information that offers user's inquiry;
C, grand driver module create: in described macro sheet, write macrocode, if realize user, forbid grandly when opening Excel workbook, close Excel workbook;
D, VBA drive script module to create: write VBA program the worksheet of step B is encrypted to mandate, realize different user with the corresponding data of cipher inquiry, forbid that user opens Visual Basic editing machine.
6. spreadsheet systems implementation method according to claim 5; characterized by further comprising worksheet protection step, described worksheet protection step be the macro sheet in step C be set to not allow user to operate and/or step B in worksheet be set to only allow that user is selected, Copied Cells.
7. spreadsheet systems implementation method according to claim 5, characterized by further comprising user's prompt table edit step, described user's prompt table edit step is compilation operation prompting in the user's prompt table creating in steps A, for the operation steps to this multi-user electronic form of instruction manual.
8. spreadsheet systems implementation method according to claim 5, it is characterized in that the macrocode in described step C is by checking whether the type of error that returns of grand function RUN (" TestMacro ") is 4, if result is True, judge that user forbids macroefficiency and close current Excel book.
9. spreadsheet systems implementation method according to claim 5, it is characterized in that, in described step D, worksheet is encrypted to mandate, realizing different user is when user clicks worksheet, to trigger Activate event with the corresponding data of cipher inquiry, first event code is invisible by the Set font of work at present table, eject afterwards cryptographic session frame, whether prompting user inputs password and examines password correct, if Password Input is correct, by the Set font of work at present table, is perceived color; If Password Input mistake, returns to described user's prompt table and forbids that user enters.
10. according to the spreadsheet systems implementation method described in claim 5 or 9, it is characterized in that forbidding that it is in opening event, to add windows to monitor that user opens Visual Basic editing machine in described step D, once Visual Basic editing machine is opened, and moves VBEwindow process, call CheckVBE_Event procedure coercion and close current Visual Basic editing machine.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201310668494.6A CN103605917A (en) | 2013-12-11 | 2013-12-11 | Spreadsheet system based on multi-user environment and implementation method of spreadsheet system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201310668494.6A CN103605917A (en) | 2013-12-11 | 2013-12-11 | Spreadsheet system based on multi-user environment and implementation method of spreadsheet system |
Publications (1)
Publication Number | Publication Date |
---|---|
CN103605917A true CN103605917A (en) | 2014-02-26 |
Family
ID=50124138
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201310668494.6A Pending CN103605917A (en) | 2013-12-11 | 2013-12-11 | Spreadsheet system based on multi-user environment and implementation method of spreadsheet system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN103605917A (en) |
Cited By (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104914760A (en) * | 2015-05-12 | 2015-09-16 | 山东成泰化工有限公司 | Chromatography analysis data submission control method and device |
CN105589837A (en) * | 2014-10-22 | 2016-05-18 | 北京广利核***工程有限公司 | Automatic electronic document checking method |
CN107742089A (en) * | 2017-09-05 | 2018-02-27 | 广东职业技术学院 | A kind of method that Quick Response Code automatic identification is realized using electrical form |
CN108459848A (en) * | 2017-02-20 | 2018-08-28 | 深圳市北斗智研科技有限公司 | A kind of script acquisition methods and system applied to Excel softwares |
CN109658215A (en) * | 2018-12-10 | 2019-04-19 | 平安科技(深圳)有限公司 | Transaction account calculation method, device and computer readable storage medium |
CN111507077A (en) * | 2020-03-17 | 2020-08-07 | 唐山钢铁集团高强汽车板有限公司 | Method for automatically generating production records of galvanized outlet |
CN111858094A (en) * | 2020-07-14 | 2020-10-30 | 北京海泰方圆科技股份有限公司 | Data copying and pasting method and system and electronic equipment |
CN117151061A (en) * | 2023-10-30 | 2023-12-01 | 建信金融科技有限责任公司 | Method, device, equipment and storage medium for filtering macro opening prompt |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2008022063A2 (en) * | 2006-08-15 | 2008-02-21 | Xllerate Software, Llc | Method and interface for creating a workbook to implement a business process |
US20090300061A1 (en) * | 2007-12-03 | 2009-12-03 | Infosys Technologies Ltd. | System and method for universe generation |
-
2013
- 2013-12-11 CN CN201310668494.6A patent/CN103605917A/en active Pending
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2008022063A2 (en) * | 2006-08-15 | 2008-02-21 | Xllerate Software, Llc | Method and interface for creating a workbook to implement a business process |
US20090300061A1 (en) * | 2007-12-03 | 2009-12-03 | Infosys Technologies Ltd. | System and method for universe generation |
Non-Patent Citations (5)
Title |
---|
ZEZ等: "不同密码进入同一工作簿不同工作表的相关问题", 《HTTP://CLUB.EXCELHOME.NET/THREAD-420247-2-1.HTML》 * |
徐琳: "在Excel中实现数据保护的方法", 《内江科技 》, no. 5, 25 May 2008 (2008-05-25) * |
朱国超等: "Excel中的数据安全管理", 《科技信息》, 15 April 2008 (2008-04-15) * |
李激扬等: "多用户环境下实现Excel的文件管理", 《电脑编程技巧与维护》, 15 February 2001 (2001-02-15) * |
李花等: "用VBA程序保护Excel文件", 《计算机与现代化》, no. 9, 18 September 2013 (2013-09-18) * |
Cited By (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105589837A (en) * | 2014-10-22 | 2016-05-18 | 北京广利核***工程有限公司 | Automatic electronic document checking method |
CN105589837B (en) * | 2014-10-22 | 2019-03-08 | 北京广利核***工程有限公司 | A kind of automatic errordetecting method of electronic document |
CN104914760A (en) * | 2015-05-12 | 2015-09-16 | 山东成泰化工有限公司 | Chromatography analysis data submission control method and device |
CN108459848A (en) * | 2017-02-20 | 2018-08-28 | 深圳市北斗智研科技有限公司 | A kind of script acquisition methods and system applied to Excel softwares |
CN107742089A (en) * | 2017-09-05 | 2018-02-27 | 广东职业技术学院 | A kind of method that Quick Response Code automatic identification is realized using electrical form |
CN107742089B (en) * | 2017-09-05 | 2021-03-16 | 广东职业技术学院 | Method for automatically identifying two-dimensional code by using spreadsheet |
CN109658215A (en) * | 2018-12-10 | 2019-04-19 | 平安科技(深圳)有限公司 | Transaction account calculation method, device and computer readable storage medium |
CN111507077A (en) * | 2020-03-17 | 2020-08-07 | 唐山钢铁集团高强汽车板有限公司 | Method for automatically generating production records of galvanized outlet |
CN111858094A (en) * | 2020-07-14 | 2020-10-30 | 北京海泰方圆科技股份有限公司 | Data copying and pasting method and system and electronic equipment |
CN117151061A (en) * | 2023-10-30 | 2023-12-01 | 建信金融科技有限责任公司 | Method, device, equipment and storage medium for filtering macro opening prompt |
CN117151061B (en) * | 2023-10-30 | 2024-02-02 | 建信金融科技有限责任公司 | Method, device, equipment and storage medium for filtering macro opening prompt |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN103605917A (en) | Spreadsheet system based on multi-user environment and implementation method of spreadsheet system | |
US9569596B2 (en) | Secure workflow and data management facility | |
CN108604225A (en) | It is created by the collaborative document that multiple and different team carry out | |
CN103093154B (en) | One is determined confidential information management system and determines confidential information management method | |
CN104471595A (en) | Workflow management device and workflow management method | |
CN102043981A (en) | Public real-time attendance management system and method | |
CN106202021A (en) | By multiple users real-time synchronization documents editing to blog | |
EP2289030A2 (en) | Business software application system and method | |
CN105653255B (en) | A method of report template is set in OFFICE frames to automatically generate report file | |
CN102402733A (en) | Diversified electronic accounting file management system and method | |
CN111046421A (en) | Enterprise management sharing method based on APP | |
CN111815290B (en) | Territorial space planning system based on GIS | |
CN112541692A (en) | Scientific data management plan generation method and device | |
CN105187220A (en) | Centralized script material printing management system | |
CN102999810B (en) | A kind of bank application system management platform and authority control method | |
CN102567372A (en) | Student information management system | |
CN105225176B (en) | Warrant basic information system | |
CN103886448A (en) | Paperless network office system | |
CN107733880A (en) | Scheduling disciplines management information system | |
CN103971224A (en) | Signing method and system | |
CN102436599A (en) | Secret determination information accounting method based on cascade secret determination information synchronous processing system | |
Ma | Design and implementation of financial information system for mobile devices | |
Asatiani et al. | Security by envelopment–a novel approach to data-security-oriented configuration of lightweight-automation systems | |
CN102385725A (en) | Document managing system based on workflow drive and managing method utilizing same | |
RU35154U1 (en) | Energy Holding Management Device |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20140226 |
|
RJ01 | Rejection of invention patent application after publication |