OWC Spreadsheet单元格编辑方式的改进

An Improvement about Cell Editing Mode of the OWC Spreadsheet

工程技术人员在W eb页面通过OWC Spreadsheet在线输入数据、计算数据和保存数据。虽然企业一般在计算模板中定义了格式规范,以某种规则表明该单元格的编辑方式——输入或选择或不能编辑,但是Spreadsheet的单元格可以自由输入数据,容易产生人为错误,可能破坏XML表格内容。本文假定企业使用单元格底纹表明编辑形式,在VS.Net 2005开发环境下对Spreadsheet做了改进,采用ATL复合控件的方法对Spreadsheet、文本框、下拉列表框等控件进行封装,新生成的控件可根据单元格底纹限制工程技术人员只能在文本框中输入、下拉列表框中选择或者不能编辑,避免误操作,保护XML表格内容,提高工作效率。

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.