<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body><span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span> changed
          <a class="bz_bug_link 
          bz_status_RESOLVED  bz_closed"
   title="RESOLVED NOTABUG - AutoFilter sort reference not updated with nested IF statement"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=138896">bug 138896</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;">Resolution</td>
           <td>---
           </td>
           <td>NOTABUG
           </td>
         </tr>

         <tr>
           <td style="text-align:right;">Status</td>
           <td>UNCONFIRMED
           </td>
           <td>RESOLVED
           </td>
         </tr></table>
      <p>
        <div>
            <b><a class="bz_bug_link 
          bz_status_RESOLVED  bz_closed"
   title="RESOLVED NOTABUG - AutoFilter sort reference not updated with nested IF statement"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=138896#c13">Comment # 13</a>
              on <a class="bz_bug_link 
          bz_status_RESOLVED  bz_closed"
   title="RESOLVED NOTABUG - AutoFilter sort reference not updated with nested IF statement"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=138896">bug 138896</a>
              from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
        <pre>(In reply to Colin from <a href="show_bug.cgi?id=138896#c11">comment #11</a>)
<span class="quote">> (In reply to Mike Kaganski from <a href="show_bug.cgi?id=138896#c10">comment #10</a>)
> I get the same result as you but on closer examination, you will discover
> that the cells being SUMmed are now future events for which there can never
> be any valid data.</span >

Of course. And this shows how you use Calc wrong. You use relative references
*as a substitution for a semantical relation". This is implying that Calc
"understands" your ideas about your data, such as "I refer to these N preceding
events", instead of "N cells above". It's you who has the mental model that
cells above are preceding events, but don't imply Calc to be human.

If you want to refer to data that has some semantical relation to this cell,
independent of relative position on sheet, then you should create formulas
based on those traits, not on relative referencing.

How to create such a formula for a specific task is off-topic here, please ask
e.g. on ask.libreoffice.org.

Closing NOTABUG.</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>