Public Comment

[comment-form@oasis-open.org]

Comment from: Stefan Nikolaus

Name: Stefan Nikolaus
Title: 'just a man'
Organization: (unofficial) KDE
Regarding Specification: OpenDocument

fyi

----------  Forwarded Message  ----------

Subject: [opendocument-users] Re: How to interpret the default-cell-style-name attribute in spreadsheets
Date: Saturday 06 May 2006 10:43
From: Stefan Nikolaus (UNTRUSTED, sender is "opendocument-users-return-130-stefan.nikolaus=kdemail.net@lists.oasis-open.org") <stefan.nikolaus@kdemail.net>
To: opendocument-users@lists.oasis-open.org

Hi,

as the "default-cell-style-name" attribute is part of the "table:column"
("table:row") element, it has to apply to the whole column (row).

The OpenOffice.org developers say, that it has to apply to the used area
 only. IMHO, this is wrong.

The third paragraph "8.1 Basic table model" is the relevant section. It
states, that on saving only the used area is saved. Taking only this into
account, I would have agreed with the OO.o people. But refering to the more
detailed loading description in there, I come to the conclusion, that the
attribute applies to the whole column (row).

More detailed discussion:
http://bugs.kde.org/show_bug.cgi?id=107956
http://qa.openoffice.org/issues/show_bug.cgi?id=51235

It would be appreciated, if someone could enlighten us here.

Regards,
Stefan

-------------------------------------------------------
----------  Forwarded Message  ----------

Subject: How to interpret the default-cell-style-name attribute in spreadsheets
From: "Robert Knight" <robertknight@gmail.com>
To: opendocument-users@lists.oasis-open.org
Date: Sun, 19 Mar 2006 15:14:49 +0000
Hello,

I am working on the OASIS support in the upcoming KSpread 1.5 release,
and have reached a stumbling block.

In spreadsheet tables, columns and rows can have a default style for
cells (specified using the default-cell-style-name attribute) which
are applied to cells that don't have any specific style set.

However, what isn't clear is whether this style should be used for
every cell in the column / row, including those which are
automatically created to fill in incomplete rows in the content.xml
file, or whether this style should only be used on cells that are
represented by a table-cell element in the content.xml file.

eg, if we have a spreadsheet with a single row:

[Empty Table Cell x3] [Cell with own Style] [Automatically created
cells to end of row...]

And the row as a default-cell-style-name attribute, should that style
apply to just the 3 empty table cells at the beginning of the row
(which are represented by a table-cell element in the XML file with
the repeat columns attribute set) or all of the Automatically created
cells at the end of the row as well?

Regards,
Robert Knight.
-------------------------------------------------------