Let's assume a very simple worksheet where I have in A1 a number, and in B1, the formula
=A1*2 Right now I'm using the batch update process to modify the content of several cells at the same time. I like that the response of that request gives me the value of those changed cells, in case I have updated their formula. However, and using the previous example, if I change the value of A1 I only get A1 back in the response. I would love to receive both A1 and B1 (the dependent cells) so that I can see all the changes to the worksheet at once. I understand that this poses a problem when the dependent cells are not in the current worksheet (or even in the current workbook), but if you follow what Excel does in VBA in terms of the *Dependents* and *Precedents* properties of a range object, then we would get as part of the response the dependent cells of the corresponding worksheet. Maybe using a header or a variable in the request body can turn this on but leave it off by default?
