IssueTracker

What steps will reproduce the problem?

1. Create a custom function

function textBox(textBoxValue) {
  return textBoxValue;
}


2. put this in a cell   =textBox("eddyparkinson at mailaddress")


3. Wait (about 1 day is long enough) for the cell value to
   become #N/A  (not sure what causes the value to become #N/A, a cache time out?)


4. Use  
     Range.getValues(); to get the value from the cell.
   


Example code


function doGet() {
  var spreadsheetKey = "hhhh";
  var webPageSheet =  SpreadsheetApp.openById(spreadsheetKey).getSheetByName("WebPage");  
  var instantAppRange = webPageSheet.getRange("A31:A50");
  var rangeGuiData = instantAppRange.getValues();
  var customFunctionValues = "";
  for(var rowIndex in rangeGuiData) {
    customFunctionValues = customFunctionValues + rangeGuiData[rowIndex][0];  
  }
  var app = UiApp.createApplication();
  var panel = app.createVerticalPanel();
  panel.add(app.createLabel("customFunctionValues:"+customFunctionValues));
 
  app.add(panel);
  return app;
 
}






What is the expected output? What do you see instead?
Expected:  The value of the cell
Instead: #N/A

On which browser & OS?
Windows 7, chrome/firefox (All I think)




Please provide any additional information below.


The #N/A is the value before the custom function executes.
When to re-execute the custom function looks to be an issue.
It looks like there is a need for two types of custom function.
  One that uses ONLY parameter data and so only recalculates when
 a parameter value changes.
  One the uses "global" data, and need some other kind of refresh
  trigger (onOpen/timer/onedit). It would be handy if the programmer could specify the refresh trigger.  


The problem tends to happen if:
  1) I open this link when the spreadsheet has not been used for a day or so.
https://docs.google.com/macros/exec?service=AKfycbw2rasA3h9W4Dc3wBU461lufh_3yEuc3HgklkEYdg&key=0Ap_hLS0f4NTVdGVsRTNKaWxGbE5DNTUzMHY2R21USFE

The link creates a Web App using only spreadsheet functions.
But all the time I get #N/A. Making it unusable in the current state.


OR

  2) if a change has just been made to the sheet and it is recalculating.


 the Ugly workaround is to reload if "#N/A" is returned, but this
  is slow, with several client server calls.
 e.g.

      for(var counter=15;rangeGuiData.values[row][col].toString() == "#N/A" && counter>0; counter--) {
          rangeGuiData.values = instantAppRange.getValues();
      }