Re: [libreoffice-users] User interface: [cntl-F2] in Calc

If you want to assign a shortcut to do both actions, one solution might
be to create a macro for it.

Do Tools->Macros->Edit Macros, then add the following to the module:

sub ArrayFunctionDialog
  frame = ThisComponent.CurrentController.Frame
  dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
  dispatcher.executeDispatch(frame, ".uno:SelectArrayFormula", "", _
                             0, Array())
  dispatcher.executeDispatch(frame, ".uno:FunctionDialog", _
                             "", 0, Array())
end sub

Now you should be able to find the macro in keyboard customisation
dialog under Application Macros->My Macros->Standard->Module1 and then
ArrayFunctionDialog.

It does seem like it would be better if Ctrl+F2 edited the array
function by default instead of doing nothing. I think opening an
enhancement request would be a good idea.

Regards,
– Neil

David Lynch <dlynch1319ng@gmail.com> writes:

> With the increased selection of array functions in Calc, I am needing to
> [cntl-/][cntl-F2],frequently.
>
> Can I configure Tools -> Customise -> Keyboard, to replace
> [cntl-/][cntl-F2] with a single key stroke?
>
> Currently [cntl-F2] with a cell containing an array function spilling into
> other cells does nothing. Are there any problems arising if the behaviour
> is changed to that of [cntl-/][cntl-F2] currently?
>
> If not, I will make an enhancement request.
>
> David Lynch
>
> -- 
> 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

-- 
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