https://issues.apache.org/bugzilla/show_bug.cgi?id=51616
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: [email protected]
ReportedBy: [email protected]
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: [email protected]
For additional commands, e-mail: [email protected]
