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.
Please don't put your own reports as new, someone else must do it. And please ask your question in the forum, there are people with large knowledge with macros, that maybe can find a solution for your question.
Forum address https://ask.libreoffice.org/c/english/5
Thank you for your quick answer, m.a.riosv. I will try again on https://ask.libreoffice.org/c/english/5, but I already did it (on Jan 5th 2022 in French) and PYS suggested me to put my question directly to you ("... on our instance Bugzilla"). But let me emphasize the power and usefulness of my suggestion. It is equivalent to turning a source array into a range of tiny buttons. In my case, creating a clean and beautiful array of (27*27=) 729 tiny buttons (with calculated face value) is almost impossible ... Kind regards, JoVD.
(In reply to Jo Van Damme from comment #3) > Thank you for your quick answer, m.a.riosv. > > I will try again on https://ask.libreoffice.org/c/english/5, but I already > did it (on Jan 5th 2022 in French) and PYS suggested me to put my question > directly to you ("... on our instance Bugzilla"). Can you link to the French Ask LibO topic? I found this, which seems useful: https://ask.libreoffice.org/t/how-to-use-a-mouse-click-event-in-calc/27829