Research of Automated Test Case Generation for Spreadsheet Part in Document Format Translator

Document format translator can achieve information sharing and interoperability between the office document national standard UOF (Uniform office format) and the international standard ISO29500 (Open office XML, OOXML). There are several difficult issues in the manual test of document format translator: the manual test case design is complicated due to the complexity of document standard; test case coverage rate is hard to evaluate and test blind spots are hard to avoid. This paper brings about methods to solve these problems by achieving automated test case generation. Analyzing the XML Schema of document standard in logical level, building UML object model in conceptual level, designing objectoriented algorithm based on the .Net platform, operate the underlying XML code of spreadsheet in physical level, and then compress underlying XML code to generate new spreadsheet documents as test case. A formal definition about the UOF document standard is presented and statistics of functional test point is conducted so as to measure test case coverage rate. Experiments have shown that this method can realize the automated generation of test cases, improve the efficiency of test work, decrease test case redundancy and avoid test blind spots.