I have a user that has a spreadsheet that was created in Excel and has some basic macros. What is the best way in Calc to clear unprotected cells from it?
Just use normal Search&Replace (Сtrl + H)
And if you wanna make sure every cell you can clean gets cleaned replace
*, but I predict it’ll be very taxing since up to 1 073 741 824 cells will be processed.