Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index

On 21 Sep 2018 at 7:25, Jean-Francois Nifenecker wrote:

Subject:                Re: [libreoffice-users] Issues with macro 
From:                   Jean-Francois Nifenecker 
Date sent:              Fri, 21 Sep 2018 07:25:28 +0200

Hello Michael,

Le 04/09/2018 à 14:08, Michael D. Setzer II a écrit :

Second issue was it deleted two different columns. When recording clicked
on the column with mouse, and deleted each column. Record didn't record
anything of clicking on the columns, but just the delete command. Added a
goto cell and got that to work as well.

the recorder has no prior knowledge about the active cell. You have to 
set it before any other action.

Yes, I agree with that. But in this case during the recording of the macro, I 
used the mouse to select the column I was going to delete, and the did the 
deletion of the column, and then selected the other column, and deleted it as 
well. Worked perfectly during the record process.

The playback of the macro failed, since the recorder had nothing in the 
process of the mouse selecting the column to be delete. The record just had 
delete column, delete column. For some reason the use of the mouse to click 
on the top of the column was never recorded, and that is how I generally 
select the columns to delete during regular usage. I did them modify the 
recorded macro to add going to the column before each delete column 
operation and it now works. Could have recorded the macro using a goto the 
cell in the column, and it probable would have worked correctly, but the issue 
was that the recorder failed to record a proceess that works manually??

-> When I use the recorder to act upon cells/columns/rows, I usually 
start with Ctrl+Home to set things clearly, then I move the active cell 
to the wanted place (for quick moves you may try using the cell name field).

Yes, most of my macro start with the Ctrl-Home. Have just run into a few 
things were the recorder doesn't fully record the process as it was done. The 
macro process is different than the old days. Did a lot of work with Quattro 
Pro, and never had issues with its recorder. The recording process made 
commands that matched with the keys pressed. This method has vastly 
different options. Also, you combine macros easily. Because of the process, 
you have to renumber all the options if you insert something, or combine 
macros. Just different.

Thanks for the reply.

Jean-Francois Nifenecker, Bordeaux

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:

 Michael D. Setzer II - Computer Science Instructor (Retired)                    
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer
+------------------------------------------------------------+ (Original)
Number of Seti Units Returned:  19,471
Processing time:  32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)


ROSETTA      65830382.685188 | ABC          16613838.513356
SETI        109545422.488558 | EINSTEIN    141424101.999240

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.