<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body><span class="vcard"><a class="email" href="mailto:ilmari.lauhakangas@libreoffice.org" title="Buovjaga <ilmari.lauhakangas@libreoffice.org>"> <span class="fn">Buovjaga</span></a>
</span> changed
          <a class="bz_bug_link 
          bz_status_NEW "
   title="NEW - column label functions do not update after inserting rows below title - needs save and reload including a hard recalc"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=87058">bug 87058</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;">CC</td>
           <td>
                
           </td>
           <td>ilmari.lauhakangas@libreoffice.org
           </td>
         </tr>

         <tr>
           <td style="text-align:right;">Keywords</td>
           <td>bibisectRequest
           </td>
           <td>bisected
           </td>
         </tr></table>
      <p>
        <div>
            <b><a class="bz_bug_link 
          bz_status_NEW "
   title="NEW - column label functions do not update after inserting rows below title - needs save and reload including a hard recalc"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=87058#c11">Comment # 11</a>
              on <a class="bz_bug_link 
          bz_status_NEW "
   title="NEW - column label functions do not update after inserting rows below title - needs save and reload including a hard recalc"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=87058">bug 87058</a>
              from <span class="vcard"><a class="email" href="mailto:ilmari.lauhakangas@libreoffice.org" title="Buovjaga <ilmari.lauhakangas@libreoffice.org>"> <span class="fn">Buovjaga</span></a>
</span></b>
        <pre>(In reply to Oliver Brinzing from <a href="show_bug.cgi?id=87058#c10">comment #10</a>)
<span class="quote">> Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=149067" name="attach_149067" title="column label function.ods">attachment 149067</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=149067&action=edit" title="column label function.ods">[details]</a></span>
> column label function.ods

> this issue is not an issue about a problem with named ranges.

> average function uses column labels instead:

> Tools/Options.../LibreOffice Calc/Calculate
> [X] Automatically find column and row labels

> steps to reproduce with LO 6.1.5.2:
> - open attached "column label function.ods"
> - enter 400 in cell C7
> - sum/average functions will update results
> - select row 4, context menu "Insert Row Above"
>   (or row 3, context menu "Insert Row Below"
> - enter 50 in cell C4
> - sum/average functions will *not* update results</span >

Bibisected with Linux 42max to
<a href="https://git.libreoffice.org/core/+/ac645e88b91e95bc19ce7a8852fe45b0ec8780e7%5E!/">https://git.libreoffice.org/core/+/ac645e88b91e95bc19ce7a8852fe45b0ec8780e7%5E!/</a>
Extract this code into a local function.</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>