An Improvement about Cell Editing Mode of the OWC Spreadsheet
YANG Xiang,DING Wen-jie
DOI: https://doi.org/10.3969/j.issn.1672-9528.2010.06.17
2010-01-01
Abstract:OWC Spreadsheet is used by engineering and technical personnel to input data,calculate data and save data online in the Web page.Generally,format specification for computing template has been defined in the enterprises,and implies that the Spreadsheet cell data should be inputted,selected from a collection or shouldn't be edited by some rules.The Spreadsheet cell itself is free to input any data.So it is prone to human error,and it maybe undermines contents of the XML Spreadsheet.In this paper,it is assumed that enterprise uses cell shading to identify editing mode,and an improvement is applied on the Spreadsheet under the VS.Net 2005.Through compositing Spreadsheet,text boxes,list boxes and other controls by ATL Composite framework,the new generated control enables the engineering and technical personnel that only uses the text box to input data,list box to select data,or can not edit the data according to the cell shading.So the improvement prevents accidental operation,protects the contents of XML Spreadsheet,and improves efficiency.