How to transfer cell formatting in Google Sheets from one document to another?

Question

Google Sheets

Friends.
There is a document on google dox spreadsheets. Cells in a document have their own formatting in addition to data. Calculations are made in one document, cells have all sorts of different formatting (text color, text style, cell color, data location in the cell). And there is another document that is available for users to view. How, in order not to do double work, changing the formatting of cells in one document, receive cell changes in another. Moreover, if there are no problems with transferring data, this is solved by the IMPORTRANGE function, then formatting is a problem, it does not work to transfer the design of the cell, only data and that's it.

Answer 1

I am also puzzled by this problem. Did the author find a solution?

Answer 2

+1