<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - sum error when opening an xlsx in Calc" href="https://bugs.documentfoundation.org/show_bug.cgi?id=130698#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - sum error when opening an xlsx in Calc" href="https://bugs.documentfoundation.org/show_bug.cgi?id=130698">bug 130698</a> from <a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> Eike Rathke</a> <pre>Note that the attached file was created by LibreOffice/6.0.7.3, not MS-Excel; under some circumstances shared grouped formulas if copied/moved were not recalculated before saving (e.g. on sheet Attendance in columns C, D, E). I'm not sure if we always should recalculate documents saved with earlier LibreOffice versions or whether there's a better approach. My take is recalculate, maybe only if there are shared formula groups. Maybe even by setting only those ranges dirty (which broadcasts to dependents), on the other hand that might take longer than a forced recalc if there are a lot of formula groups.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>