I’m using the following example:
Excel excel = new Excel();
Worksheet sheet = excel.Worksheets;
FileStream fs = new FileStream(“c:\tmp\gifpos\logo.gif”, FileMode.Open, FileAccess.Read);
int pos = sheet.Pictures.Add(0, 0, fs);
Picture pic = sheet.Pictures[pos];
sheet.Cells[“a1”].Style.HorizontalAlignment = TextAlignmentType.Right;
sheet.Cells[“a1”].Style.IndentLevel = 2;
The image will not align itself to the right side of the cell. Am I doing something wrong?
I could use pic.Left = getColumnWidth(Convert.toByte(0))-5 but the width of the column may be changed later if a wider cell is appended.
I am using version 188.8.131.52