<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body><span class="vcard"><a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> <span class="fn">b.</span></a>
</span> changed
          <a class="bz_bug_link 
          bz_status_NEW "
   title="NEW - enhancement request: better handling of outdated cached values | notabug: file was saved with outdated values | was: error in calculating sums"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=130118">bug 130118</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;">Severity</td>
           <td>normal
           </td>
           <td>enhancement
           </td>
         </tr>

         <tr>
           <td style="text-align:right;">CC</td>
           <td>
                
           </td>
           <td>newbie-02@gmx.de
           </td>
         </tr>

         <tr>
           <td style="text-align:right;">Summary</td>
           <td>error in calculating sums
           </td>
           <td>enhancement request: better handling of outdated cached values | notabug: file was saved with outdated values | was: error in calculating sums
           </td>
         </tr>

         <tr>
           <td style="text-align:right;">Version</td>
           <td>6.3.3.2 release
           </td>
           <td>4.1.6.2 release
           </td>
         </tr></table>
      <p>
        <div>
            <b><a class="bz_bug_link 
          bz_status_NEW "
   title="NEW - enhancement request: better handling of outdated cached values | notabug: file was saved with outdated values | was: error in calculating sums"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=130118#c11">Comment # 11</a>
              on <a class="bz_bug_link 
          bz_status_NEW "
   title="NEW - enhancement request: better handling of outdated cached values | notabug: file was saved with outdated values | was: error in calculating sums"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=130118">bug 130118</a>
              from <span class="vcard"><a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> <span class="fn">b.</span></a>
</span></b>
        <pre><span class="quote">> c#3: Bug also affects cells: I13, I14 in file 'Tabella retribuzione.ods'</span >
also affected: D8, D13, D14 and indirect I9:I12 and second level indirect some
more, (a small carelessness not to inform the user about outdated values leads
to an avalanche of hard to spot subsequent errors)

<span class="quote">> c#8: I don't understand why cell N8 isn't calculated correctly on opening the file.</span >
N8 is ok, I8 is 'off', 

<span class="quote">> affected versions: </span >
checked back to 4.1.6.2, identical behaviour, , 

quite sure C8, C13 and C14 have been changed with autocalculate off, C15 and
cols J:N added or individually recalculated lateron, thus 'notabug', changing
headline, 

leaving as enhancement request to: 

- flag 'save this' active after changes by manual hard recalc, 

(@Eike in c#10: 'We probably should do that at least after a manual hard
recalc.') 

- find a way to warn user when dealing with outdated cached values</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>