Issue 75010

Summary: export to xhtml, cell background color shifts
Product: Calc Reporter: rhodix <dispatch>
Component: save-exportAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.1   
Target Milestone: ---   
Hardware: Sun   
OS: Solaris   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
This is the openoffice file (note row 25 starts with dark blue, and goes over in yellow at column AW)
none
This is the xhtml file, note that the "standby row" now starts with yellow, and the dark blue is fallen away none

Description rhodix 2007-03-01 10:21:43 UTC 
In openoffice we use a spreadsheet with background colored cells representing a
person (person A is red, Person B is yellow). We have made a calendar where
every column is one day.

Each week we hide the week that's been in openoffice spreadsheet. After that we
export it to xhtml. However, when we open it in a browser, some colors have changed.

This happens specifically if you hide only a few columns from a row that has
more of the same background color in a sequence.

For example.

Row 6, column 2 until 10 are red. Column 11 until 18 are yellow, 19 until 27 are
green.

When we hide column 2 until 6, in OpenOffice, column are 7 until 10 are still red.

However, in xhtml, these cells are yellow, and everything is shoved 5 cells to
the left.
Comment 1 rhodix 2007-03-01 10:24:43 UTC 
Created attachment 43463 [details]
This is the openoffice file (note row 25 starts with dark blue, and goes over in yellow at column AW)
Comment 2 rhodix 2007-03-01 10:25:48 UTC 
Created attachment 43464 [details]
This is the xhtml file, note that the "standby row" now starts with yellow, and the dark blue is fallen away
Comment 3 frank 2007-03-01 11:09:14 UTC 
Hi Swante,

have a look at this one please.

Frank
Comment 4 rhodix 2007-04-17 14:58:02 UTC 
I just wondered if this issue has been looked at, and if it is a common bug.
Also, if it cant be solved, what should I do? Is there somewhere else where I
can submit an issue?
Comment 5 svante.schubert 2007-04-17 15:38:36 UTC 
Thanks for the reminder, rhodix!

I have not worked on the XHTML export filter for months, due to other projects,
but I plan to take a look into it - and most likely fix it - in three weeks.

Added this issues to my XHTML related CWS XSLTFILTER08 with target for OO.o 2.3

Svante
Comment 6 rhodix 2007-05-03 09:08:10 UTC 
We upgraded to OpenOffice 2.2 and problem still occurs.
Comment 7 svante.schubert 2007-06-25 09:46:49 UTC 
Set target to OOo 2.3
Comment 8 svante.schubert 2007-07-24 13:26:48 UTC 
There were too many OOo 2.3 issues, therefore I am sorry that I have to postpone
the target of the XHTML issues..
Comment 9 Martin Hollmichel 2007-11-09 16:52:44 UTC 
change target from 2.x to 3.x according to
http://wiki.services.openoffice.org/wiki/Target_3x
Comment 10 svante.schubert 2008-01-14 18:57:45 UTC 
I can reproduce the problem. 
After inserting text content in your colored cells, the problem was revealed:
The partial hidden repeated cells are always completely hidden.