Attachment 104361 Details for Bug 82401 – Export html: color scale and boolean condition cells have no background

Export html: color scale and boolean condition cells have no background

color-scale-vs-boolean-export.html (text/html), 8.10 KB, created by gekacheka on 2014-08-10 01:11:08 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: gekacheka

Created: 2014-08-10 01:11:08 UTC

Size: 8.10 KB

patch

obsolete

><?xml version="1.0" encoding="UTF-8"?>
><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1 plus MathML 2.0//EN" "http://www.w3.org/Math/DTD/mathml2/xhtml-math11-f.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head profile="http://dublincore.org/documents/dcmi-terms/"><meta http-equiv="Content-Type" content="application/xhtml+xml; charset=utf-8"/><title xml:lang="en-US">Color-scale vs Boolean conditional formatting</title><meta name="DCTERMS.title" content="Color-scale vs Boolean conditional formatting" xml:lang="en-US"/><meta name="DCTERMS.language" content="en-US" scheme="DCTERMS.RFC4646"/><meta name="DCTERMS.source" content="http://xml.openoffice.org/odf2xhtml"/><meta name="DCTERMS.issued" content="2014-08-09T18:44:55.025000000" scheme="DCTERMS.W3CDTF"/><meta name="DCTERMS.modified" content="2014-08-09T21:00:19.157000000" scheme="DCTERMS.W3CDTF"/><meta name="DCTERMS.provenance" content="" xml:lang="en-US"/><meta name="DCTERMS.subject" content="," xml:lang="en-US"/><meta name="DCTERMS.description" content="Samples using LibreOffice menu&#10;Format / Conditional Formatting / Color Scale ...&#10;&#10;2-color sample:&#10;white (value 0) to light red (value 40)&#10;&#10;3-color sample: &#10;light blue (value 0) to white (value 23) to light red (value 40)&#10;&#10;Boolean sample:&#10;light blue (value &lt; 20), red (value &gt; 28)&#10;&#10;As of LibreOffice 4.3, neither&#10;File / Export ... / format: html&#10;nor&#10;File / Save as ... / format: html&#10;produces html with cell background colors from color-scale.&#10;&#10;The boolean background colors do not appear for &#10;File / Export ... / format: html&#10;but the boolean backgrounds colors DO appear for&#10;File / Save as ... / format: html&#10;&#10;&#10;&#10;" xml:lang="en-US"/><link rel="schema.DC" href="http://purl.org/dc/elements/1.1/" hreflang="en"/><link rel="schema.DCTERMS" href="http://purl.org/dc/terms/" hreflang="en"/><link rel="schema.DCTYPE" href="http://purl.org/dc/dcmitype/" hreflang="en"/><link rel="schema.DCAM" href="http://purl.org/dc/dcam/" hreflang="en"/><style type="text/css">
>	@page { }
>	table { border-collapse:collapse; border-spacing:0; empty-cells:show }
>	td, th { vertical-align:top; font-size:10pt;}
>	h1, h2, h3, h4, h5, h6 { clear:both }
>	ol, ul { margin:0; padding:0;}
>	li { list-style: none; margin:0; padding:0;}
>	
>	li span. { clear: both; line-height:0; width:0; height:0; margin:0; padding:0; }
>	span.footnodeNumber { padding-right:1em; }
>	span.annotation_style_by_filter { font-size:95%; font-family:Arial; background-color:#fff000; margin:0; border:0; padding:0; }
>	* { margin:0;}
>	.ta1 { writing-mode:lr-tb; }
>	.Default { font-family:Liberation Sans; }
>	.ce1 { font-family:Liberation Sans; background-color:#c0c0c0; font-weight:bold; }
>	.ce2 { font-family:Liberation Sans; background-color:#c0c0c0; font-weight:bold; }
>	.ce3 { font-family:Liberation Sans; }
>	.ce4 { font-family:Liberation Sans; }
>	.ce5 { font-family:Liberation Sans; }
>	.ce6 { font-family:Liberation Sans; }
>	.co1 { width:0.889in; }
>	.ro1 { height:0.178in; }
>	
>	 { }
>	</style></head><body dir="ltr" style="writing-mode:lr-tb; "><table border="0" cellspacing="0" cellpadding="0" class="ta1"><colgroup><col width="99"/><col width="99"/><col width="99"/><col width="99"/><col width="99"/><col width="99"/><col width="99"/><col width="99"/></colgroup><tr class="ro1"><td style="text-align:left;width:0.889in; " class="ce1">(2-color)</td><td style="text-align:left;width:0.889in; " class="ce1">Mo</td><td style="text-align:left;width:0.889in; " class="ce1">Tu</td><td style="text-align:left;width:0.889in; " class="ce1">We</td><td style="text-align:left;width:0.889in; " class="ce1">Th</td><td style="text-align:left;width:0.889in; " class="ce1">Fr</td><td style="text-align:left;width:0.889in; " class="ce1">Sa</td><td style="text-align:left;width:0.889in; " class="ce1">Su</td></tr><tr class="ro1"><td style="text-align:right; width:0.889in; " class="ce2">2014-07-28</td><td style="text-align:right; width:0.889in; " class="ce4">32</td><td style="text-align:right; width:0.889in; " class="ce4">29</td><td style="text-align:right; width:0.889in; " class="ce4">23</td><td style="text-align:right; width:0.889in; " class="ce4">18</td><td style="text-align:right; width:0.889in; " class="ce4">14</td><td style="text-align:right; width:0.889in; " class="ce4">20</td><td style="text-align:right; width:0.889in; " class="ce4">25</td></tr><tr class="ro1"><td style="text-align:left;width:0.889in; " class="ce3">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td></tr><tr class="ro1"><td style="text-align:left;width:0.889in; " class="ce1">(3-color)</td><td style="text-align:left;width:0.889in; " class="ce1">Mo</td><td style="text-align:left;width:0.889in; " class="ce1">Tu</td><td style="text-align:left;width:0.889in; " class="ce1">We</td><td style="text-align:left;width:0.889in; " class="ce1">Th</td><td style="text-align:left;width:0.889in; " class="ce1">Fr</td><td style="text-align:left;width:0.889in; " class="ce1">Sa</td><td style="text-align:left;width:0.889in; " class="ce1">Su</td></tr><tr class="ro1"><td style="text-align:right; width:0.889in; " class="ce2">2014-07-28</td><td style="text-align:right; width:0.889in; " class="ce5">32</td><td style="text-align:right; width:0.889in; " class="ce5">29</td><td style="text-align:right; width:0.889in; " class="ce5">23</td><td style="text-align:right; width:0.889in; " class="ce5">18</td><td style="text-align:right; width:0.889in; " class="ce5">14</td><td style="text-align:right; width:0.889in; " class="ce5">20</td><td style="text-align:right; width:0.889in; " class="ce5">25</td></tr><tr class="ro1"><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td></tr><tr class="ro1"><td style="text-align:left;width:0.889in; " class="ce1">(boolean)</td><td style="text-align:left;width:0.889in; " class="ce1">Mo</td><td style="text-align:left;width:0.889in; " class="ce1">Tu</td><td style="text-align:left;width:0.889in; " class="ce1">We</td><td style="text-align:left;width:0.889in; " class="ce1">Th</td><td style="text-align:left;width:0.889in; " class="ce1">Fr</td><td style="text-align:left;width:0.889in; " class="ce1">Sa</td><td style="text-align:left;width:0.889in; " class="ce1">Su</td></tr><tr class="ro1"><td style="text-align:right; width:0.889in; " class="ce2">2014-07-28</td><td style="text-align:right; width:0.889in; " class="ce6">32</td><td style="text-align:right; width:0.889in; " class="ce6">29</td><td style="text-align:right; width:0.889in; " class="ce6">23</td><td style="text-align:right; width:0.889in; " class="ce6">18</td><td style="text-align:right; width:0.889in; " class="ce6">14</td><td style="text-align:right; width:0.889in; " class="ce6">20</td><td style="text-align:right; width:0.889in; " class="ce6">25</td></tr></table></body></html>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1 plus MathML 2.0//EN" "http://www.w3.org/Math/DTD/mathml2/xhtml-math11-f.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><!--This file was converted to xhtml by LibreOffice - see http://cgit.freedesktop.org/libreoffice/core/tree/filter/source/xslt for the code.--><head profile="http://dublincore.org/documents/dcmi-terms/"><meta http-equiv="Content-Type" content="application/xhtml+xml; charset=utf-8"/><title xml:lang="en-US">Color-scale vs Boolean conditional formatting</title><meta name="DCTERMS.title" content="Color-scale vs Boolean conditional formatting" xml:lang="en-US"/><meta name="DCTERMS.language" content="en-US" scheme="DCTERMS.RFC4646"/><meta name="DCTERMS.source" content="http://xml.openoffice.org/odf2xhtml"/><meta name="DCTERMS.issued" content="2014-08-09T18:44:55.025000000" scheme="DCTERMS.W3CDTF"/><meta name="DCTERMS.modified" content="2014-08-09T21:00:19.157000000" scheme="DCTERMS.W3CDTF"/><meta name="DCTERMS.provenance" content="" xml:lang="en-US"/><meta name="DCTERMS.subject" content="," xml:lang="en-US"/><meta name="DCTERMS.description" content="Samples using LibreOffice menu&#10;Format / Conditional Formatting / Color Scale ...&#10;&#10;2-color sample:&#10;white (value 0) to light red (value 40)&#10;&#10;3-color sample: &#10;light blue (value 0) to white (value 23) to light red (value 40)&#10;&#10;Boolean sample:&#10;light blue (value &lt; 20), red (value &gt; 28)&#10;&#10;As of LibreOffice 4.3, neither&#10;File / Export ... /   format: html&#10;nor&#10;File / Save as ... / format: html&#10;produces html with cell background colors from color-scale.&#10;&#10;The boolean background colors do not appear for &#10;File / Export ... / format: html&#10;but the boolean backgrounds colors DO appear for&#10;File / Save as ... / format: html&#10;&#10;&#10;&#10;" xml:lang="en-US"/><link rel="schema.DC" href="http://purl.org/dc/elements/1.1/" hreflang="en"/><link rel="schema.DCTERMS" href="http://purl.org/dc/terms/" hreflang="en"/><link rel="schema.DCTYPE" href="http://purl.org/dc/dcmitype/" hreflang="en"/><link rel="schema.DCAM" href="http://purl.org/dc/dcam/" hreflang="en"/><style type="text/css">
	@page {  }
	table { border-collapse:collapse; border-spacing:0; empty-cells:show }
	td, th { vertical-align:top; font-size:10pt;}
	h1, h2, h3, h4, h5, h6 { clear:both }
	ol, ul { margin:0; padding:0;}
	li { list-style: none; margin:0; padding:0;}
	<!-- "li span.odfLiEnd" - IE 7 issue-->
	li span. { clear: both; line-height:0; width:0; height:0; margin:0; padding:0; }
	span.footnodeNumber { padding-right:1em; }
	span.annotation_style_by_filter { font-size:95%; font-family:Arial; background-color:#fff000;  margin:0; border:0; padding:0;  }
	* { margin:0;}
	.ta1 { writing-mode:lr-tb; }
	.Default { font-family:Liberation Sans; }
	.ce1 { font-family:Liberation Sans; background-color:#c0c0c0; font-weight:bold; }
	.ce2 { font-family:Liberation Sans; background-color:#c0c0c0; font-weight:bold; }
	.ce3 { font-family:Liberation Sans; }
	.ce4 { font-family:Liberation Sans; }
	.ce5 { font-family:Liberation Sans; }
	.ce6 { font-family:Liberation Sans; }
	.co1 { width:0.889in; }
	.ro1 { height:0.178in; }
	<!-- ODF styles with no properties representable as CSS -->
	 { }
	</style></head><body dir="ltr" style="writing-mode:lr-tb; "><table border="0" cellspacing="0" cellpadding="0" class="ta1"><colgroup><col width="99"/><col width="99"/><col width="99"/><col width="99"/><col width="99"/><col width="99"/><col width="99"/><col width="99"/></colgroup><tr class="ro1"><td style="text-align:left;width:0.889in; " class="ce1"><p>(2-color)</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>Mo</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>Tu</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>We</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>Th</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>Fr</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>Sa</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>Su</p></td></tr><tr class="ro1"><td style="text-align:right; width:0.889in; " class="ce2"><p>2014-07-28</p></td><td style="text-align:right; width:0.889in; " class="ce4"><p>32</p></td><td style="text-align:right; width:0.889in; " class="ce4"><p>29</p></td><td style="text-align:right; width:0.889in; " class="ce4"><p>23</p></td><td style="text-align:right; width:0.889in; " class="ce4"><p>18</p></td><td style="text-align:right; width:0.889in; " class="ce4"><p>14</p></td><td style="text-align:right; width:0.889in; " class="ce4"><p>20</p></td><td style="text-align:right; width:0.889in; " class="ce4"><p>25</p></td></tr><tr class="ro1"><td style="text-align:left;width:0.889in; " class="ce3">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td></tr><tr class="ro1"><td style="text-align:left;width:0.889in; " class="ce1"><p>(3-color)</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>Mo</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>Tu</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>We</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>Th</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>Fr</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>Sa</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>Su</p></td></tr><tr class="ro1"><td style="text-align:right; width:0.889in; " class="ce2"><p>2014-07-28</p></td><td style="text-align:right; width:0.889in; " class="ce5"><p>32</p></td><td style="text-align:right; width:0.889in; " class="ce5"><p>29</p></td><td style="text-align:right; width:0.889in; " class="ce5"><p>23</p></td><td style="text-align:right; width:0.889in; " class="ce5"><p>18</p></td><td style="text-align:right; width:0.889in; " class="ce5"><p>14</p></td><td style="text-align:right; width:0.889in; " class="ce5"><p>20</p></td><td style="text-align:right; width:0.889in; " class="ce5"><p>25</p></td></tr><tr class="ro1"><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td><td style="text-align:left;width:0.889in; " class="Default">Â </td></tr><tr class="ro1"><td style="text-align:left;width:0.889in; " class="ce1"><p>(boolean)</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>Mo</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>Tu</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>We</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>Th</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>Fr</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>Sa</p></td><td style="text-align:left;width:0.889in; " class="ce1"><p>Su</p></td></tr><tr class="ro1"><td style="text-align:right; width:0.889in; " class="ce2"><p>2014-07-28</p></td><td style="text-align:right; width:0.889in; " class="ce6"><p>32</p></td><td style="text-align:right; width:0.889in; " class="ce6"><p>29</p></td><td style="text-align:right; width:0.889in; " class="ce6"><p>23</p></td><td style="text-align:right; width:0.889in; " class="ce6"><p>18</p></td><td style="text-align:right; width:0.889in; " class="ce6"><p>14</p></td><td style="text-align:right; width:0.889in; " class="ce6"><p>20</p></td><td style="text-align:right; width:0.889in; " class="ce6"><p>25</p></td></tr></table></body></html>

Actions: View

Attachments on bug 82401: 104360 | 104361 | 104362 | 104363