<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body><span class="vcard"><a class="email" href="mailto:vstuart.foote@utsa.edu" title="V Stuart Foote <vstuart.foote@utsa.edu>"> <span class="fn">V Stuart Foote</span></a>
</span> changed
          <a class="bz_bug_link 
          bz_status_NEW "
   title="NEW - wrong Bar color name in the Data bar dialog (#0000FF instead of Blue)"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=125288">bug 125288</a>
          <br>
             <table border="1" cellspacing="0" cellpadding="8">
          <tr>
            <th>What</th>
            <th>Removed</th>
            <th>Added</th>
          </tr>

         <tr>
           <td style="text-align:right;">Component</td>
           <td>UI
           </td>
           <td>Calc
           </td>
         </tr>

         <tr>
           <td style="text-align:right;">CC</td>
           <td>
                
           </td>
           <td>erack@redhat.com, vstuart.foote@utsa.edu
           </td>
         </tr>

         <tr>
           <td style="text-align:right;">Summary</td>
           <td>wrong color name in Data bar dialog (#0000FF instead Blue)
           </td>
           <td>wrong Bar color name in the Data bar dialog (#0000FF instead of Blue)
           </td>
         </tr>

         <tr>
           <td style="text-align:right;">Keywords</td>
           <td>regression
           </td>
           <td>
                
           </td>
         </tr>

         <tr>
           <td style="text-align:right;">Version</td>
           <td>6.2.3.2 release
           </td>
           <td>6.1.0.0.alpha0+
           </td>
         </tr></table>
      <p>
        <div>
            <b><a class="bz_bug_link 
          bz_status_NEW "
   title="NEW - wrong Bar color name in the Data bar dialog (#0000FF instead of Blue)"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=125288#c2">Comment # 2</a>
              on <a class="bz_bug_link 
          bz_status_NEW "
   title="NEW - wrong Bar color name in the Data bar dialog (#0000FF instead of Blue)"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=125288">bug 125288</a>
              from <span class="vcard"><a class="email" href="mailto:vstuart.foote@utsa.edu" title="V Stuart Foote <vstuart.foote@utsa.edu>"> <span class="fn">V Stuart Foote</span></a>
</span></b>
        <pre>Hmm, not really a regression. From the 6.1.0 release the color value for our
RYB scheme named Blue is #2a6099; color value assigned from the standard .SOC
(based on the Gossett & Chen ryb2rgb algorithm interpolating RGB vector values
corresponding to a RYB inscribed in a tensor--see <a class="bz_bug_link 
          bz_status_RESOLVED  bz_closed"
   title="RESOLVED FIXED - New RYB based standard palette: cleanup assigned RGB values and color names (result comment 44)"
   href="show_bug.cgi?id=114719">bug 114719</a>).

The hard coded #0000FF color used for the Data Bar colors is the fully
saturated RGB scheme Blue.

The Bar Colors for conditional formatting dialog/configs did not get adjusted
to the RYB based standard.soc at 6.1 release, names of which are now localized.

Red behaves, because it uses the #FF0000 color assignment and its name is
picked up from the standard.soc -- the Blue does not as its #0000FF does not
match the RYB interpolated Hue for Blue of #2a6099--so it gets no name but its
hex value.

Probably could point the source used for the Data Bar colors [1] to Standard
SOC, but that is likely to also impact the QA unit tests that would need
tweaks.

An, alternative, might be for conditional formatting Data Bars to use the RGB
centric tonal.soc which assigns the fully saturated RGB.

Otherwise an easy workaround is for user to just use the "tonal" palette (see
<a class="bz_bug_link 
          bz_status_RESOLVED  bz_closed"
   title="RESOLVED FIXED - standardize color palette using mathematically generated colors"
   href="show_bug.cgi?id=80196">bug 80196</a>), color values there are meaningful--and visually consistent to
handling of conditional formatting.


=-ref-=
[1]
<a href="https://opengrok.libreoffice.org/xref/core/sc/source/ui/condformat/colorformat.cxx?r=e5c3d5f3#77">https://opengrok.libreoffice.org/xref/core/sc/source/ui/condformat/colorformat.cxx?r=e5c3d5f3#77</a></pre>
        </div>
      </p>


      <hr>
      <span>You are receiving this mail because:</span>

      <ul>
          <li>You are the assignee for the bug.</li>
      </ul>
    </body>
</html>