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: libreoffice-bugs@lists.freedesktop.org Reporter: jovanda...@hotmail.com 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.