A
A
Alexander Burov2019-02-24 18:23:00
Macros
Alexander Burov, 2019-02-24 18:23:00

How to create a button in an Openoffice Calc table cell and assign a function (macro) to it?

I ask you to help create a button in a given cell using the simplest example (I will figure it out myself later). I tormented Google - I did not find anything understandable. Office version 4.1.6.
Given:
1) cells in row A contain either numbers or are empty;
2) cell B1 contains a real number b, B2 contains a natural number n.
Required:
create a button in cell C2, by pressing it, run a script that, in the range of cells from A1 to An, sets the background color #ffaa11 to those of them whose value is strictly greater than b, and the values ​​of the remaining cells from the range are summed up and assigned to cell C1.
The example can be in any language (preferably Java).

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question