<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <p>Good Morning Everyone,</p>
    <p>With all the users who have tested so far we could assess the
      following:</p>
    <ol>
      <li>If you go to the layer properties and choose the "Categorized"
        style and the "Colour" column, without doing any classification
        before that then it shows the correct colour on the map and also
        the legend. The problem with that is that you then have only the
        hex colours in your legend and still need to look up each
        "Chronostra" code in the table to insert it into the
        legend...same work as setting the colour manually. The other
        problem is that e.g. "Rc" and "Rw" have the same colour, but are
        different lithologies (although they are related), and therefore
        show only once in the legend, but both "Rc" and "Rw" should show
        in the legend (with the same colour).</li>
      <li>If you use "Categorized" and choose the "Chronostra" column
        and then go to "Symbol|Simple Fill" and set the colour to the
        "Colour" field then you get the correct colours on the map, but
        the legend colours are wrong (but at least you have all the
        "Chronostra" items in your legend.</li>
    </ol>
    <p>I will lodge this as a bug as all the options are there to set
      the colours and legend, but it does not produce the correct
      results.</p>
    <p>I would also like to request a feature on the attribute tables,
      which one can put on the composer. It would be a great advantage
      if one could colour rows or columns or just cells according to the
      value they represent. So one could colour the cell with the
      "Chronostra" text according to the colour field! (Another great
      way of displaying table info as a legend.<br>
    </p>
    <p>Regards</p>
    <p>Immo<br>
    </p>
    <div class="moz-cite-prefix">On 17/07/2017 22:11, Dean Ollis via
      qgis-za-user wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:faa38f10-f51e-3e7b-647f-737dcfc657aa@gmail.com">Hi, Immo
      <br>
      <br>
      I experience the same behaviour you describe...I am able to get
      the colours to display correctly on the map (using data-defined
      override and referring to the "colour" column) but cannot get the
      legend to show the correct colours without manually editing the
      legend. I tried on both QGIS 2.14.16 on Ubuntu 16.04 and QGIS
      2.18.10 on Widows 7. Looks like this issue is a known one - see
      here:
      <br>
      <br>
      <a class="moz-txt-link-freetext" href="https://issues.qgis.org/issues/11491">https://issues.qgis.org/issues/11491</a>
      <br>
      <br>
      Best work-around for the moment, if it is a dataset you use a lot,
      seems to be to manually sort the legend out and then save the
      style for future use in other projects.
      <br>
      <br>
      Perhaps you should add this to the feature requests for QGIS??
      <br>
      <br>
      Dean
      <br>
      <br>
      -------- Original Message --------
      <br>
      Subject: Re: [QGIS-ZA-user] QGIS Legend Problem
      <br>
      From: Immo Blecher <a class="moz-txt-link-rfc2396E" href="mailto:immo@blecher.co.za"><immo@blecher.co.za></a>
      <br>
      To: South Africa QGIS user group
      <a class="moz-txt-link-rfc2396E" href="mailto:qgis-za-user@lists.osgeo.org"><qgis-za-user@lists.osgeo.org></a>
      <br>
      Cc: Dean Ollis <a class="moz-txt-link-rfc2396E" href="mailto:dean.ollis@gmail.com"><dean.ollis@gmail.com></a>
      <br>
      Date: 17/07/2017 15:22
      <br>
      <blockquote type="cite">
        <br>
        Hi All,
        <br>
        <br>
        Attached a much smaller ZIP file with Shapefiles :-[. It has
        only a few polygons.
        <br>
        <br>
        Regards
        <br>
        <br>
        Immo
        <br>
        <br>
        <br>
        On 17/07/2017 14:45, Dean Ollis via qgis-za-user wrote:
        <br>
        <blockquote type="cite">Hi, Immo
          <br>
          <br>
          Could you send us a copy of the layer you are trying to render
          with a legend, or a clipped section of the layer? That will
          help with the testing...
          <br>
          <br>
          Thanks
          <br>
          <br>
          Dean
          <br>
          <br>
------------------------------------------------------------------
          <br>
          Dean Ollis
          <br>
          Freshwater Research Centre
          <br>
          Kommetjie, Cape Town
          <br>
          CELL: 072 377 7006
          <br>
          <br>
          -------- Original Message --------
          <br>
          Subject: Re: [QGIS-ZA-user] QGIS Legend Problem
          <br>
          From: Immo Blecher via qgis-za-user
          <a class="moz-txt-link-rfc2396E" href="mailto:qgis-za-user@lists.osgeo.org"><qgis-za-user@lists.osgeo.org></a>
          <br>
          To: South Africa QGIS user group
          <a class="moz-txt-link-rfc2396E" href="mailto:qgis-za-user@lists.osgeo.org"><qgis-za-user@lists.osgeo.org></a>
          <br>
          Cc: Immo Blecher <a class="moz-txt-link-rfc2396E" href="mailto:immob19@gmail.com"><immob19@gmail.com></a>
          <br>
          Date: 17/07/2017 14:23
          <br>
          <blockquote type="cite">
            <br>
            Sorry Frank, I realised later that I did not send that info.
            Here it is:
            <br>
            <br>
            QGIS version
            <br>
            <br>
            <br>
            <br>
            2.18.10
            <br>
            <br>
            <br>
            <br>
            QGIS code revision
            <br>
            <br>
            <br>
            <br>
            59e0f78 <a class="moz-txt-link-rfc2396E" href="https://github.com/qgis/QGIS/commit/59e0f78"><https://github.com/qgis/QGIS/commit/59e0f78></a>
            <br>
            <br>
            Compiled against Qt
            <br>
            <br>
            <br>
            <br>
            4.8.7
            <br>
            <br>
            <br>
            <br>
            Running against Qt
            <br>
            <br>
            <br>
            <br>
            4.8.7
            <br>
            <br>
            Compiled against GDAL/OGR
            <br>
            <br>
            <br>
            <br>
            1.11.3
            <br>
            <br>
            <br>
            <br>
            Running against GDAL/OGR
            <br>
            <br>
            <br>
            <br>
            1.11.3
            <br>
            <br>
            Compiled against GEOS
            <br>
            <br>
            <br>
            <br>
            3.5.0-CAPI-1.9.0
            <br>
            <br>
            <br>
            <br>
            Running against GEOS
            <br>
            <br>
            <br>
            <br>
            3.5.0-CAPI-1.9.0 r4084
            <br>
            <br>
            PostgreSQL Client Version
            <br>
            <br>
            <br>
            <br>
            9.5.2
            <br>
            <br>
            <br>
            <br>
            SpatiaLite Version
            <br>
            <br>
            <br>
            <br>
            4.3.0a
            <br>
            <br>
            QWT Version
            <br>
            <br>
            <br>
            <br>
            5.2.3
            <br>
            <br>
            <br>
            <br>
            PROJ.4 Version
            <br>
            <br>
            <br>
            <br>
            492
            <br>
            <br>
            QScintilla2 Version
            <br>
            <br>
            <br>
            <br>
            2.9.1
            <br>
            <br>
            <br>
            <br>
            <br>
            <br>
            And I run it under Ubuntu 16.04 LTS
            <br>
            <br>
            Thanks
            <br>
            Immo
            <br>
            <br>
            On 17/07/2017 14:19, Frank Sokolic via qgis-za-user wrote:
            <br>
            <blockquote type="cite">Hi Immo,
              <br>
              <br>
              Which version of QGIS are you using?
              <br>
              <br>
              Frank.
              <br>
              <br>
              On 17/07/2017 09:48, Immo Blecher via qgis-za-user wrote:
              <br>
              <blockquote type="cite">
                <br>
                Good Morning Everyone,
                <br>
                <br>
                I have a geology layer with a few columns, including the
                chronostratigraphic symbol, the rock type description
                and, importantly, a colour column (String type). The
                values stored in the colour column are the HTML hex
                values for the colour according to the 1 : 1 000 000
                simplified geological map of South Africa.
                <br>
                <br>
                When I open the layer and select the colour column for
                colouring the lithological units it works beautifully,
                but I do not get a legend for the composer. But if I set
                the Properties|Style to Categorized and then again
                select the colour from the Colour column in the table I
                also get the same nicely coloured map according to the
                colour column, an a Legend. But the Legend is wrong...it
                chooses random colours! What am I doing wrong? Is there
                a way to get a correct legend, also only showing the
                units which are actually on the map in the composer. I
                can set the colours manually to match the value in the
                colour field but that sort of defeats the purpose.
                <br>
                <br>
                Thanks for your help so long,
                <br>
                <br>
                Immo
                <br>
                <br>
                -- <br>
                <br>
                *Immo F. Blecher**Street: */52 Lynedoch Eco Village,
                Lynedoch, 7603, South Africa //*Postal:*//52 Lynedoch
                Eco Village, Lynedoch, 7603, South Africa
                //*Cell:*///+27 83 272 6791 |*Fax: *+27 86 7363302
                *Email:*_immo@blecher.co.za_
                <a class="moz-txt-link-rfc2396E" href="mailto:immo@blecher.co.za"><mailto:immo@blecher.co.za></a> | _immob19@gmail.com_
                <a class="moz-txt-link-rfc2396E" href="mailto:immob19@gmail.com"><mailto:immob19@gmail.com></a>| _immob@mymtnmail.co.za
                <a class="moz-txt-link-rfc2396E" href="mailto:immob@mymtnmail.co.za"><mailto:immob@mymtnmail.co.za></a>
                _*Internet:*_<a class="moz-txt-link-freetext" href="http://www.blecher.co.za/_">http://www.blecher.co.za/_</a>
                <br>
                <br>
                <br>
                <br>
                <br>
                _______________________________________________
                <br>
                qgis-za-user mailing list
                <br>
                <a class="moz-txt-link-abbreviated" href="mailto:qgis-za-user@lists.osgeo.org">qgis-za-user@lists.osgeo.org</a>
                <br>
                <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-za-user">https://lists.osgeo.org/mailman/listinfo/qgis-za-user</a>
                <br>
              </blockquote>
              <br>
              <br>
              <br>
              _______________________________________________
              <br>
              qgis-za-user mailing list
              <br>
              <a class="moz-txt-link-abbreviated" href="mailto:qgis-za-user@lists.osgeo.org">qgis-za-user@lists.osgeo.org</a>
              <br>
              <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-za-user">https://lists.osgeo.org/mailman/listinfo/qgis-za-user</a>
              <br>
            </blockquote>
            <br>
            -- <br>
            <br>
            *Immo F. Blecher**Street: */52 Lynedoch Eco Village,
            Lynedoch, 7603, South Africa //*Postal:*//52 Lynedoch Eco
            Village, Lynedoch, 7603, South Africa //*Cell:*///+27 83 272
            6791 |*Fax: *+27 86 7363302 *Email:*_immo@blecher.co.za_
            <a class="moz-txt-link-rfc2396E" href="mailto:immo@blecher.co.za"><mailto:immo@blecher.co.za></a> | _immob19@gmail.com_
            <a class="moz-txt-link-rfc2396E" href="mailto:immob19@gmail.com"><mailto:immob19@gmail.com></a>| _immob@mymtnmail.co.za
            <a class="moz-txt-link-rfc2396E" href="mailto:immob@mymtnmail.co.za"><mailto:immob@mymtnmail.co.za></a>
            _*Internet:*_<a class="moz-txt-link-freetext" href="http://www.blecher.co.za/_">http://www.blecher.co.za/_</a>
            <br>
            <br>
            Contact me: <a class="moz-txt-link-abbreviated" href="mailto:immob19@gmail.com">immob19@gmail.com</a> immoblecher
            <br>
            <br>
            <a class="moz-txt-link-rfc2396E" href="http://www.linkedin.com/pub/immo-blecher/30/414/b8"><http://www.linkedin.com/pub/immo-blecher/30/414/b8></a>
            <br>
            <br>
            <br>
            <br>
            Please consider your environmental responsibility. Before
            printing this e-mail message, ask yourself whether you
            really need a hard copy.
            <br>
            <br>
            IMPORTANT: The contents of this email and any attachments
            are confidential. They are intended for the named
            recipient(s) only. If you have received this email by
            mistake, please notify the sender immediately and do not
            disclose the contents to anyone or make copies thereof.
            <br>
            <br>
            <br>
            <br>
            _______________________________________________
            <br>
            qgis-za-user mailing list
            <br>
            <a class="moz-txt-link-abbreviated" href="mailto:qgis-za-user@lists.osgeo.org">qgis-za-user@lists.osgeo.org</a>
            <br>
            <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-za-user">https://lists.osgeo.org/mailman/listinfo/qgis-za-user</a>
            <br>
          </blockquote>
          <br>
          _______________________________________________
          <br>
          qgis-za-user mailing list
          <br>
          <a class="moz-txt-link-abbreviated" href="mailto:qgis-za-user@lists.osgeo.org">qgis-za-user@lists.osgeo.org</a>
          <br>
          <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-za-user">https://lists.osgeo.org/mailman/listinfo/qgis-za-user</a>
          <br>
        </blockquote>
        <br>
        -- <br>
        <br>
        *Immo F. Blecher**
        <br>
        Street: */52 Lynedoch Eco Village, Lynedoch, 7603, South Africa
        <br>
        //*Postal:*//52 Lynedoch Eco Village, Lynedoch, 7603, South
        Africa
        <br>
        //*Cell:*///+27 83 272 6791 |*Fax: *+27 86 7363302
        *Email:*_immo@blecher.co.za_ <a class="moz-txt-link-rfc2396E" href="mailto:immo@blecher.co.za"><mailto:immo@blecher.co.za></a> |
        _immob19@gmail.com_ <a class="moz-txt-link-rfc2396E" href="mailto:immob19@gmail.com"><mailto:immob19@gmail.com></a>|
        _immob@mymtnmail.co.za <a class="moz-txt-link-rfc2396E" href="mailto:immob@mymtnmail.co.za"><mailto:immob@mymtnmail.co.za></a>
        <br>
        _*Internet:*_<a class="moz-txt-link-freetext" href="http://www.blecher.co.za/_">http://www.blecher.co.za/_</a>
        <br>
        <br>
        Contact me: <a class="moz-txt-link-abbreviated" href="mailto:immob19@gmail.com">immob19@gmail.com</a> immoblecher
        <br>
        <br>
        <a class="moz-txt-link-rfc2396E" href="http://www.linkedin.com/pub/immo-blecher/30/414/b8"><http://www.linkedin.com/pub/immo-blecher/30/414/b8></a>
        <br>
        <br>
            
        <br>
        <br>
        Please consider your environmental responsibility. Before
        printing this e-mail message, ask yourself whether you really
        need a hard copy.
        <br>
        <br>
        IMPORTANT: The contents of this email and any attachments are
        confidential. They are intended for the named recipient(s) only.
        If you have received this email by mistake, please notify the
        sender immediately and do not disclose the contents to anyone or
        make copies thereof.
        <br>
        <br>
      </blockquote>
      <br>
      _______________________________________________
      <br>
      qgis-za-user mailing list
      <br>
      <a class="moz-txt-link-abbreviated" href="mailto:qgis-za-user@lists.osgeo.org">qgis-za-user@lists.osgeo.org</a>
      <br>
      <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-za-user">https://lists.osgeo.org/mailman/listinfo/qgis-za-user</a>
      <br>
    </blockquote>
    <br>
    <div class="moz-signature">-- <br>
      <meta http-equiv="content-type" content="text/html; charset=utf-8">
      <title></title>
      <div class="moz-signature">
        <div class="moz-signature">
          <p style="background: transparent; border: none; padding: 0in"><strong><font
                color="#000000">Immo F. Blecher</font></strong><strong><font
                color="#808080"><br>
                Street: </font></strong><em><font color="#808080"> 52
                Lynedoch Eco Village, Lynedoch, 7603, South Africa<br>
              </font></em><em><font color="#808080"><span
                  style="font-style: normal"><b>Postal:</b></span></font></em><em><font
                color="#808080"> 52 Lynedoch Eco Village, Lynedoch,
                7603, South Africa<br>
              </font></em><em><font color="#808080"><span
                  style="font-style: normal"><b>Cell:</b></span></font></em><em><font
                color="#000000"> </font></em><font color="#808080">+27
              83 272 6791 </font><font color="#ff6600">|</font><font
              color="#666666"> </font><font color="#666666"><b>Fax: </b></font><font
              color="#808080">+27 86 7363302 </font><font
              color="#808080"><b>Email:</b></font><font color="#808080">
            </font><a href="mailto:immo@blecher.co.za"><font
                color="#0000ff"><u>immo@blecher.co.za</u></font></a> <font
              color="#ff6600">| </font><a
              href="mailto:immob19@gmail.com"><font color="#0000ff"><u>immob19@gmail.com</u></font></a><font
              color="#0000ff"><span style="text-decoration: none"> </span></font><font
              color="#ff6600"><span style="text-decoration: none">| </span></font><font
              color="#0000ff"><u><a href="mailto:immob@mymtnmail.co.za">immob@mymtnmail.co.za</a><br>
              </u></font><font color="#666666"><span
                style="text-decoration: none"><b>Internet:</b></span></font><font
              color="#666666"><span style="text-decoration: none"> </span></font><a
              href="http://www.blecher.co.za/"><font color="#0000ff"><span
                  style="text-decoration: none"><u>http://www.blecher.co.za/</u></span></font></a></p>
          <font face="Verdana, Arial, Helvetica, sans-serif"><font
              size="1"><font color="#808080">Contact me: </font> <img
                src="http://images.wisestamp.com/gtalk.png"
                name="graphics2" height="16" border="0" align="BOTTOM"
                width="16"> <a class="moz-txt-link-abbreviated" href="mailto:immob19@gmail.com">immob19@gmail.com</a> <img
                src="http://images.wisestamp.com/skype.png"
                name="graphics3" height="16" border="0" align="BOTTOM"
                width="16"> immoblecher</font></font>
          <div id="WISESTAMP_SIG_9425" dir="LTR">
            <p style="margin-bottom: 0in; border-top: 1px solid #e5e5e5;
              border-bottom: none; border-left: none; border-right:
              none; padding-top: 0.02in; padding-bottom: 0in;
              padding-left: 0in; padding-right: 0in"> <a
                href="http://www.linkedin.com/pub/immo-blecher/30/414/b8"><img
src="http://images.wisestamp.com/apps/buttons/linkedinbutton_option_1.png"
                  name="graphics4" height="33" border="0" align="BOTTOM"
                  width="160"></a></p>
            <table cellspacing="2" cellpadding="2" width="100%">
              <tbody>
                <tr valign="TOP">
                  <td style="border: none; padding: 0in" width="1%">
                    <p style="border-top: none; border-bottom: none;
                      border-left: none; border-right: 1px solid
                      #e5e5e5; padding-top: 0in; padding-bottom: 0in;
                      padding-left: 0in; padding-right: 0.05in"> <img
                        src="http://images.wisestamp.com/widgets/green_32.png"
                        name="graphics5" height="32" border="0"
                        align="BOTTOM" width="32"></p>
                  </td>
                  <td style="border: none; padding: 0in">
                    <p style="border: none; padding: 0in">Please
                      consider your environmental responsibility. Before
                      printing this e-mail message, ask yourself whether
                      you really need a hard copy.</p>
                  </td>
                </tr>
              </tbody>
            </table>
            <p style="margin-bottom: 0in; border-top: 1px solid #808080;
              border-bottom: none; border-left: none; border-right:
              none; padding-top: 0.02in; padding-bottom: 0in;
              padding-left: 0in; padding-right: 0in"> <font
                color="#808080"><font face="Verdana, Arial, Helvetica,
                  sans-serif"><font size="1">IMPORTANT: The contents of
                    this email and any attachments are confidential.
                    They are intended for the named recipient(s) only.
                    If you have received this email by mistake, please
                    notify the sender immediately and do not disclose
                    the contents to anyone or make copies thereof.</font></font></font></p>
            <p style="margin-bottom: 0in"><img
src="http://p1.wisestamp.com/pixel.png?p=mozilla&v=2.9.5&t=1320849250746&u=82e4b3250c4ca423"
                name="graphics6" height="2" border="0" align="BOTTOM"
                width="2"></p>
          </div>
        </div>
      </div>
    </div>
  </body>
</html>