[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
bugzilla-daemon at bugs.documentfoundation.org
Tue Jul 6 11:07:49 UTC 2021
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>
More information about the Libreoffice-bugs
mailing list