openpreserve / odf-validator

Open source Open Document Format (ODF) validation
http://odf.openpreservation.org/
BSD 3-Clause "New" or "Revised" License
3 stars 0 forks source link

ODF_8: Macros #96

Closed carlwilson closed 7 months ago

carlwilson commented 8 months ago

The file MUST NOT contain any macros .

Conversion to ODF often results in loss of Macros. If a conversion to ODF automatically removes macros then no further action need be taken. Otherwise, they must be removed after conversion to ODF format.

Additionally, Macros contain programming code that can execute and manipulate data in the spreadsheet and the file system. These may present security risks, and it is therefore prudent to remove any macros.

Typically macros are used to change data, and this goes against the intentions of preserving the data fixed in time, and removal may therefore often happen with no implications.

The macros are stored inside the directory Basic/Standard. A good way to detect a macro is to search for the text dispatcher.executeDispatch.