Guidance for using cells in tables (ODF Spreadsheets)

[Jesper Lund Stocholm <4a4553504552@gmail.com>]

As I have been adding support to the .Net-library AODL for cells with
dates in spreadsheets, I have had some trouble understanding what the
intended usage of <table:table-cell> and its attributes are.

In the specific case, my implementation creates the following markup
for a cell in a spreadsheet with a date in it:

<table:table-cell office:value-type="date"
office:date-value="2009-10-08T09:45:00" />

However, the <table:table-cell>-element also allows storing paragraphs
in them, so an equally valid markup would be

<table:table-cell office:value-type="date"
office:date-value="2009-10-08T09:45:00" >
  <text:p>08-10-2009 9:45</text:p>
</table:table-cell>

(note that the date itself is stored in UTC-format whereas the
paragraph contains the date formatted for Danish locale/culture)

This markup led me to create this markup, which is valid (I presume)
but doesn't make a lot of sense.

<table:table-cell office:value-type="date"
office:date-value="2009-10-08T09:45:00" >
  <text:p>No date, just text</text:p>
</table:table-cell>

Now, I have been trying to find some guidance in ODF spec to the
intended application behaviour - but I have found nothing on the
subject. For instance, should the <text:p>-element be ingored, if the
cell is of type "date"? Should (a conflicting) value-type of the cell
be ignored, if the cell has a paragraph in it?

(I assume this ambiguity applies to all conflicts between cell value
type and specific content in the cell)

So my question is really, is the behaviour in this scenario purely
application defined - or is there some guidance in ODF spec, that I
have missed?

-- 
Jesper Lund Stocholm
www.idippedut.dk
SC34/WG4 http://www.itscj.ipsj.or.jp/sc34/wg4/