Apache OpenOffice (AOO) Bugzilla – Issue 75010
export to xhtml, cell background color shifts
Last modified: 2013-08-07 15:13:10 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.
Created attachment 43463 [details] This is the openoffice file (note row 25 starts with dark blue, and goes over in yellow at column AW)
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
Hi Swante, have a look at this one please. Frank
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?
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
We upgraded to OpenOffice 2.2 and problem still occurs.
Set target to OOo 2.3
There were too many OOo 2.3 issues, therefore I am sorry that I have to postpone the target of the XHTML issues..
change target from 2.x to 3.x according to http://wiki.services.openoffice.org/wiki/Target_3x
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.