tdf#116241 Customizing value highlighting colors

Available in: Tools->Options->Application colors

Change-Id: I6e4f7a0dcad9a6ee222275019596853f0cbd3ab0
Reviewed-on: https://gerrit.libreoffice.org/51791
Tested-by: Jenkins <ci@libreoffice.org>
Reviewed-by: Szymon Kłos <szymon.klos@collabora.com>

2 files changed, 129 insertions, 33 deletions

diff --git a/cui/source/options/optcolor.cxx b/cui/source/options/optcolor.cxx
index 94e830fc44b4..a273888772c6 100644
--- a/cui/source/options/optcolor.cxx
+++ b/cui/source/options/optcolor.cxx
@@ -137,6 +137,10 @@ const vEntryInfo[] =
     { Group_Calc,    IDS(deterror) },
     { Group_Calc,    IDS(ref) },
     { Group_Calc,    IDS(notes) },
+    { Group_Calc,    IDS(values) },
+    { Group_Calc,    IDS(formulas) },
+    { Group_Calc,    IDS(text) },
+    { Group_Calc,    IDS(protectedcells) },
 
     { Group_Draw,    IDS(drawgrid) },
 
diff --git a/cui/uiconfig/ui/colorconfigwin.ui b/cui/uiconfig/ui/colorconfigwin.ui
index db6ab43dfccf..c9220f1b83e3 100644
--- a/cui/uiconfig/ui/colorconfigwin.ui
+++ b/cui/uiconfig/ui/colorconfigwin.ui
@@ -790,6 +790,98 @@
       </packing>
     </child>
     <child>
+      <object class="svxcorelo-SvxColorListBox" id="values_lb">
+        <property name="visible">True</property>
+        <property name="can_focus">False</property>
+      </object>
+      <packing>
+        <property name="left_attach">1</property>
+        <property name="top_attach">35</property>
+      </packing>
+    </child>
+    <child>
+      <object class="GtkLabel" id="values">
+        <property name="visible">True</property>
+        <property name="can_focus">False</property>
+        <property name="margin_left">6</property>
+        <property name="xalign">0</property>
+        <property name="label" translatable="yes" context="colorconfigwin|values">Values</property>
+      </object>
+      <packing>
+        <property name="left_attach">0</property>
+        <property name="top_attach">35</property>
+      </packing>
+    </child>
+    <child>
+      <object class="svxcorelo-SvxColorListBox" id="formulas_lb">
+        <property name="visible">True</property>
+        <property name="can_focus">False</property>
+      </object>
+      <packing>
+        <property name="left_attach">1</property>
+        <property name="top_attach">36</property>
+      </packing>
+    </child>
+    <child>
+      <object class="GtkLabel" id="formulas">
+        <property name="visible">True</property>
+        <property name="can_focus">False</property>
+        <property name="margin_left">6</property>
+        <property name="xalign">0</property>
+        <property name="label" translatable="yes" context="colorconfigwin|formulas">Formulas</property>
+      </object>
+      <packing>
+        <property name="left_attach">0</property>
+        <property name="top_attach">36</property>
+      </packing>
+    </child>
+    <child>
+      <object class="svxcorelo-SvxColorListBox" id="text_lb">
+        <property name="visible">True</property>
+        <property name="can_focus">False</property>
+      </object>
+      <packing>
+        <property name="left_attach">1</property>
+        <property name="top_attach">37</property>
+      </packing>
+    </child>
+    <child>
+      <object class="GtkLabel" id="text">
+        <property name="visible">True</property>
+        <property name="can_focus">False</property>
+        <property name="margin_left">6</property>
+        <property name="xalign">0</property>
+        <property name="label" translatable="yes" context="colorconfigwin|text">Text</property>
+      </object>
+      <packing>
+        <property name="left_attach">0</property>
+        <property name="top_attach">37</property>
+      </packing>
+    </child>
+    <child>
+      <object class="svxcorelo-SvxColorListBox" id="protectedcells_lb">
+        <property name="visible">True</property>
+        <property name="can_focus">False</property>
+      </object>
+      <packing>
+        <property name="left_attach">1</property>
+        <property name="top_attach">38</property>
+      </packing>
+    </child>
+    <child>
+      <object class="GtkLabel" id="protectedcells">
+        <property name="visible">True</property>
+        <property name="can_focus">False</property>
+        <property name="margin_left">6</property>
+        <property name="xalign">0</property>
+        <property name="label" translatable="yes" context="colorconfigwin|protectedcells">Protected cells background</property>
+      </object>
+      <packing>
+        <property name="left_attach">0</property>
+        <property name="top_attach">38</property>
+      </packing>
+    </child>
+    <child>
       <object class="GtkLabel" id="draw">
         <property name="visible">True</property>
         <property name="can_focus">False</property>
