libre calc doesn't save formatting for header-footer

I change the margins for header and footer by going to format, page, header (or footer) and entering the correct values. I then click ok. This all works fine. Print copies reflect the changes. BUT, when I click save, and re-open the files, the values revert back to the starting point, and I need to re-enter. Is there a way to get these values to be saved?

Detail required

  • What storage format (file type) do you use?
  • Which version of LibreOffice do you have?
  • What system platform are you on (computer type/brand, operating system brand/version, etc.)?
  • Is header/footer content also altered, or is the issue only concerning spacing?

I tested with Calc version on Windows 10, saving as ods, xls and xlsx, and the header size/spacing is retained through save/reload. Unable to duplicate issue as described.

Thanks for helping keme:

  1. storage format: excell 2007-2019 (xlsx)
  2. version of Libre Office: (x64)
  3. System Platform: Acer desktop computer- Aspire TC 865, Windows 10 Home,
  4. Content is not altered, only the left & right margin values.