Macro does not record text

I am using calc version:
Macro does not record any text I type in and therefore does not put them in the cells when I play it. What am I doing wrong?
Also anybody can tell me how I can record and play selection of non-adjacent columns? I can do the selection of multiple non-adjacent columns with the keyboard, but the macro would not record all the selections. On play back, all it does is select the last column in the sequence???
Is there a macro code to select/copy columns by reference from sheet 1 and then paste it in sheet 2?

New user and not a programmer, so can’t create calc macro basic. Have used MS Excel and used quite a bit of it’s formula . Will greatly appreciate any help…