Bug 82401

Summary: EXPORT HTML: omits color scale background color, unlike export PDF
Product: LibreOffice Reporter: gekacheka
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal CC: raal
Priority: medium    
Version: 4.3.0.4 release   
Hardware: Other   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Color scale vs. boolean conditional formatting: ods spreadsheet
Export html: color scale and boolean condition cells have no background
Export PDF: color scale and boolean condition cells DO have background
Save as html: boolean condition cells DO have background, color scale cells have no background

Description gekacheka 2014-08-10 00:34:41 UTC 
Export HTML omits the color scale background color, unlike export PDF.

Steps to reproduce:
1. Create numerical data cells such as a row of data 1, 2, 3, 4, 5, 6, 7
   Select the cells.
2. Format / Conditional Formatting / Color Scale ... 
   (default is 3-color scale from min value, to 50%, to max value)
   click OK
   (cells should now have varying background colors depending on values)
3. File / Export ... 
   select File Format: html
   click Save

Actual result:  HTML table cells have no background colors
Expected result:  HTML table cells do have background colors like spreadsheet



In contrast:
4. File / Export as PDF ...
   Click Export
   Click Save

Actual result: PDF table cells have background colors like spreadsheet


In contrast:
5. File Save As ...
   select File format: html
   click Save

Actual Result: HTML table cells have no background colors
Expected result:  HTML table cells do have background colors like spreadsheet


In contrast:  
bug 37878 attachment 47475 [details] uses boolean conditional formatting, not a color scale.
File / Export ... (file format: html): html table cells have no background colors
File / Save As ... (file format: html): html table cells DO have background colors like spreadsheet
Comment 1 gekacheka 2014-08-10 01:06:42 UTC 
Created attachment 104360 [details]
Color scale vs. boolean conditional formatting: ods spreadsheet
Comment 2 gekacheka 2014-08-10 01:11:08 UTC 
Created attachment 104361 [details]
Export html: color scale and boolean condition cells have no background
Comment 3 gekacheka 2014-08-10 01:13:31 UTC 
Created attachment 104362 [details]
Export PDF: color scale and boolean condition cells DO have background
Comment 4 gekacheka 2014-08-10 01:15:35 UTC 
Created attachment 104363 [details]
Save as html: boolean condition cells DO have background, color scale cells have no background
Comment 5 raal 2014-09-15 15:15:36 UTC 
Hello,
the bug has previously been reported, so this bug will be added as a duplicate of it. You will automatically be CCed to updates made to the other bug.
Duplicate of bug 37878.

*** This bug has been marked as a duplicate of bug 37878 ***