ODF_7: Content

[carlwilson]

It is quite possible that some cell values in a spreadsheet are missing. This is not considered an error.

A complete spreadsheet without any cell values or objects is most likely empty of content. To easily check this, read the meta.xml and check if meta:cell-count or meta:object-count is greater than 0.

If no cell values or objects exist, the file must be appraised to determine if other kind of content exists. If so, the file may be preserved.

Information may be stored in user defined properties or color formatting of cells may have been used to semantically convey a message. These are potential occurrences, which after appraisal could lead to preserving the spreadsheet.

[carlwilson]

This should be fairly straightforward as an empty sheet looks as follows:

<office:spreadsheet>
    <table:calculation-settings table:automatic-find-labels="false" table:use-regular-expressions="false" table:use-wildcards="true"/>
    <table:table table:name="Sheet1" table:style-name="ta1">
        <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
        <table:table-row table:style-name="ro1">
            <table:table-cell/>
        </table:table-row>
    </table:table>
    <table:named-expressions/>
</office:spreadsheet>

Remember that a spreadsheet comprises multiple worksheets. What's the policy on empty worksheets in a spreadsheet where other worksheets have content?