If the current header contains “&[File]” in its top-left position and i run:
Dim h1 As String = sheet.PageSetup.GetHeader(0)
Result: h1 = “&L&F"
If i ran this:
h1 = h1.replace(”&F","(filename)")
Results: h1 = "&L(filename)"
But when i set the header back:
sheet.PageSetup.SetHeader(0,h1)
Result: h1 = "&L&L(filename)"
Do i have to manually strip out the &L before setting a new header? What is the purpose of this character if there are 3 header positions anyway?
Hi,
Please try this fix.
If the header has contained "&L"/"&C"/"&R", We will not add it again.