formatting comments in calc

Hi, I’m a new Calc user. My spreadsheet, an imported .xlxs, has lots of comments, some of which display correctly, but many have transparent backgrounds and other problems. I seemingly cannot choose a column and format all the comments in that column. I can’t get clone formatting to work on cells’ comments. Must I individually correct the format of each “bad” comment? MacOS Catalina 10.15.2, if that makes any difference. Thanks.