Ask Your Question

Function inside macro

asked 2017-03-03 09:43:48 +0100

AkTu gravatar image

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.

edit retag flag offensive close merge delete


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

karolus gravatar imagekarolus ( 2017-03-03 11:03:26 +0100 )edit

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

AkTu gravatar imageAkTu ( 2017-03-03 12:21:15 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-03-03 11:08:41 +0100

pierre-yves samyn gravatar image

updated 2017-03-04 07:19:36 +0100


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


What I mean is :

  • copy the value to add
  • select the "target" range
  • EditPaste specialOperations: Add

paste special screenshot


edit flag offensive delete link more



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!

AkTu gravatar imageAkTu ( 2017-03-03 12:26:40 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-03-03 09:43:48 +0100

Seen: 53 times

Last updated: Mar 04 '17