@@ -801,7 +893,7 @@
       </object>
       <packing>
         <property name="left_attach">0</property>
-        <property name="top_attach">35</property>
+        <property name="top_attach">39</property>
         <property name="width">3</property>
       </packing>
     </child>
@@ -812,7 +904,7 @@
       </object>
       <packing>
         <property name="left_attach">1</property>
-        <property name="top_attach">36</property>
+        <property name="top_attach">40</property>
       </packing>
     </child>
     <child>
@@ -825,7 +917,7 @@
       </object>
       <packing>
         <property name="left_attach">0</property>
-        <property name="top_attach">36</property>
+        <property name="top_attach">40</property>
       </packing>
     </child>
     <child>
@@ -840,7 +932,7 @@
       </object>
       <packing>
         <property name="left_attach">0</property>
-        <property name="top_attach">37</property>
+        <property name="top_attach">41</property>
         <property name="width">3</property>
       </packing>
     </child>
@@ -851,7 +943,7 @@
       </object>
       <packing>
         <property name="left_attach">1</property>
-        <property name="top_attach">38</property>
+        <property name="top_attach">42</property>
       </packing>
     </child>
     <child>
@@ -864,7 +956,7 @@
       </object>
       <packing>
         <property name="left_attach">0</property>
-        <property name="top_attach">38</property>
+        <property name="top_attach">42</property>
       </packing>
     </child>
     <child>
@@ -874,7 +966,7 @@
       </object>
       <packing>
         <property name="left_attach">1</property>
-        <property name="top_attach">39</property>
+        <property name="top_attach">43</property>
       </packing>
     </child>
     <child>
@@ -887,7 +979,7 @@
       </object>
       <packing>
         <property name="left_attach">0</property>
-        <property name="top_attach">39</property>
+        <property name="top_attach">43</property>
       </packing>
     </child>
     <child>
@@ -897,7 +989,7 @@
       </object>
       <packing>
         <property name="left_attach">1</property>
-        <property name="top_attach">40</property>
+        <property name="top_attach">44</property>
       </packing>
     </child>
     <child>
@@ -910,7 +1002,7 @@
       </object>
       <packing>
         <property name="left_attach">0</property>
-        <property name="top_attach">40</property>
+        <property name="top_attach">44</property>
       </packing>
     </child>
     <child>
@@ -920,7 +1012,7 @@
       </object>
       <packing>
         <property name="left_attach">1</property>
-        <property name="top_attach">41</property>
+        <property name="top_attach">45</property>
       </packing>
     </child>
     <child>
@@ -933,7 +1025,7 @@
       </object>
       <packing>
         <property name="left_attach">0</property>
-        <property name="top_attach">41</property>
+        <property name="top_attach">45</property>
       </packing>
     </child>
     <child>
@@ -943,7 +1035,7 @@
       </object>
       <packing>
         <property name="left_attach">1</property>
-        <property name="top_attach">42</property>
+        <property name="top_attach">46</property>
       </packing>
     </child>
     <child>
@@ -956,7 +1048,7 @@
       </object>
       <packing>
         <property name="left_attach">0</property>
-        <property name="top_attach">42</property>
+        <property name="top_attach">46</property>
       </packing>
     </child>
     <child>
@@ -966,7 +1058,7 @@
       </object>
       <packing>
         <property name="left_attach">1</property>
-        <property name="top_attach">43</property>
+        <property name="top_attach">47</property>
       </packing>
     </child>
     <child>
