Quote Originally Posted by starzen View Post

the only function libxl has is SetCellFormat

it seems to require a format
That's how far I'd got

what if you create a new format without any setting and set it to that?
That might have legs. I'm waiting for other feedback before picking this up again. I persuaded the user that they needed to manually clear formatting from that part of the spreadsheet, for now. Next run isn't until next week.