Stel uw vraag

gastcra's profiel - activiteit

2018-06-06 11:49:56 +0200 badge ontvangen  Beroemde vraag (bron)
2018-03-05 23:37:59 +0200 badge ontvangen  Beroemde vraag (bron)
2017-01-05 18:48:10 +0200 stelde een vraag Macro to adjust the size of rows and columns in Calc

I would like a macro to apply a constant adjustment to the row heights and column widths in all the cells in a Calc matrix. (This matrix is superposed on a background image and the adjustment is necessary when the size of the image is modified).

2017-01-02 12:43:18 +0200 reageerde op een antwoord Selecting a foreground image in a macro

Problem fixed. I should have used the "Button Released" event rather than "Button Pressed"

2017-01-02 12:40:26 +0200 badge ontvangen  enthousiast
2017-01-01 12:02:55 +0200 reageerde op een antwoord Selecting a foreground image in a macro

I modified your macro to rotate the image with a spinner, Ratslinger. It works well except that when you change directions if doesn't react immediately. For example, if you click the left arrow after having previously clicked the right one the image will rotate to the right the first time. Subsequent clicks on the left arrow rotate the image left. I can't put my script in this comment so I will try to put it in an Answer below.

2017-01-01 11:39:47 +0200 badge ontvangen  Opvallende Vraag (bron)
2016-12-27 17:47:34 +0200 badge ontvangen  Opvallende Vraag (bron)
2016-12-27 13:38:47 +0200 reageerde op een antwoord Selecting a foreground image in a macro

Should I be concerned that SDK documentation says that the RotateAngle property is 'deprecated'?

2016-12-27 03:00:15 +0200 reageerde op een antwoord Selecting a foreground image in a macro

Thanks Regina and Ratslinger. Your answers are very helpful. I am just getting my feet wet with LO as you can see. It will take me a while to absorb all this. I did realize the limitations of working with Position and Size dialogue. It's nice to see this can be circumvented.

2016-12-27 01:55:10 +0200 badge ontvangen  Populaire Vraag (bron)
2016-12-26 20:45:46 +0200 reageerde op een vraag Selecting a foreground image in a macro

I would like to rotate an image - or at least bring up the Position and Size dialogue and display the Rotate tab. Ideally the user could just enter a + or - change in degrees and the macro would do the rest.

We have 1000s of images to transcribe weather data from. Some are not scanned straight.

2016-12-26 18:46:51 +0200 reageerde op een antwoord selecting background image with a macro in calc

Thanks again, Ratslinger. I made the fix.

2016-12-26 18:38:35 +0200 stelde een vraag Selecting a foreground image in a macro

Thanks to Ratslinger's help my macro to bring an image to the foreground now works but I want to be able to adjust the image using a Format/Object menu command. To do this, the image must be selected, which is done by clicking it. (The cursor then changes from a single arrow to a 4-way arrow). But in a macro, clicking the image does not have this effect. The cursor remains a single arrow. Is there an basic macro command to perform this selection?

2016-12-24 12:35:21 +0200 reageerde op een antwoord selecting background image with a macro in calc

Thanks, Ratslinger. Just what I needed!

2016-12-24 12:32:59 +0200 badge ontvangen  Leerling (bron)
2016-12-24 11:07:06 +0200 badge ontvangen  Populaire Vraag (bron)
2016-12-23 13:59:09 +0200 stelde een vraag selecting background image with a macro in calc

I am trying to select a background image using a macro in Calc. I recorded a macro in which I selected the background image using the Navigator and moved it to the foreground. I then did an operation on the image and then closed the macro. The recorded macro doesn't do anything. I noticed that some of the commands in the recorded macro are commented out. I uncommented them but it still doesn't work.

Is there a way to do this?