node-red-contrib-viseo-google-spreadsheet : Problem delete _sheet cache

NGRP / node-red-contrib-viseo

Node-RED nodes OpenSourced by VISEO Technologies

Apache License 2.0

227 stars 83 forks source link

node-red-contrib-viseo-google-spreadsheet : Problem delete _sheet cache #96

Open Christian-Me opened 5 years ago

Christian-Me commented 5 years ago

Hi,

I have problem deleting the global._sheet cache. Using Change node, as discribed in the info, is not working, still old values. Using a function with global.set("_sheet","") erases the global variable but the Google sheet node still comes up with outdated data.

Changing the range by msg.payload even brings only the data of the first loaded range after restart.

What am I doing wrong?

Klervix commented 5 years ago

Hi, Can you give me your Spreadsheet node's configuration?

Thank you!