On 21 Sep 2018 at 7:25, Jean-Francois Nifenecker wrote: Subject: Re: [libreoffice-users] Issues with macro recorder?? To: users@global.libreoffice.org From: Jean-Francois Nifenecker <jean-francois.nifenec...@laposte.net> 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. > HTH, > -- > Jean-Francois Nifenecker, Bordeaux > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy +------------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +------------------------------------------------------------+ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS ROSETTA 65830382.685188 | ABC 16613838.513356 SETI 109545422.488558 | EINSTEIN 141424101.999240 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy