Ask Your Question
0 Sum function in formula bar now activates a drop down menu

asked 2019-09-12 19:43:11 +0200

omniwill gravatar image

Prior to update to, clicking sum in the formula bar immediately invoked the sum action on the data. Now, clicking the sum symbol drops down a selection menu which requires me to mouse to the correct position/selection and click again. Can this be set to how it functioned in

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-09-12 20:42:10 +0200

ebot gravatar image

updated 2019-09-12 20:44:06 +0200

That was so decided and executed. tdf#120697

As workaround, you can add the "Sum" symbol to one of the toolbars yourself.

You can add the icon in the Tools>Customize menu.

image description

If my answer has solved your problem, please click on the checkmark in the circle image description to the left of the answer and click on the arrow ^ for upvote. This will tell the community that the question has been answered correctly.

edit flag offensive delete link more


With me Windows 10 Home; Version 1903; 64-Bit | LibreOffice, Version: (x64).

ebot gravatar imageebot ( 2019-09-12 20:44:21 +0200 )edit

That was an excellent suggestion. I was very happy to discover that the accept action (check mark) appeared and worked just like before in the formula bar when I customized the formatting toolbar. I placed the sum function in formatting toolbar right above the same actions in formula toolbar so it is easy to act on. Thank you for the suggestion.

omniwill gravatar imageomniwill ( 2019-09-12 21:39:50 +0200 )edit

You can put it in Keyboard Shortcut.

Gilberto Schiavinatto gravatar imageGilberto Schiavinatto ( 2019-09-12 22:37:07 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-09-12 19:43:11 +0200

Seen: 29 times

Last updated: Sep 12