@@ -979,7 +1071,7 @@
       </object>
       <packing>
         <property name="left_attach">0</property>
-        <property name="top_attach">43</property>
+        <property name="top_attach">47</property>
       </packing>
     </child>
     <child>
@@ -989,7 +1081,7 @@
       </object>
       <packing>
         <property name="left_attach">1</property>
-        <property name="top_attach">44</property>
+        <property name="top_attach">48</property>
       </packing>
     </child>
     <child>
@@ -1002,7 +1094,7 @@
       </object>
       <packing>
         <property name="left_attach">0</property>
-        <property name="top_attach">44</property>
+        <property name="top_attach">48</property>
       </packing>
     </child>
     <child>
@@ -1017,7 +1109,7 @@
       </object>
       <packing>
         <property name="left_attach">0</property>
-        <property name="top_attach">45</property>
+        <property name="top_attach">49</property>
         <property name="width">3</property>
       </packing>
     </child>
@@ -1028,7 +1120,7 @@
       </object>
       <packing>
         <property name="left_attach">1</property>
-        <property name="top_attach">46</property>
+        <property name="top_attach">50</property>
       </packing>
     </child>
     <child>
@@ -1041,7 +1133,7 @@
       </object>
       <packing>
         <property name="left_attach">0</property>
-        <property name="top_attach">46</property>
+        <property name="top_attach">50</property>
       </packing>
     </child>
     <child>
@@ -1051,7 +1143,7 @@
       </object>
       <packing>
         <property name="left_attach">1</property>
-        <property name="top_attach">47</property>
+        <property name="top_attach">51</property>
       </packing>
     </child>
     <child>
@@ -1064,7 +1156,7 @@
       </object>
       <packing>
         <property name="left_attach">0</property>
-        <property name="top_attach">47</property>
+        <property name="top_attach">51</property>
       </packing>
     </child>
     <child>
@@ -1074,7 +1166,7 @@
       </object>
       <packing>
         <property name="left_attach">1</property>
-        <property name="top_attach">48</property>
+        <property name="top_attach">52</property>
       </packing>
     </child>
     <child>
@@ -1087,7 +1179,7 @@
       </object>
       <packing>
         <property name="left_attach">0</property>
-        <property name="top_attach">48</property>
+        <property name="top_attach">52</property>
       </packing>
     </child>
     <child>
@@ -1097,7 +1189,7 @@
       </object>
       <packing>
         <property name="left_attach">1</property>
-        <property name="top_attach">49</property>
+        <property name="top_attach">53</property>
       </packing>
     </child>
     <child>
@@ -1110,7 +1202,7 @@
       </object>
       <packing>
         <property name="left_attach">0</property>
-        <property name="top_attach">49</property>
+        <property name="top_attach">53</property>
       </packing>
     </child>
     <child>
@@ -1120,7 +1212,7 @@
       </object>
       <packing>
         <property name="left_attach">1</property>
-        <property name="top_attach">50</property>
+        <property name="top_attach">54</property>
       </packing>
     </child>
     <child>
@@ -1133,7 +1225,7 @@
       </object>
       <packing>
         <property name="left_attach">0</property>
-        <property name="top_attach">50</property>
+        <property name="top_attach">54</property>
       </packing>
     </child>
     <child>
@@ -1143,7 +1235,7 @@
       </object>
       <packing>
         <property name="left_attach">1</property>
-        <property name="top_attach">51</property>
+        <property name="top_attach">55</property>
       </packing>
     </child>
     <child>
@@ -1156,7 +1248,7 @@
       </object>
       <packing>
         <property name="left_attach">0</property>
-        <property name="top_attach">51</property>
+        <property name="top_attach">55</property>
       </packing>
     </child>
     <child>
@@ -1166,7 +1258,7 @@
       </object>
       <packing>
         <property name="left_attach">1</property>
-        <property name="top_attach">52</property>
+        <property name="top_attach">56</property>
       </packing>
     </child>
     <child>
@@ -1179,7 +1271,7 @@
       </object>
       <packing>
         <property name="left_attach">0</property>
-        <property name="top_attach">52</property>
+        <property name="top_attach">56</property>
       </packing>
     </child>
     <child>