I have a performance management system. The objective is to get it into excel, this has been achieved however I have two formatting issues which are troubling me:
1.How to force an HTML(is there another option) line break within a cell Here is a link to the file:
My issue is the Oucomes and Outputs row, its to wide especially the first.
So Im thinking a br within my HTML will solve this, here is the result:
Far to much space between the items. Is there another way? I have tried:
vbCr,VbCrLf,vbNewLine,Chr(13),Chr(10) - None of these work.
2.Getting the score image centered. I have tried the following:
Excel completley ignores:
Table tag - cellspacing and cellpadding (strangley enough allows the border and borderColor)
img tag - hSpace, vSpace and align=center
td tag - STYLE="PADDING:6" or align=center
If I remove the image from the HTML code and sent text to the .xls it centers. Can I not control an images
positioning using HTML within a cell?
Wind is your friend