[Libreoffice-bugs] [Bug 122897] FILESAVE XLSX Spreadsheet with Database Range is incorrect when the document is opened in Excel

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=122897

--- Comment #9 from NISZ LibreOffice Team <libreoffice at nisz.hu> ---
Created attachment 173380
  --> https://bugs.documentfoundation.org/attachment.cgi?id=173380&action=edit
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210706/61bb8057/attachment.htm>