Hello I'm working with a google spreadsheet and exhbit to show it. I add my records in a worksheet by an online form of googlespreadsheet. Then in an other worksheet there are calculate cells like this:
=IF(Foglio1!A2<>"";Foglio1!A2;"") If there is some value in main record of first worksheet it grabs the value of this and next records. If the value is blank the new records of second worksheet will be blanks. It is very simply. With exbhit I link to second worksheet. Everything go well but everytime there is a record blank so Exhbit show me this message: "1 result out of 4 cannot be plotted." I try to resolve this problem and I think that It has produced by the record after latest record with valid value. I think the script reads this record and It load the calculated record plotting an a void result. If I cancel the operation =IF(Foglio1!A2<>"";Foglio1!A2;"") in every record of the blank rows the error disappear. This problem doesn't permite me to have an automatic load of all valid record in exhibit without: "1 result out of 4 cannot be plotted." I'm sorry for my approximate english and thank for everyone who wants help me Daniele --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SIMILE Widgets" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/simile-widgets?hl=en -~----------~----~----~----~------~----~------~--~---
