OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

opendocument-users message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Re: [opendocument-users] Guidance for using cells in tables (ODFSpreadsheets)

And why exactly would one want to do something like this?  From the 
business logic view, I'd consider an application that put conflicting 
values in a cell to have  a bug.  I can't see any legitimate use case 
where this would be desired.   Maybe if you can explain what your intent 
is, we can tell you how to represent it in ODF.


Jesper Lund Stocholm <4a4553504552@gmail.com>
ODF Users List <opendocument-users@lists.oasis-open.org>
10/08/2009 07:54 AM
[opendocument-users] Guidance for using cells in tables (ODF Spreadsheets)

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>

(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>

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
SC34/WG4 http://www.itscj.ipsj.or.jp/sc34/wg4/

To unsubscribe, e-mail: 
For additional commands, e-mail: 

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]