[Libreoffice-bugs] [Bug 109259] New: FILESAVE: ODS vs XLS conditional formating

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=109259

            Bug ID: 109259
           Summary: FILESAVE: ODS vs XLS conditional formating
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dhrm77 at gmail.com

First, I am using LibreOffice Calc Version 5.1.6.2 on Ubunt 16/04.2
There are multiple problems with conditional formatting
I tried to color-code based on value a series of cells
So I use this:

Condition 1
All Cells             Color Scale (3 entries)
Value                 Percentile                Value
1                      60                       120
light red             yellow                    Green

And at first, when I apply these settings to a bunch of cells with values 1 to
127, it works ok.
Then, If I save the file as an .XLS format, and reload it, all the formatting
is gone, all cells are white again.
Instead, if I save the file as an .ODS format, and reload it, some of the
formatting is gone, and some is formatted wrong. 
For example, I might have 1 or 2 column formatted with colors, and the rest
with a white background.
But even the cells that are colored are wrong, some cells that should be green
are yellow instead. If I try to edit the condition, it appears that it is what
I set it to be. It just renders wrong.

If I try to copy that format (that was saved and reloaded), the copied cells
are also not working right, but if I recreate the colorscale condition, and
copy that new condition (that looked identical), then the coloring is working
again.

Please let me know if you need a sample file.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170721/6bd8c695/attachment.html>