Spreadsheet-based dynamic multi-regional report processing system and its method

Abstract

The invention provides a spreadsheet-based dynamic multi-regional report processing system, including: the interface setting module, used to set the basic parameters of the described spreadsheet; the dynamic regional setting module, used to set the property definition of the spreadsheet dynamic region, the basic parameters of which have been set; its characteristics are that it also includes the multi-regional management module used for the data-dependent processing and regional expansion processing in a variety of dynamic region. Thus it allows setting up multiple dynamic regions without anyconstraint on the direction expansion and their relative positions.

Description

technical field [0001] The invention relates to a report processing technology based on an electronic form, and more particularly relates to a report processing system and method based on an electronic form with multiple dynamic regions. Background technique [0002] Implementing reports based on dynamic data in spreadsheets is a common user request. If the layout of the report to be processed is complex and the data is not from a single source, multiple dynamic data areas will appear in one report. These dynamic data often need to be correlated, and because the size of the dynamic data volume cannot be known in advance in the format design, it is often impossible to predict and accurately design the final report display effect. [0003] In order to unify the terms, we have agreed on the name of the area expansion direction. For the area that will expand into multiple rows, we call it the vertical expansion area; It is called a two-way extension area. [0004] Existing si...

AI Technical Summary

Problems solved by technology

This solution obviously cannot meet the needs of users, because it is never possible to predict whether there will be overlapping regions during the report design process.

Images