The layout of page headers and footers cannot be saved in xlsx format. When I am working on a file everything goes well, but the layout of headers and footers is changed when I open the file again after having it saved and closed. When I insert the file title (file name without extension) as a header or footer, it is changed into the file name (with extension) when I reopen the file. When I use bold characters in headers and footers, they are changed into standard characters when I reopen the file. These problems do not occur when I save the file in ods format. As I sometimes share files with MS Excel users, I wonder if it is possible to retain the headers and footers layout in xlsx format. I am working with LibreOffice 7.3.7.2 in Windows 11.
Use ODS format.
Compatibility problem?
https://wiki.documentfoundation.org/Faq/General/118#Edit_different_file_formats_in_LibreOffice
Please report the behavior also as an error in Bugzilla .
See also:
How to Report Bugs in LibreOffice .
Please post the link to the bug here.
format: tdf#nnnnnn (use only the number, not the link)
To do this, edit your original question. Thank you very much.
I could never find any option in Word & Excel to add a filename without extension, maybe the latest versions allow that. Funny really, MS Windows default to not showing extensions but MS Office insists on extensions.
+1
Always use the native, international standard ODF file formats.
Note: there is not (never was and never will be) 100% compatibility between the different file formats and between the different applications.
You can try, if Excel does this better than Calc. Give them an .ods-File, as Excel can read them. Maybe Excel can successfully load the file, then saving as .xlsx should pose no probem for advanced Excel-Users, some actually may not know how to change defaults.
This is Excel’s file formats limitation. The markup used in XLSX is defined in ECMA-376 Part 1 18.3.1.46 headerFooter (Header Footer Settings); and the filename field is specified there as simple &F, with no way to fine-tune.
Every time you export from any program to an alien file format, you need to understand that many things may change, resulting in poor output; including parts of formatting and even data lost. And often it’s not because of bugs in export code, but simply because the chosen format can’t hold such formatting/information. You likely wouldn’t be surprised to see headers lost completely when exporting to CSV; in this case, you see that XLSX is also not a almighty file format, and has own limitations.