OOBasic Date Picker dialog

[sajnoor]

hi

need help have installed calendar add on and it works fine when i press control + shift + F2 or tools then add on and choose calendar, after installing this add on from here https://sourceforge.net/projects/aoo-ex ... t/download
i have now installed date picker above i am new to macros how do i automate this macro so when i select row calendar appears or so add on installed appears with one key instead of 3 keys together.
many thanks in advance without you lot i would be lost

saj

Edit: Split from a Code Snippets topic. That forum is not for help on the snippets provided.

[Villeroy]

Code: Select all

srv = createUnoService("vnd.pycalendar")
srv.trigger("")

Works if the current frame has a document.
Fails when called from Basic IDE.
Fails with LibreOffice 6.1

[sajnoor]

Code: Select all

srv = createUnoService("vnd.pycalendar")
srv.trigger("")

Works if the current frame has a document.
Fails when called from Basic IDE.
Fails with LibreOffice 6.1

Was this for me ?

[Villeroy]

This is how you can call the dialog from StarBasic. You can save this as a StarBasic routine and call that routine with your own shortcut.
Otherwise, you may modify the file Accelerators.xcu of the add-on package:

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<oor:component-data
 xmlns:oor="http://openoffice.org/2001/registry"
 xmlns:xs="http://www.w3.org/2001/XMLSchema"
 xmlns:install="http://openoffice.org/2004/installation"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 oor:name="Accelerators"
 oor:package="org.openoffice.Office">
  <node oor:name="PrimaryKeys">
    <node oor:name="Modules">
      <node oor:name="com.sun.star.sheet.SpreadsheetDocument">
        <node oor:name="F2_MOD1_SHIFT" oor:op="fuse">
          <prop oor:name="Command">
            <value xml:lang="en-US">service:vnd.pycalendar?execute</value>
          </prop>
        </node>
      </node>
    </node>
  </node>
</oor:component-data>

[sajnoor]

This is how you can call the dialog from StarBasic. You can save this as a StarBasic routine and call that routine with your own shortcut.
Otherwise, you may modify the file Accelerators.xcu of the add-on package:

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<oor:component-data
 xmlns:oor="http://openoffice.org/2001/registry"
 xmlns:xs="http://www.w3.org/2001/XMLSchema"
 xmlns:install="http://openoffice.org/2004/installation"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 oor:name="Accelerators"
 oor:package="org.openoffice.Office">
  <node oor:name="PrimaryKeys">
    <node oor:name="Modules">
      <node oor:name="com.sun.star.sheet.SpreadsheetDocument">
        <node oor:name="F2_MOD1_SHIFT" oor:op="fuse">
          <prop oor:name="Command">
            <value xml:lang="en-US">service:vnd.pycalendar?execute</value>
          </prop>
        </node>
      </node>
    </node>
  </node>
</oor:component-data>

Where do i place this code ? or how do i modify accelerators.xcu new to spreadsheets so asking very basic questions for some of you on here

[Villeroy]

The downloaded pycalendar-3.4.3.oxt is a zip archive. Extract it, load Accelerators.xcu in a text editor, change the "F2_MOD1_SHIFT" entry, rebuild the archive and install it.

[sajnoor]

The downloaded pycalendar-3.4.3.oxt is a zip archive. Extract it, load Accelerators.xcu in a text editor, change the "F2_MOD1_SHIFT" entry, rebuild the archive and install it.

perfect assigned to f3 key works a treat many thanks