Calc: how to properly reference cells from other sheet? [closed]
Hello everyone,
I came across the following difficulty:
I copy and "paste special" row from one sheet into some other sheet in the same document. In "paste special" I select the "link" option to reference cells from the original sheet instead of coping values. Cells which have values in the original sheet at the moment when I copy them are referenced properly, however those that are empty are not referenced.
Do you possibly know how to make all cells to be referenced, regardless of whether they have some value or not?
Thank you in advance for help :)
Best Regards
@tomek it looks like @razon_22's answer is the best answer, it worked for me, if it worked for you, you should upvote and then accept his answer