Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question