To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68011
------- Additional comments from [EMAIL PROTECTED] Tue Jan 16 03:50:14 -0800 2007 ------- This issue is a tricky one, as in OpenDocument / Calc we are using the mechanism of default cell styles, which are used for cells without cell style to add the color, where spreadsheetml / Excel uses column colors. In OOo the cell have to exist, explicitly written as table:cell in a table:row, before it get's a default cell style and with that a color. In Excel rows can be empty, but the column is still colored. The problem is the roundtrip for XSLT. A color from a spreadsheetml column style and as well the color from a single cell is both represented by a default cell style color in OpenDocument. The only difference between them in ODF is that for the single colored cell only one cell exists. But it is nearly impossible to know for XSLT, if all cells exists for a column in all 64k rows. To check this the performance would break down, when writing out cell styles the Excel XML document would in our case grow from 7KB to 4MB, which is neither acceptable. The solution the repetiton of rows by the ss:Span attribute does not work in Excel 2003 although specified. Uncertain how to solve this issue. Most likely I will repeat the colored colums for the first n times (e.g. for the first 256 rows). This is not perfect, but would work for most of the cases. Suggestions are welcome.. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
