<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - FILESAVE XLSX Spreadsheet with Database Range is incorrect when the document is opened in Excel" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122897#c9">Comment # 9</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - FILESAVE XLSX Spreadsheet with Database Range is incorrect when the document is opened in Excel" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122897">bug 122897</a> from <a class="email" href="mailto:libreoffice@nisz.hu" title="NISZ LibreOffice Team <libreoffice@nisz.hu>"> NISZ LibreOffice Team</a> <pre>Created <a href="https://bugs.documentfoundation.org/attachment.cgi?id=173380" name="attach_173380" title="Example ods file to reproduce the problem">attachment 173380</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=173380&action=edit" title="Example ods file to reproduce the problem">[details]</a> Example ods file to reproduce the problem Looks like we forgot about an ods reproducer. This file currently exports fine in LO 7.3 nightly: However, if you go to the Data - Define Database Range dialog, check the Contains totals row box and save the file as XLSX then Excel calls that broken. Contains totals row seems to be a half baked feature on its own: checking it is not doing anything visually (In Excel it would add a row to the bottom of the database range (Table) that contains a sum of the values, also a dropdown to choose other functions like min, max, avg, count), neither is it saved to ods.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>