Function inside macro

[AkTu]

I’m planning to make easy way for older people in my work to manage with their data. They have .GT textfile where is different values for data.

   0       0     712      26   6986404,475   2452724,255        57,453
   0       0     712      59   6986311,976   2452819,254        56,036
   ...

They need to change last value with (+0,41), meaning that I result for these two to be

   0       0     712      26   6986404,475   2452724,255        57,863
   0       0     712      59   6986311,976   2452819,254        56,446
   ...

I can make it myself in libreoffice with function like “=CHANGE(A1;RIGHT(A1;6);RIGHT(A1;6)+0,41)”.
But for my workmates libreoffice functions are just alien language.

So my guestion I guess is,can I make tool for them in libreoffice. So they could choose range of wanted cells and click this tool and it’ll give result to next cell as I explained?

Was thinking macro might be one way to go, but im not all so fluent with libreoffice yet so would like to know if there some more simple way.

[karolus]

Start with proper import instead dumping the data in just one Column.

[AkTu]

Hi Karolus,

Thank you for fyour intrest. Thing is that I would like to keep spacing between values same. Otherwise our “outcomputer” doesn’t know how to read file. So idea here is to keep this as easy job to do as possible. So that even kid would know how to do it. What I workmates can do is…

1. Read file
2. Select cells
3. Click “tool”
4. Save file back to .gt format with new values

[PYS]

Hi

If you import your data in different columns a simple copy (the value to add) then paste special allows to add

[EDIT]

What I mean is :

• copy the value to add
• select the “target” range
• Edit▸Paste special▸Operations: Add

Regards

[AkTu]

Hi,

Thank you for your intrest! As I said to Karolus comment. I would like to keep spacing between values same as in original file. I tried to search for these “special allows to add”, does it mean I can include some function as I’m copying my values to libre? Would be good to know if there is possibility like that. Not sure if I can use it in this case though.

Thank you!