Just a note about Paint Format and data types. In Excel and Google Sheets, list options are controlled via the Data Validation feature and the Format Painter does not copy data validation.
Through the use of data types, SSDC has essentially merged data validation with number formatting.
I think it makes a lot of sense for the Copy/Paste feature to include a “data type only” option and use “cell formatting only” in place of “formatting only”. Later, you may want to include a “conditional formatting only” option, and maybe you also include an “all formatting” option that includes cell formatting, data types, and conditional formatting.
The idea is to avoid the ambiguity of the term “formatting”. Does it refer to the data type? Does it refer to the specific number formatting within a particular data type? Does it refer to the cell background color and font, word wrap and text alignment? Spreadsheet users are familiar with formatting referring to all of these things, but data types are quite different in SSDC. Data Types don’t just control number formatting (although all number formatting is controlled via data types).
One argument for avoiding copying the data type with the Paint Format feature is that replacing a data type in SSDC can cause you to lose data. Changing a data type gives you the “heads up” message warning you about this. GS and Excel behavior is that the Format Painter copies both cell formatting and number formatting, but it never affects your stored data. Recognizing that the Paint Format feature does not overwrite Data Types allows you to copy the cell formatting to cells with different types with confidence that your stored data will not be changed.