https://bugs.documentfoundation.org/show_bug.cgi?id=122897
--- Comment #17 from Regina Henschel <[email protected]> --- (In reply to NISZ LibreOffice Team from comment #9) > Created attachment 173380 [details] > Example ods file to reproduce the problem > 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. The last row has no formula at all. It seems Excel does not like that. Although I do not see in the OOXML standard that it is not allowed. I can not reproduce the problem with attachment 173382. The current LO-daily writes a totalsRowFunction="sum" and Excel opens the resaved file without problems. The problem I have seen in comment 15 is, that if the function in the totals row is e.g. "SUM", totalsRowFunction="sum" is written although it needs to be totalsRowFunction="custom". The enum "sum" can only be used for function SUBTOTAL(109;...), see table in 2.1.1094 in [MS-OI29500]. -- You are receiving this mail because: You are the assignee for the bug.
