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


I have only been successful at using keyboard commands. Sometimes interpretations in the code require correction. In general, it usually works though.


On 9/4/2018 8:08 AM, Michael D. Setzer II wrote:
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:mikes@guam.net
  mailto:msetzerii@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+unsubscribe@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

Context


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.