Would some of you have ideas for more elegance? I have seen quoted a thousand times the link “ but we know all that the is dead and buried. We are therefore obliged, for the empty cell with temporary content, to hide its contents.īUT, in any case, it remains that the reading/analysis of the HYPERLINK URL is a pure shame of programming. While I'm very happy that this set works perfectly, even if the spreadsheet is protected, the final cleaning of the cell does not work if the sheet is protected. Even the most reluctant to use the spreadsheet cannot fail to admit this obvious. The incremental validation in check or uncheck with the arrow keys and the space bar is ecstasy that no normal control allows. Set up 500 checkboxes in a column take few seconds. We go to the cell with the arrow keys, we press on the spacebar for switches the control in hyperlink form. It works, it is fast enough to be discreet, but it is terribly laborious and very ugly. Cleaning the cell of its contents immediately.Putting this in an empty cell of the spreadsheet, which causes its interpretation.Taking the complete formula HYPERLINK as a string of characters.I would need a function of the type “ EVAL”. Here, what I want to recover is the result of the URL passed to HYPERLINK. But part of its result is much more complicated. To recover the formula of a cell is obviously very simple. And as I still want the copy/paste is done very easily, I use ADDRESS, ROW and COLUMNS functions. It is quite different for the radio buttons which, in addition to communicating the location of the clicked button, obviously also give the range of cells in which they act. Recovering the “ type” of the checkbox can also be done relatively easily, even if I specify, in the comment, that it is, according to my view of things, a bit coded with my feet. In the context of the call of the checkboxes, it is still relatively easy because the selection is, by definition, in place on the cell that receives the call from the spacebar. The URL’s reconstitution contained in the HYPERLINK function is not easy. Call the correct procedure, checkBox() or radioButton().
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |