Hi:
When you use ODS HTML to create a file, you are making an ASCII text file of HTML tags. You are not creating a true, binary, .XLS file -- you are only creating an HTML file that Excel can open. Giving the HTML file a ".XLS" extension only fools the Windows registry into launching Excel to open the HTML file.
Normally, an HTML file is opened in the browser and your images will stay in place in the browser, because the browser has a certain way of handling the HTML <IMG> tag. But, Excel is built to render spreadsheets -- opening an HTML file with Excel generally works well for report tables of rows and columns.
One reason I do not use logos or preimage with ODS HTML, if I plan to open the HTML file into Excel, is that Excel seems to "float" the image -- which, for me, has resulted in the image being floated over the data, as you describe.
I do not know a way around this -- to me it seems to be inherent in the way that Excel treats HTML <IMG> tags. So, this is why I suggest you open a track with Tech Support on this issue. They may know of a workaround.
cynthia
... View more