LibreOffice Calc - Click on cell -> open info window using Zenity or YAD

Does anyone know of a way (or available plugin) that would open a context-specific (a.k.a. cell-specific) formatted information window (using YAD or zenity) to provide guidance related to the topic listed in the specified cell?

For context, I’m looking to add a TARGET-specific pop-up window for each of the TARGETS with guidance specific to the context of that TARGET for the given Chain/Table combination.

I’m already aware that I could add a hyperlink, which would force me to store the Guidance docs as distinct web pages available from GitHub, but I would rather have that guidance somehow embedded in a single companion document that is parsed by the “click-function” of what will likely be a macro calling an external function or an embedded bash script. I did a quick test with the mouse-over “Comment” function, but that just doesn’t cut it for the reason that I can’t format the contents.

Any ideas or suggestions?

2 Likes

Maybe yad with --text-info? YAD Text

1 Like

I’m NOT an expert with either Zenity or Yad, yet in spite of that, I’ve taken work that OTHERS have done, grabbed their code, modified the parts I wanted to use, and thus I’ve written several really simple, functional, quick interfaces for various tools. Examples I’ve written from the code I extracted include clocks, system and package updating via a simple graphical interface and test tools for one of my favorite distributions.

1 Like

Thank you, Hayden and Brian!

I am less concerned with the Zenity/YAD aspect, as I am with identifying the proper functionality (macro/function) within LibreOffice that will allow me to call that external function which will react to the click-on-box to

  • extract the context “label” from the box,
  • then extract the appropriate guidance segment,
  • then present the guidance in a pop-up window using the Zenity/YAD
1 Like