poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 51616] New: Calling setAutoFilter triggers a problem by Office File Validation security plugin.
Date Thu, 04 Aug 2011 19:22:03 GMT

             Bug #: 51616
           Summary: Calling setAutoFilter triggers a problem by Office
                    File Validation security plugin.
           Product: POI
           Version: 3.8-dev
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: robert.kish@ncogroup.com
    Classification: Unclassified

Created attachment 27349
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=27349
Program to create a file with an auto filter.

I create a HSSFWorkbook with a sheet. I want to specify that each of the column
headings be in an auto-filter. (I would do this manually in Excel by Selecting
Row 1, Data -> Filter -> Auto Filter). I issue the code to set the auto filter.

When I open the resulting XLS file using Excel 2003, the new file validation
plugin provides the error message:
Office File Validation detected a problem while trying to open this file.
Opening it may be dangerous.

If I ignore the error, and open the document anyway, the filter is valid.

If I rebuild the file and don't include the filter in the new version, it opens
without warning message by Excel.

Therefore, there's something that POI is doing with auto filters that the
Microsoft Plugin does not like.

(If I do a save as in Excel with the filter and save the document, when I
reopen it, the filter is still there and there is no warning).

I have attached a demo program to create a document in XLS and XLSX format. The
XLS document makes Excel 2003 complain. The XLSX document opens fine in 2003.

Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message