Created attachment 196443 [details] file with database range to reproduce the problem Open attached document. It has a database range. Set cursor to a data cell. Menu Data > Define... You get the "Define Database Range" dialog and the database range "myData" should be preselected. Open the "Options" section. Check "Contains totals row". Click on "Modify" button. OK Open again the "Define Database Range" dialog and verify that the option "Contains totals row" is really checked. Save the file. Reopen the file. Open the "Define Database Range" dialog and look at the Options. Error: The option "Contains totals row" is no longer checked. ODF provides an attribute table:contains-header for the UI option "Contains column labels". ODF has no attribute corresponding to the UI option "Contains totals row". Thus this information needs to be written in extended namespace to ODF and an issue at OASIS has to be created. Preserving this information in ODF is needed for bringing table structured references to ODF (bug 162088).
I have created https://issues.oasis-open.org/browse/OFFICE-4169?jql=project%20%3D%20OFFICE# with the request for a suitable attribute in ODF.
Curiously, the help does not mention the option. https://help.libreoffice.org/latest/en-US/text/scalc/01/12010100.html?&DbPAR=CALC&System=WIN Reproducible Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 47a348bb0fd6dfdd93c1975d216daadc4f6b9b6f CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
I'll work on it.
Regina Henschel committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/35c5d496645e64463ff4ba1e7b0b78f6b55741d9 tdf#162963 export property TotalsRow to ODF It will be available in 25.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.