The latest articles on DEV Community by NacNac (@nacnac). https://dev.to/nacnac https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F876173%2F361abf0f-acf9-445b-9492-e50182cdf772.png https://dev.to/nacnac en NacNac Tue, 21 Jun 2022 07:54:23 +0000 https://dev.to/nacnac/strange-behaviour-of-sheet-2jp https://dev.to/nacnac/strange-behaviour-of-sheet-2jp <p>Hi<br> I have created in the past a spreadsheet that go and fetch data from another website<br> This is a financial table where I get the current market price (in the exemple below it is about cryptocurrencies)</p> <p>value(index(importhtml(concat("<a href="https://coinmarketcap.com/currencies/%22,B7),%22table%22,1),1,2))">https://coinmarketcap.com/currencies/",B7),"table",1),1,2))</a>)</p> <p>The formula works very well.<br> My table list the different purchases or sales, calculate the average cost and calculate the profit and loss based on real time value with the formula above.</p> <p>Until recently everything worked fine.</p> <p>I am now adding new calculations which have nothing to do with the above formula nor do I refer to the cells used by the above formula or call for the results of the above formula.</p> <p>The new calculations works fine. However, at random, the above formula shows #N/A instead. Once it shows #N/A it never goes back to display the current price.<br> I first thought there was some problem with coinmarketcap. In that case once coinmarketcap is working again, the #N/A should be automatically replaced by the value of the coin. No once the cells display #N/A and stay at #N/A.</p> <p>I thought I messed with the spreadsheet somehow. I restored a previous version (the last one before I started to add the new calculations) and the price of the coins are displayed again.<br> I started again with the new calculation (for info the new calculation are in a separate worksheet and as mentioned it does not refer to above formula). It works fine for a little while and suddenly, some of the cells having the above formula start showing #N/A</p> <p>This makes me crazy. No matter what I do, those cells somehow ends up (but not all) with #N/A. What I mean is that I have about 20 cells using the above formula and when the problem occurs, sometimes it occurs for all the cells using the above formula, sometimes not.<br> I seems random.<br> I am starting to wonder if there isn't a bug in Sheet (after all Excel is full of bugs, so why not Sheet :) )</p> <p>Has anyone encountered such behaviour?<br> Thanks</p>