Skip to content
This repository has been archived by the owner on Nov 9, 2020. It is now read-only.

Excel 2003: Sanitised files still have a reference to the Macros #14

Closed
punkeel opened this issue May 2, 2017 · 2 comments
Closed

Excel 2003: Sanitised files still have a reference to the Macros #14

punkeel opened this issue May 2, 2017 · 2 comments

Comments

@punkeel
Copy link
Contributor

punkeel commented May 2, 2017

When OLE2 (files up to Office 2003) are sanitised, and Macros are removed, the "Workbook"/"Document" entry still knows about them and generates an error or a Warning.

Help asked on the Apache POI Mailing list, in hope someone has a clue on how to fix it.

This has no impact on the sanitation process, but displays ugly warnings.

Excel warning 1

Excel warning 2

@punkeel
Copy link
Contributor Author

punkeel commented May 3, 2017

For Excel files, the ObProj Record tells Excel if macros are present or not.
This record is "unknown" to Apache POI, unfortunately.

2.4.185 ObProj
The existence of the ObProj record specifies that there is a VBA project in the file. This project is located in the VBA storage stream.

Source

punkeel added a commit that referenced this issue May 3, 2017
@punkeel punkeel changed the title OLE2: Sanitised files still have a reference to the Macros Excel: Sanitised files still have a reference to the Macros May 3, 2017
@punkeel punkeel changed the title Excel: Sanitised files still have a reference to the Macros Excel 2003: Sanitised files still have a reference to the Macros May 3, 2017
@punkeel
Copy link
Contributor Author

punkeel commented May 3, 2017

Bug split into three issues, as the code will be different between Excel, Word and PowerPoint.

This one can be closed, then, fixed in 15b6d44

@punkeel punkeel closed this as completed May 3, 2017
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant