Hi, I don’t know how to copy field from one sheet to the other.
I want to copy FULL field (comments, links, etc.) to the other sheet. How to do that?
For example when I put:
=$DEFAULT-SHEET.$C$100
(where DEFAULT-SHEET is the sheet I copy the field from, C100 is the field it self)
it copy only the value - not the comment, nor link, nor background, nor conditions, etc.
You copy (Ctrl+C) and paste (Ctrl+V).
Something like =$DEFAULT_SHEET.$C$100 does not copy, it calculates with cell content and displays the result, here simply the content of the cell it references.
But I want to change most of the data only in one sheet, not in ALL of them, cause it is to much work.
MAIN sheet change automatically update other sheets.
MAIN ->| Other1
,.,.,.,.,.,.| Other2
,.,.,.,.,.,.| Other3
and so on…
Change need also adjust comments, links, conditions, text color, background, etc. I hope u know what I mean.
It is possible?
I’d think you are searching for cell-styles, if you want to change the appearance. A formula with = references only the content. And a real copy stays independent of the original.
.
Always remember Calc is short for Calculate not a abbreviation for “Crazy App to Lineup Chars”
No I don’t need any crazy chart here. I’m a programer so I would use html/css/d3.js for something like that anyway.
I only want to create few identical sheets for calculations, so most is the SAME (means comments, conditions, etc. are copied from MAIN sheet to the others immediately when I done some amendments) and only a few fields are for data inputs (not related to MAIN sheet), for fast calculations for (many) different setups.
So calc is no help here? In means make this field related to other sheet field WITH comments, conditions, background so I won;t need to change it manually after any minor change in MAIN sheet.
This sounds more like you wish to create templates. Also no big problem.
.
But as a programmer you should know the importance of precise definitions. As I have obviously no idea, what you really want to do (besides not reading a guide on Calc/Excel etc) I will close my part of this communication.
.
Good luck, whatever software you will try to use.
Yea, it will be probably faster to create fast node app then acquiring any help here. I don’t know how I can be more specific. Gonna check original Office forums for fast answer and if I do not get one, I will do my work with simple page with additional data as inputs to chose.