How to preserve formatting of xls charts opened in Calc

On opening an xls workbook designed for Office 2007-2010, charts in the file appear correctly, but have oddly colored backgrounds, with blue and gray where there should be white. Also, the positions and formatting of text become offset. Is there a way to preserve the formatting of these charts?

I have uploaded the files to dropbox here: dropbox files

There are several sheets in the workbook, with four charts, each with its own sheet that I am having the display problems with.

LibreOffice Calc version, English
Microsoft Windows 7 Pro 64 Bit, English

Seems the file has excel macros, please read this link about execel macros in LibreOffice.