CN103902511A - Data conversion and amplifying display method and system for data table - Google Patents

Data conversion and amplifying display method and system for data table Download PDF

Info

Publication number
CN103902511A
CN103902511A CN201210575209.1A CN201210575209A CN103902511A CN 103902511 A CN103902511 A CN 103902511A CN 201210575209 A CN201210575209 A CN 201210575209A CN 103902511 A CN103902511 A CN 103902511A
Authority
CN
China
Prior art keywords
data
switching
amplification
application rule
attribute
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201210575209.1A
Other languages
Chinese (zh)
Other versions
CN103902511B (en
Inventor
刘娟
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Yuanguang Software Co Ltd
Original Assignee
Yuanguang Software Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Yuanguang Software Co Ltd filed Critical Yuanguang Software Co Ltd
Priority to CN201210575209.1A priority Critical patent/CN103902511B/en
Publication of CN103902511A publication Critical patent/CN103902511A/en
Application granted granted Critical
Publication of CN103902511B publication Critical patent/CN103902511B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Abstract

The invention discloses a data conversion and amplifying display method and system for a data table. The method comprises the following steps that 1, a data conversion and amplifying application rule template database of the data table is set; 2, cursor coordinate information on the data table is acquired; 3, a target data row corresponding to a cursor is determined according to the cursor coordinate information; 4, a target data column is determined; 5, a data conversion and amplification target data cell is determined according to the target data row and the target data column; 6, data conversion and amplifying display is carried out on the target data cell according to a data conversion and amplifying application rule template corresponding to the data column attribute of the data table. According to the technical scheme, regularized data conversion and amplification can be carried out according to the data column attribute of the data table, the problem that when a large-data-volume data table is checked at present, reading visual fatigue is generated due to too much numerical data is solved, data and amplifying display are simplified, and the work efficiency of a user is improved.

Description

A kind of data-switching amplification display method and system of data form
Technical field
The present invention relates to a kind of data amplification display method and system, be specifically related to data-switching amplification display method and the system of the list data such as finance and finance.
Background technology
Citation form when mostly data form (comprising the EXCEL data form in amateur field and finance and the financial class software data form of professional domain) is to edit or stores is at present shown, and there is the shortcoming of Dyslexia in these basic display forms, amount of money data rows and account No. data rows etc. as a lot of in figure place, often misunderstand can cause user to read, inquire about time.
At present, although existed, the regional area of picture is amplified to the method showing, as the technical scheme of Chinese patent 03154866.0, but its equal proportion that only limits to former figure is amplified (as shown in Figure 5), fail in conjunction with some expert data as the Business Nature feature of finance/financial business data form, data rows is amplified and carried out the conversion of specialized service rule (or attribute) while showing.And some expert data as finance/financial field has a lot of data forms, data rows information is the attribute that has specific transactions implication and business norms, be only that equal proportion is amplified the attribute of failing to make full use of these expert data and carried out characterization and simplify and show, also can not meet the demonstration requirement of modern data form far away.
Summary of the invention
The object of the invention is to for the problems referred to above weak point, a kind of display packing and the system that can carry out according to the data rows attribute of data form the amplification of regularization data-switching is provided, it solves while checking at present Volume data form because numerical data too much produces the problem of reading visual fatigue, its reduced data and amplification show, improve user job efficiency.
In order to achieve the above object, the present invention is by the following technical solutions:
A data-switching amplification display method for data form, it comprises the following steps:
Step 1, the data-switching that data form is set is amplified application rule masterplate database, and described data-switching is amplified application rule masterplate and is formulated according to data rows attribute;
Step 2, obtains the cursor coordinates information on data form;
Step 3, determines according to cursor coordinates information the target data row that cursor is corresponding;
Step 4, compares the data rows attribute of the data rows attribute of data form and data-switching amplification application rule masterplate database to mate, and determines target data row;
Step 5, according to the target data unit lattice of above-mentioned target data row and target data row specified data conversion amplification;
Step 6, target data unit lattice amplify application rule masterplate according to data-switching corresponding to its data rows attribute and carry out data-switching amplification demonstration.
Further, described data-switching amplify application rule masterplate according to the Rule content of corresponding data rows setup of attribute comprise following one or more: whether amplify demonstration, the scope of application, whether by quantity or amount of money unit amount to demonstrations, whether increase Currency Type symbol, whether segmentation shows, whether by complete trails displaying, whether only show fiducial value, whether only show self-defining value, magnification ratio and amplification time limit.
Further, described data-switching is amplified application rule masterplate provides the function of manual selective rule content to select to arrange the page.
Further, in step 1, described data-switching is amplified application rule masterplate and data form carries out function match.
A data-switching amplifying display system for data form, it comprises with lower module:
Masterplate is built library module, amplifies the database of application rule masterplate for the data-switching of data form is set, and described data-switching is amplified application rule masterplate and formulated according to data rows attribute;
Cursor coordinates capture module, user obtains the cursor coordinates information on data form;
Target data row locating module, for determining the target data row that cursor is corresponding according to cursor coordinates information;
Target data row locating module, for the data rows attribute of the data rows attribute of data form and data-switching amplification application rule masterplate database is compared and mated, determines target data row;
Target data unit lattice locating module, according to the target data unit lattice of above-mentioned target data row and target data row specified data conversion amplification;
Data-switching amplification module, amplifies application rule masterplate for target data unit lattice according to data-switching corresponding to its data rows attribute and carries out data-switching amplification demonstration.
Further, described data-switching amplify application rule masterplate according to the Rule content of corresponding data rows setup of attribute comprise following one or more: whether amplify demonstration, the scope of application, whether by quantity or amount of money unit amount to demonstrations, whether increase Currency Type symbol, whether segmentation shows, whether by complete trails displaying, whether only show fiducial value, whether only show self-defining value, magnification ratio and amplification time limit.
Further, system of the present invention also comprises function selecting module, provides the function of manual selective rule content to select to arrange the page for data-switching being amplified to application rule masterplate.
Further, system of the present invention also comprises function match module, for described data-switching amplification application rule masterplate and data form are carried out to function match.
Technical solution of the present invention can be carried out the amplification of regularization data-switching according to the data rows attribute of data form, it solves while checking at present Volume data form because numerical data too much produces the problem of reading visual fatigue, its reduced data and amplification show, improve user job efficiency.
Accompanying drawing explanation
Fig. 1 is the basic flow sheet of the inventive method.
Fig. 2 is system chart of the present invention.
Fig. 3 is that the function of data-switching amplification application rule masterplate of the present invention selects to arrange page legend.
Fig. 4 is that data-switching of the present invention is amplified application display effect legend.
Fig. 5 is the former figure equal proportion amplification effect legend of prior art.
Come by the drawings and specific embodiments below that the invention will be further described:
Embodiment
As shown in Figure 1, the data-switching amplification display method of a kind of data form of the present invention, it can be applicable to the EXCEL data form in amateur field and finance and the financial class software data form of professional domain, dissimilar data are carried out the conversion of specialized service rule and amplify showing by its attribute, facilitate user's reading and browsing, its enforcement comprises the following steps:
Step 1, the data-switching that data form is set is amplified the database of application rule masterplate, and described data-switching is amplified application rule masterplate and is formulated according to data rows attribute.The corresponding data-switching of each data rows attribute is amplified application rule masterplate.Described data rows attribute refers to that data rows exists the attribute of data, as amount of money attribute, account No. attribute or date property etc., described data-switching is amplified application rule masterplate according to corresponding data rows setup of attribute Rule content, described Rule content comprise following one or more: whether amplify demonstration, the scope of application (applying unit, form types), whether amount to demonstration (as payment 2 by quantity or amount of money unit, 000, 000, 000 converts 20 to, 0000000), whether increase Currency Type symbol, whether segmentation shows (chopping rule, as bank), whether pressing complete trails shows, whether only show fiducial value, whether only show self-defining value, magnification ratio and amplification time limit.Described data-switching is amplified application rule masterplate provides the function of manual selective rule content to select the page is set, as shown in Figure 3.
Step 2, obtains the cursor coordinates information on data form.
Step 3, determines according to cursor coordinates information the target data row that cursor is corresponding.This step is the selected data line that carries out data-switching amplification, i.e. target data row.
Step 4, compares the data rows attribute of the data rows attribute of data form and data-switching amplification application rule masterplate database to mate, and determines target data row.This step object is: the data rows attribute that obtains its existence from data form, as wherein the 3rd classified amount of money attribute, the 5th as and classify bank account attribute as, data rows attribute contrast with database, the data rows that definite existence can data transformation be amplified application rule masterplate, the target data row that can data transformation amplify.Other data rows attribute can not matching database data rows, it is ignored, it is not carried out to data-switching amplification.
Step 5, according to the target data unit lattice of above-mentioned target data row and target data row specified data conversion amplification.The common factor data cells of above-mentioned target data row and target data row is exactly the target data unit lattice that data transformation is amplified.The target area that this step is amplified for last specified data conversion, i.e. target data unit lattice.
Step 6, target data unit lattice amplify application rule masterplate according to data-switching corresponding to its data rows attribute and carry out data-switching amplification demonstration.Target data unit lattice are according to its data rows attribute, it is the data rows attribute that Set cell is corresponding, as amount of money attribute, adopt with amount of money attribute corresponding data conversion amplification application rule masterplate it is amplified, this masterplate content can comprise that magnification ratio, amplification time limit and amount of money unit amount to demonstration etc., and amount of money unit amounts to and shows as be 200,000 the amount of money, 000 is shown as 20,000 ten thousand; And for example account No. attribute, adopt with account No. attribute corresponding data conversion amplification application rule masterplate it is amplified, this masterplate content can comprise magnification ratio, amplification time limit and segmentation demonstration etc., as carried out segmentation demonstration according to the chopping rule of 4-4-4-3, be specially bank account 403982093849081, segmentation is shown as 403982093849081, easy-to-read.Display effect can be with reference to Fig. 4.
Further, in step 1, described data-switching is amplified application rule masterplate and is carried out function match with data form, detects the whether application function of applicable data form of data-switching amplification application rule masterplate.
The data-switching amplifying display system that the invention also discloses a kind of data form completely corresponding with said method, it comprises with lower module:
Masterplate is built library module M1, amplifies the database of application rule masterplate for the data-switching of data form is set, and described data-switching is amplified application rule masterplate and formulated according to data rows attribute.The corresponding data-switching of each data rows attribute is amplified application rule masterplate.Described data rows attribute refers to that data rows exists the attribute of data, as amount of money attribute, account No. attribute or date property etc., described data-switching is amplified application rule masterplate according to corresponding data rows setup of attribute Rule content, described Rule content comprise following one or more: whether amplify demonstration, the scope of application (applying unit, form types), whether amount to demonstration (as payment 2 by quantity or amount of money unit, 000, 000, 000 converts 20 to, 0000000), whether increase Currency Type symbol, whether segmentation shows (chopping rule, as bank), whether pressing complete trails shows, whether only show fiducial value, whether only show self-defining value, magnification ratio and amplification time limit.As shown in Figure 3.
Cursor coordinates capture module M2, user obtains the cursor coordinates information on data form;
Target data row locating module M3, for determining the target data row that cursor is corresponding according to cursor coordinates information;
Target data row locating module M4, for the data rows attribute of the data rows attribute of data form and data-switching amplification application rule masterplate database is compared and mated, determines target data row;
Target data unit lattice locating module M5, according to the target data unit lattice of above-mentioned target data row and target data row specified data conversion amplification;
Data-switching amplification module M6, amplifies application rule masterplate for target data unit lattice according to data-switching corresponding to its data rows attribute and carries out data-switching amplification demonstration.
Further, system of the present invention also comprises function selecting module, provides the function of manual selective rule content to select the page is set, as shown in Figure 3 for data-switching is amplified to application rule masterplate.
Further, system of the present invention also comprises function match module, carries out function match for described data-switching is amplified to application rule masterplate with data form, detects the whether application function of applicable data form of data-switching amplification application rule masterplate.
Technical solution of the present invention can be carried out the amplification of regularization data-switching according to the data rows attribute of data form, it solves while checking at present Volume data form because numerical data too much produces the problem of reading visual fatigue, its reduced data and amplification show, improve user job efficiency.

Claims (8)

1. a data-switching amplification display method for data form, is characterized in that comprising the following steps:
Step 1, the data-switching that data form is set is amplified application rule masterplate database, and described data-switching is amplified application rule masterplate and is formulated according to data rows attribute;
Step 2, obtains the cursor coordinates information on data form;
Step 3, determines according to cursor coordinates information the target data row that cursor is corresponding;
Step 4, compares the data rows attribute of the data rows attribute of data form and data-switching amplification application rule masterplate database to mate, and determines target data row;
Step 5, according to the target data unit lattice of above-mentioned target data row and target data row specified data conversion amplification;
Step 6, target data unit lattice amplify application rule masterplate according to data-switching corresponding to its data rows attribute and carry out data-switching amplification demonstration.
2. a kind of data-switching amplification display method of data form according to claim 1, it is characterized in that, described data-switching amplify application rule masterplate according to the Rule content of corresponding data rows setup of attribute comprise following one or more: whether amplify demonstration, the scope of application, whether by quantity or amount of money unit amount to demonstrations, whether increase Currency Type symbol, whether segmentation shows, whether by complete trails displaying, whether only show fiducial value, whether only show self-defining value, magnification ratio and amplification time limit.
3. a kind of data-switching amplification display method of data form according to claim 1, is characterized in that, described data-switching is amplified application rule masterplate provides the function of manual selective rule content to select to arrange the page.
4. a kind of data-switching amplification display method of data form according to claim 1, is characterized in that, in step 1, described data-switching is amplified application rule masterplate and data form carries out function match.
5. a data-switching amplifying display system for data form, is characterized in that comprising with lower module:
Masterplate is built library module, amplifies application rule masterplate database for the data-switching of data form is set, and described data-switching is amplified application rule masterplate and formulated according to data rows attribute;
Cursor coordinates capture module, user obtains the cursor coordinates information on data form;
Target data row locating module, for determining the target data row that cursor is corresponding according to cursor coordinates information;
Target data row locating module, for the data rows attribute of the data rows attribute of data form and data-switching amplification application rule masterplate database is compared and mated, determines target data row;
Target data unit lattice locating module, according to the target data unit lattice of above-mentioned target data row and target data row specified data conversion amplification;
Data-switching amplification module, amplifies application rule masterplate for target data unit lattice according to data-switching corresponding to its data rows attribute and carries out data-switching amplification demonstration.
6. a kind of data-switching amplifying display system of data form according to claim 5, it is characterized in that: described data-switching amplify application rule masterplate according to the Rule content of corresponding data rows setup of attribute comprise following one or more: whether amplify demonstration, the scope of application, whether by quantity or amount of money unit amount to demonstrations, whether increase Currency Type symbol, whether segmentation shows, whether by complete trails displaying, whether only show fiducial value, whether only show self-defining value, magnification ratio and amplification time limit.
7. a kind of data-switching amplifying display system of data form according to claim 5, is characterized in that: also comprise function selecting module, provide the function of manual selective rule content to select to arrange the page for data-switching being amplified to application rule masterplate.
8. a kind of data-switching amplification display method of data form according to claim 5, is characterized in that: also comprise function match module, for described data-switching being amplified to application rule masterplate and data form carries out function match.
CN201210575209.1A 2012-12-26 2012-12-26 The data conversion amplification display method and system of a kind of data form Active CN103902511B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201210575209.1A CN103902511B (en) 2012-12-26 2012-12-26 The data conversion amplification display method and system of a kind of data form

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201210575209.1A CN103902511B (en) 2012-12-26 2012-12-26 The data conversion amplification display method and system of a kind of data form

Publications (2)

Publication Number Publication Date
CN103902511A true CN103902511A (en) 2014-07-02
CN103902511B CN103902511B (en) 2017-07-28

Family

ID=50993841

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201210575209.1A Active CN103902511B (en) 2012-12-26 2012-12-26 The data conversion amplification display method and system of a kind of data form

Country Status (1)

Country Link
CN (1) CN103902511B (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105515956A (en) * 2015-12-31 2016-04-20 小米科技有限责任公司 Method and device for displaying communication messages
CN105573978A (en) * 2015-12-10 2016-05-11 温州雏鹰科技有限公司 Short message service information processing method and device
CN106649210A (en) * 2015-10-30 2017-05-10 北京国双科技有限公司 Data conversion method and device
CN106940690A (en) * 2017-03-06 2017-07-11 锐达互动科技股份有限公司 A kind of interactive electric whiteboard software form and chart method for mutually conversing and system
CN108932268A (en) * 2017-05-26 2018-12-04 华为软件技术有限公司 Data processing method and device

Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1614900A (en) * 2003-11-07 2005-05-11 英华达（南京）科技有限公司 Amplifying and displaying method for local area of picture
CN1811809A (en) * 2005-01-25 2006-08-02 北京网联热线网络有限公司 Image displaying method for stadium orgymnasium ticket selling web page
CN101118563A (en) * 2007-09-21 2008-02-06 金蝶软件（中国）有限公司 process and device for displaying electric form
WO2009006063A2 (en) * 2007-06-29 2009-01-08 Microsoft Corporation Automatic designation of xbrl taxonomy tags
US20090276692A1 (en) * 2008-05-05 2009-11-05 Norm Rosner Method and System for Data Analysis
CN101578575A (en) * 2006-09-22 2009-11-11 Opera软件股份公司 Method and device for selecting and displaying a region of interest in an electronic document
US20100205521A1 (en) * 2009-02-11 2010-08-12 Microsoft Corporation Displaying multiple row and column header areas in a summary table
CN102089759A (en) * 2008-07-09 2011-06-08 凯森公司 A method of generating an analytical data set for input into an analytical model
US20110283182A1 (en) * 2007-09-28 2011-11-17 Microsoft Corporation Graphical creation of a document conversion template

Patent Citations (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1614900A (en) * 2003-11-07 2005-05-11 英华达（南京）科技有限公司 Amplifying and displaying method for local area of picture
CN1811809A (en) * 2005-01-25 2006-08-02 北京网联热线网络有限公司 Image displaying method for stadium orgymnasium ticket selling web page
CN101578575A (en) * 2006-09-22 2009-11-11 Opera软件股份公司 Method and device for selecting and displaying a region of interest in an electronic document
WO2009006063A2 (en) * 2007-06-29 2009-01-08 Microsoft Corporation Automatic designation of xbrl taxonomy tags
CN101118563A (en) * 2007-09-21 2008-02-06 金蝶软件（中国）有限公司 process and device for displaying electric form
US20110283182A1 (en) * 2007-09-28 2011-11-17 Microsoft Corporation Graphical creation of a document conversion template
US20090276692A1 (en) * 2008-05-05 2009-11-05 Norm Rosner Method and System for Data Analysis
CN102089759A (en) * 2008-07-09 2011-06-08 凯森公司 A method of generating an analytical data set for input into an analytical model
US20100205521A1 (en) * 2009-02-11 2010-08-12 Microsoft Corporation Displaying multiple row and column header areas in a summary table
CN102317931A (en) * 2009-02-11 2012-01-11 微软公司 Multiple row header areas and/or multiple column header areas for display in summary table

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106649210A (en) * 2015-10-30 2017-05-10 北京国双科技有限公司 Data conversion method and device
CN105573978A (en) * 2015-12-10 2016-05-11 温州雏鹰科技有限公司 Short message service information processing method and device
CN105515956A (en) * 2015-12-31 2016-04-20 小米科技有限责任公司 Method and device for displaying communication messages
CN106940690A (en) * 2017-03-06 2017-07-11 锐达互动科技股份有限公司 A kind of interactive electric whiteboard software form and chart method for mutually conversing and system
CN108932268A (en) * 2017-05-26 2018-12-04 华为软件技术有限公司 Data processing method and device
CN108932268B (en) * 2017-05-26 2020-09-04 华为技术有限公司 Data processing method and device

Also Published As

Publication number Publication date
CN103902511B (en) 2017-07-28

Similar Documents

Publication Publication Date Title
US9213893B2 (en) Extracting data from semi-structured electronic documents
CN103902511A (en) Data conversion and amplifying display method and system for data table
CN107317725A (en) The method for visualizing and system of a kind of block chain
KR20140009295A (en) Associating captured image data with a spreadsheet
CN104572783A (en) Webpage click condition displaying method and device
CN106326802B (en) Quick Response Code bearing calibration, device and terminal device
CN102567345A (en) Method and device for generating bookkeeping voucher
CN102722537A (en) Database test data generation method and system thereof
CN110516221A (en) Extract method, equipment and the storage medium of chart data in PDF document
CN105528447A (en) Method for rejecting and summarizing specific data layer by layer simultaneously
Jeon et al. Performance evaluation of R&D commercialization: A dea-based three-stage model of R&BD performance
Newton Minitab cookbook
CN111125221B (en) Excel format-based data extraction system and configuration method
CN106528419B (en) A kind of test method and device of operation system
CN107562710B (en) Chart processing device and method
CN105573972A (en) Report check formula generation method and apparatus
CN102831137B (en) A kind of methods of exhibiting of company information and the system based on the method
CN105718434A (en) Natural language formula editing method and system
CN104679880A (en) Device and method for dynamically storing and displaying dynamic input items and business data thereof
CN105912515A (en) Business object display method and business object display device
CN105320742A (en) Method for mapping subject information of traditional financial statement to XBRL classification standard format
CN107861931A (en) Template file processing method, device, computer equipment and storage medium
CN103699482A (en) Method and device for testing reasonableness of controls
CN106909570B (en) Data conversion method and device
CN103606175B (en) The display packing of a kind of map hotspot icon and controller

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant