Description: I have an admittedly complex Footer design, with text in 4 rows of the Left Area footer box, and then 3 empty rows plus one populated row in the Center Area footer box, and then 3 empty rows plus one populated row in the Right Area footer box. The footer looks fine until it is saved and then reloaded. Upon reloading the file, some of the empty rows are not present, and then some of the text falls on top of other text. NOTES - I am saving this file in .xlxs format. This behavior is not seen in the .ods format - I desire to share this file with others who use the .xlxs format. Steps to Reproduce: 1. I created another file to test this behavior. 2. The same thing happened. 3. I did discover that saving the file in the .ODS format did NOT display this behavior. Actual Results: 1. I created another file to test this behavior. Expected Results: Nicely spaced text in the 3 Footer Boxes. Reproducible: Always User Profile Reset: Yes Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no
Created attachment 200976 [details] Test Case for this Bug Report
You attached an XLSX. It is not possible to see what you *intended* to do in XLSX, if export to that format is already broken. Please attach an ODS, which shows your wanted design, and that, when exported to XLSX, shows the breakage.
Created attachment 200983 [details] This Test file in ODS format displays the desired look of the Footer
Repro using Version: 25.2.4.1 (X86_64) / LibreOffice Community Build ID: 09303ce8b49f86f106fccd32b1324662053027cc CPU threads: 24; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-GB Calc: CL threaded The generated XLSX produces an error when loaded in MS Excel; allowing it to recover and proceed removes the footer.
Excel needs to correct the file and it loses the footer. Microsoft® Excel® Microsoft 365 MSO (version 2504 16.0.18730.20186) 64 bits.
Excel is deleting the workbook properties of /xl/worksheets/sheet1.xml Also happening with a XLSX generated by Version: 7.0.0.3 Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx Locale: nl-NL (nl_NL.UTF-8); UI: en-US Calc: threaded
Also with xlxs export of Versie: 4.2.0.4 Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71 also with xlxs export Versie 4.0.0.3 (Bouw-id: 7545bee9c2a0782548772a21bc84a9dcc583b89) Not occurring with LibreOffice 3.5.0rc3 Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735 however no surprise, most of the footer is missing
In debug version: warn:legacy.tools:9470:9470:svx/source/form/fmvwimp.cxx:436: FmXFormView::~FmXFormView: Window list not empty!