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
Created attachment 104360 [details] Color scale vs. boolean conditional formatting: ods spreadsheet
Created attachment 104361 [details] Export html: color scale and boolean condition cells have no background
Created attachment 104362 [details] Export PDF: color scale and boolean condition cells DO have background
Created attachment 104363 [details] Save as html: boolean condition cells DO have background, color scale cells have no background
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 ***