!ERROR! undefined variable ‘a1’

Thank you, that worked.

However I do have one more question.

I’m using a shortcoder plugin to execute any HTML or JS placed in it. Here is an example:

<span class="btc_eur"></span>
<script>
(function($){
	var cmc_ajax = $.getJSON('https://api.coinmarketcap.com/v1/ticker/bitcoin/?convert=EUR');
    cmc_ajax.done(function(data){
    	$('.btc_eur').text(data[0]['price_eur']);
    });
})(jQuery);
</script>

Placing this shortcode in the cell works well. However, when doing a formula (ex plus the value of the shortcode content with another cell) it gives me the “not contain a number or expression” error. I’m guessing it thinks the output from the shortcode is a string? Any workaround of this?

Thank you for your fast reply.

I see. Do you think there is an alternative way of doing the above example? Like converting the string to a float, or use something else than shortcode to display the numbers? I don’t know if you could point me in the right direction of a possible solution.

Thank you.