Header/Footer in xls not displaying properly [closed]

asked 2013-08-20 21:02:22 +0100

melloyellow gravatar image

updated 2015-09-10 10:50:56 +0100

Alex Kemp gravatar image

Hello, One of our users had an issue with an xls spreadsheet that contains a header and footer. The spreadsheet would have been created with Microsoft Office 2007. The header in the center is being displayed off-center. The footer is not displaying at all. I was able to fix both problems, but I need to know how to make these display properly by default as this may happen on SEVERAL xls spreadsheets that we have saved on our network. I fixed the header by removing unneeded spaces from the end of the text. These spaces didn't display when opened in Microsoft office. The footer was fixed by going to Format > Page... > Footer tab > and checking the box next to AutoFit height. This box is already checked in the Header tab, so I'm not sure why it isn't checked by default in the Footer tab.

If anyone could let me know how this can be fixed so that spreadsheets like these open the correct way by default I would greatly appreciate it. Thanks!

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-04 22:10:03.254249

Comments

What's your OS and LibreOffice version?, Can you link to a sample file? (Please remove any confidential data),

m.a.riosv gravatar imagem.a.riosv ( 2013-08-20 23:38:38 +0100 )edit