https://bugs.documentfoundation.org/show_bug.cgi?id=146613
Bug ID: 146613
Summary: Calc enhancement: Triggering a macro by
(double-)clicking a cell.
Product: LibreOffice
Version: 7.2.4.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Conditional formatting is basically meant to apply a style to a cell based on
its content. But it would be so useful and powerful for many developers if this
conditional formating also offered the possibility to call a macro when the
cell (on which a conditional formatting form already depends) was
(double-)clicked...
For example: I am now confronted with the problem of having to copy into a
target array (of 9 x 9 elements) the value of cells chosen by (double-)clicking
in a source array (of 27 x 27 elements)(the values of this source array being
themselves calculated (each containing a formula) and the address of the target
cell being a function of the address of the source cell).
The extended conditional formatting on each source cell would suit me perfectly
in this case. At the moment, I have no idea how else to solve this problem.
Thank you in advance for your attention to this request.
Actual Results:
Nothing. At the moment, I have no idea how else to solve this problem.
Expected Results:
(Double-)Clic on source cell -> Triggering of a macro calculating the target
cell address and copying the value of the source cell to the calculated target
cell.
Reproducible: Always
User Profile Reset: No
Additional Info:
Thank you.
--
You are receiving this mail because:
You are the assignee for the bug.
