View All Attachments for Bug 82401

Attachment #104360
Color scale vs. boolean conditional formatting: ods spreadsheet	application/vnd.oasis.opendocument.spreadsheet	2014-08-10 01:06:42 UTC	23.40 KB	no flags	Details

Attachment cannot be viewed because its MIME type is not text/*, image/*, or application/vnd.mozilla.*. Download the attachment instead.

Attachment #104361
Export html: color scale and boolean condition cells have no background	text/html	2014-08-10 01:11:08 UTC	8.10 KB	no flags	Details

<?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>

Attachment #104362
Export PDF: color scale and boolean condition cells DO have background	application/pdf	2014-08-10 01:13:31 UTC	19.02 KB	no flags	Details

Attachment cannot be viewed because its MIME type is not text/*, image/*, or application/vnd.mozilla.*. Download the attachment instead.

Attachment #104363
Save as html: boolean condition cells DO have background, color scale cells have no background	text/html	2014-08-10 01:15:35 UTC	4.85 KB	no flags	Details

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
	
	<meta http-equiv="content-type" content="text/html; charset=windows-1252"/>
	<title>Color-scale vs Boolean conditional formatting</title>
	<meta name="generator" content="LibreOffice 4.3.0.4 (Windows)"/>
	<meta name="created" content="2014-08-09T18:44:55.025000000"/>
	<meta name="changed" content="2014-08-09T21:00:19.157000000"/>
	<meta name="description" content="Samples using LibreOffice menu
Format / Conditional Formatting / Color Scale ...

2-color sample:
white (value 0) to light red (value 40)

3-color sample: 
light blue (value 0) to white (value 23) to light red (value 40)

Boolean sample:
light blue (value &lt; 20), red (value &gt; 28)

As of LibreOffice 4.3, neither
File / Export ... /   format: html
nor
File / Save as ... / format: html
produces html with cell background colors from color-scale.

The boolean background colors do not appear for 
File / Export ... / format: html
but the boolean backgrounds colors DO appear for
File / Save as ... / format: html



"/>
	
	<style type="text/css">
		body,div,table,thead,tbody,tfoot,tr,th,td,p { font-family:"Liberation Sans"; font-size:x-small }
	</style>
	
</head>

<body>
<table cellspacing="0" border="0">
	<colgroup span="8" width="85"></colgroup>
	<tr>
		<td height="17" align="left" bgcolor="#C0C0C0"><b>(2-color)</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>Mo</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>Tu</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>We</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>Th</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>Fr</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>Sa</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>Su</b></td>
	</tr>
	<tr>
		<td height="17" align="right" bgcolor="#C0C0C0" sdval="41848" sdnum="1033;0;YYYY-MM-DD"><b>2014-07-28</b></td>
		<td align="right" sdval="32" sdnum="1033;">32</td>
		<td align="right" sdval="29" sdnum="1033;">29</td>
		<td align="right" sdval="23" sdnum="1033;">23</td>
		<td align="right" sdval="18" sdnum="1033;">18</td>
		<td align="right" sdval="14" sdnum="1033;">14</td>
		<td align="right" sdval="20" sdnum="1033;">20</td>
		<td align="right" sdval="25" sdnum="1033;">25</td>
	</tr>
	<tr>
		<td height="17" align="left" sdnum="1033;0;YYYY-MM-DD"><br></td>
		<td align="left"><br></td>
		<td align="left"><br></td>
		<td align="left"><br></td>
		<td align="left"><br></td>
		<td align="left"><br></td>
		<td align="left"><br></td>
		<td align="left"><br></td>
	</tr>
	<tr>
		<td height="17" align="left" bgcolor="#C0C0C0"><b>(3-color)</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>Mo</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>Tu</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>We</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>Th</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>Fr</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>Sa</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>Su</b></td>
	</tr>
	<tr>
		<td height="17" align="right" bgcolor="#C0C0C0" sdval="41848" sdnum="1033;0;YYYY-MM-DD"><b>2014-07-28</b></td>
		<td align="right" sdval="32" sdnum="1033;">32</td>
		<td align="right" sdval="29" sdnum="1033;">29</td>
		<td align="right" sdval="23" sdnum="1033;">23</td>
		<td align="right" sdval="18" sdnum="1033;">18</td>
		<td align="right" sdval="14" sdnum="1033;">14</td>
		<td align="right" sdval="20" sdnum="1033;">20</td>
		<td align="right" sdval="25" sdnum="1033;">25</td>
	</tr>
	<tr>
		<td height="17" align="left"><br></td>
		<td align="left"><br></td>
		<td align="left"><br></td>
		<td align="left"><br></td>
		<td align="left"><br></td>
		<td align="left"><br></td>
		<td align="left"><br></td>
		<td align="left"><br></td>
	</tr>
	<tr>
		<td height="17" align="left" bgcolor="#C0C0C0"><b>(boolean)</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>Mo</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>Tu</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>We</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>Th</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>Fr</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>Sa</b></td>
		<td align="left" bgcolor="#C0C0C0"><b>Su</b></td>
	</tr>
	<tr>
		<td height="17" align="right" bgcolor="#C0C0C0" sdval="41848" sdnum="1033;0;YYYY-MM-DD"><b>2014-07-28</b></td>
		<td align="right" bgcolor="#FF3366" sdval="32" sdnum="1033;">32</td>
		<td align="right" bgcolor="#FF3366" sdval="29" sdnum="1033;">29</td>
		<td align="right" sdval="23" sdnum="1033;">23</td>
		<td align="right" bgcolor="#9999FF" sdval="18" sdnum="1033;">18</td>
		<td align="right" bgcolor="#9999FF" sdval="14" sdnum="1033;">14</td>
		<td align="right" sdval="20" sdnum="1033;">20</td>
		<td align="right" sdval="25" sdnum="1033;">25</td>
	</tr>
</table>
<!-- ************************************************************************** -->
</body>

</html>