Wondering if there is any documentation on things that don't work with the recorder.
Just tried again and most of it worked, but some issues came up. First, entered a formula, and it worked in the recording, but in playing the macro it failed. Was able to modify the lines, and got it to work. dim args7(0) as new com.sun.star.beans.PropertyValue args7(0).Name = "StringName" args7(0).Value = "=if(I1=""Life"";""12/18"";i1)" Had to add the double quotes versus how it was recorded. 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. dim args16(0) as new com.sun.star.beans.PropertyValue args16(0).Name = "ToPoint" args16(0).Value = "$h$1" dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args16()) rem ---------------------------------------------------------------------- dispatcher.executeDispatch(document, ".uno:DeleteColumns", "", 0, Array()) dim args17(0) as new com.sun.star.beans.PropertyValue args17(0).Name = "ToPoint" args17(0).Value = "$L$1" dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args17()) rem ---------------------------------------------------------------------- dispatcher.executeDispatch(document, ".uno:DeleteColumns", "", 0, Array()) +------------------------------------------------------------+ 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 65755566.519455 | ABC 16613838.513356 SETI 109507116.947618 | EINSTEIN 141355143.499240 -- 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
