Have an simple Android-App to fill a Google-Sheet with Data:
URL listFeedUrl1 = new
URI(sCashListworksheet.getListFeedUrl().toString() +
"?sq=id="+_id).toURL();
...
ListFeed listFeed1 =
sCashKatService.getFeed(listFeedUrl1, ListFeed.class);
List<ListEntry> liste =
listFeed1.getEntries();
...
ListEntry row = new ListEntry();
row.getCustomElements().setValueLocal("column_name", "value");
row.getCustomElements().setValueLocal("id", String.valueOf(_id));
...
row =
sCashKatService.insert(listFeedUrl1, row);
Works perfect and inserts a new Line in my Worksheet "ausgaben".
A second Worksheet ("auswertung") contains some formulas (ie. sum for an
Category) like "=ausgaben!E179"
When I add a new line (per browser ) in the sheet "ausgaben" the value is
shown in "auswertung".
But when I add an line with my app happens this:
The Line is shown in "ausgaben".
But the corespondending field in "auswertung" has changed and shows the
next (empty) row.
Sample:
direct enter:
before:
"ausgaben"
a1: 100
a2: 200
a3: 300
a4:
a5:
"auswertung"
a1: =ausgaben!a1 (shows 100)
a2: =ausgaben!a2 (shows 200)
a3: =ausgaben!a3 (shows 300)
a4: =ausgaben!a4 (shows "")
a5: =ausgaben!a5 (shows "")
after:
"ausgaben"
a1: 100
a2: 200
a3: 300
a4: 400
a5:
"auswertung"
a1: =ausgaben!a1 (shows 100)
a2: =ausgaben!a2 (shows 200)
a3: =ausgaben!a3 (shows 300)
a4: =ausgaben!a4 (shows 400)
a5: =ausgaben!a5 (shows "")
now per app:
(before is the same as above)
after:
"ausgaben"
a1: 100
a2: 200
a3: 300
a4: 400
a5:
"auswertung"
a1: =ausgaben!a1 (shows 100)
a2: =ausgaben!a2 (shows 200)
a3: =ausgaben!a3 (shows 300)
a4: =ausgaben!a5 (shows "") (expected: formula "=ausgaben!a4"
shows 400)
a5: =ausgaben!a6 (shows "")
The Cell a4 (and all following) has changed.
The Formulas on the next Columns are untouched.
looks like the sheet handles the cell as removed and inserted but only the
remove is submitted to the linked cells.
Is this a Bug or have i missed something?
best regards from vienna
Schlawina
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
