Hello Dev Team, I have been trying to extend the functionality of the Calc formula bar input line.
Let me explain the scenario first : I have defined a function that takes in a single argument which is a string and contains, apart from other tokens, range names. I would like to highlight these range names in different colors. So i need to access the text font in the formula bar and change the font color for only certain portions of my string argument. In excel, when you select different ranges in a formula (arguments that are range objects) , the formula bar highlights the range names as well as the actual cell ranges present on the sheet in different colors. I am trying to attempt something similar but in a string argument as opposed to range arguments. I found out that all the standard tools bars have resource urls that follow the format : "private:resource/toolbar/" but could not find one for the formula bar. And I also know that to focus on the input line you can execute a dispatch command with the url ".uno:FocusInputLine". Someone suggested using a text cursor but i believe that it only for text objects. How can I modify and format the text in the formula bar and not the cell. Previously I was trying to do this in excel in which you can access the formula bar through Windows API but found out that in edit mode it is impossible to run any macro and so gave up and migrated to openoffice ! Any leads will be highly appreciated. I would like to attempt it through the API and not the source code as I an not a java or c++ expert. I code in OOBasic. Any suggestions !! Many many thanks ! Best, Rashi