Do you confirm this?
My problem is that I have two calc sheets: the first is the one with formulas and charts while the second contains data updated from Internet via a script.
The first sheet gets the data (indexed by the date and the columns can have different length during the various updates) from the second one and automatically updates the calculation.
Unfortunately, the charts ranges are not updated according to the updated data. I cannot use any function as
match, address, offset, vlookup.
Is there any workaround?