Google Sheet API does not have getFormulaR1C1 fro CellEntry in PHP library -


is there way hyperlink or formula cell?

basically, in worksheet have cell hyperlink formula (=hyperlink('http://blabla.com', 'link1')). when try value of cell gives me visible content ('link1'). there other way have formula instead of visible content?

enter image description here

there's seems way using apps script (however you're using php so..)as mentioned in so thread:

function geturl() {   var range = spreadsheetapp.getactivesheet().getactivecell();    //logs - google   logger.log(range.getvalue());    //logs - =hyperlink("http://www.google.com", "google")   logger.log(range.getformular1c1());    //simple regex first quoted string   var url = /"(.*?)"/.exec(range.getformular1c1())[1];    //logs - http://www.google.com   logger.log(url); } 

Comments

Popular posts from this blog

'hasOwnProperty' in javascript -

python - ValueError: No axis named 1 for object type <class 'pandas.core.series.Series'> -

java - How to provide dependency injections in Eclipse RCP 3.x? -