基于双程序协作的属性扩展与局部数据更新

Attribute Extension and Local Data Update Based on Double-Program Collaboration

对表格数据软件颜色样式赋值和区域控制扩展方法进行研究,针对软件中颜色样式只支持单一设置的问题,研究了常用表格处理程序的VBA脚本、组建独立数据处理组件的扩展设计方法。对于传统方法的不足,提出设计独立的主控程序定义映射视角数据结构,通过视图数据结构控制视角的集合实现对颜色样式的扩展,主控程序的视图颜色分组UI界面操纵视角颜色分组,实现样式赋值和区域控制单一设置的扩展。

This paper studies the color style setting and extension method of region control on table data software. Aiming at the problem of the software only supports single settings for the color and style, it studies the extension design method of VBA scripts for common table processing programs and independent data of component processing components. For the shortcomings of the traditional method, an independent master program is proposed to define the mapping perspective data structure, and controls the set of perspective to expand the color and style through the view data structure. The view color grouping UI interface of the master program controls the perspective color grouping to realize the expansion of a single setting of style assignment and area control.