I am evaluating Spreadsheet for inclusion in an internal web app and I have 2 questions/issues. If I can't resolve them, it will be a show-stopper.
Referencing cells on 2nd sheet
When creating a formula, I can easily click on a cell in the same sheet and its reference in included in the formula. Very good. However, from what I have seen this is not the case when I want to use a cell that is on a 2nd sheet. I can't just go to the cell and click on it and the reference in included in my formula. Am I doing something wrong or is that expected behaviour?
Insert lines on 2nd sheet doesn't update formula reference
Assume I have a formula on Sheet1 that contains a reference to say Sheet2!A1. Now on Sheet2, I insert a new column at A. So, the cell I want to reference is now Sheet2!B1. As far as I can tell, the formula back on Sheet1 does not get updated to reference Sheet2!B1 like Excel does. Again, am I doing something wrong or is that expected behaviour?
Can you please provide some guidance as soon as possible.