Issue 124282 - use Apache POI to validate the ooxml file that exported by AOO
Summary: use Apache POI to validate the ooxml file that exported by AOO
Status: UNCONFIRMED
Alias: None
Product: Build Tools
Classification: Code
Component: code (show other issues)
Version: 4.1.0-dev
Hardware: All All
: P3 Minor (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: https://poi.apache.org/overview.html
Keywords:
Depends on:
Blocks:
 
Reported: 2014-02-21 07:44 UTC by zhaoshzh
Modified: 2014-02-24 03:19 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description zhaoshzh 2014-02-21 07:44:40 UTC
use poi to validate the ooxml file that exported by AOO
Comment 1 zhaoshzh 2014-02-21 07:55:07 UTC
because the attachment is more than 1M, so I put it at
http://pan.baidu.com/s/1c0f5KNA
Comment 2 Rainer Bielefeld 2014-02-21 08:00:16 UTC
Seems we are talking about the Apache POI?

@zhaoshzh:
Please contribute meaningful descriptions what also can be understood by not inaugurated users
Comment 4 Rob Weir 2014-02-21 14:14:23 UTC
This sounds like a "task" not a "defect". The task would be to integrate OOXML validation into the test automation.

Note:  Microsoft also has an OOXML validator in their Open XML SDK:

http://blogs.msdn.com/b/ericwhite/archive/2010/03/04/validate-open-xml-documents-using-the-open-xml-sdk-2-0.aspx

When we design the automation maybe we can support both POI and Microsoft validators, so both can be run and we find more errors that way.
Comment 5 zhaoshzh 2014-02-24 03:19:16 UTC
yes,we will also bring Microsoft validators in AOO automation test.
(In reply to Rob Weir from comment #4)
> This sounds like a "task" not a "defect". The task would be to integrate
> OOXML validation into the test automation.
> 
> Note:  Microsoft also has an OOXML validator in their Open XML SDK:
> 
> http://blogs.msdn.com/b/ericwhite/archive/2010/03/04/validate-open-xml-
> documents-using-the-open-xml-sdk-2-0.aspx
> 
> When we design the automation maybe we can support both POI and Microsoft
> validators, so both can be run and we find more errors that way.