autoformat Calc - what is the point

Hi folks,
what is the point of the Calc/Format/Autoformat feature? Is it a local thing on my computer or is it stored in the spreadsheet? Is it only applied once or does it update like a template for cells or pages?

Cheers
Johkra