Hi Anke,
Doubt, should I be able to delete a row from the google spreadsheet when y select an item from the list, even if the Item are read in format CSV ?
Let me explain you waht I am traying to do.
I need to filter a colomn text from an spreadsheet, then I need to show those items in a list view , select ant specific item and errease the row with a botton
Before you do anything detailed in the test server, you should know that the Spreadsheets component will be released on ai2.appinventor.mit.edu within the next week.
you mean that we are not be able to use spreadsheet with App inventor any more ?
Just the opposite. Right now, the Spreadsheet component is only available on a testing server. Next week, we hope to make it available on our regular site.
Such a good news, great!!
So this is one of those fun (?) little details about how the internals of App Inventor works that causes things to break in odd ways. As a workaround, you could assign the result to a label's text field and then use that in the data. The internal fix is straightforward but likely an edge case the original implementor did not consider.
(added to Open Issues section of FAQ)
I couldn't spot if this issue has already been raised.
I tried to AddRow to an empty sheet on a spreadsheet.
This returned an error and did not "post" the data to the sheet:
"AddRow: Attempt to invoke interface method 'int java.util.List.size()' on a null object reference"
Everything worked fine once I had at least the first row with some data in it (even just A1)
(added to Open Issues section of FAQ
This is new to me, a 0-based row number return in filtered Get Rows request reponses.
I encountered this trying to do a simple sample of logging Arrivals and Departures in the same row.
I used my NYC Marathon sample as a framework, with an extra sheet for Arrivals/Departures:
Notice how this bug overwrote the Departure Time heading on column D, and logged Departures one row too high (-1 row) for each update.
Adding Arrival Times is straightforward:
Adding Departure Times is a two phase operation,
Here are the blocks:
The incriminating Do It result for the first occurence, where the column 4 heading got overwritten:
The exported .aia file, if you want to play:
MarathonSheetsWithArrivalDeparture.aia (20.0 KB)
The sheet:
If you have a previous thread where this error was found, please point to it.
I'm not sure how Sheets Component handles headings. Have you worked with column headings before?
Headings are pretty much required, due to the AI2 bug that doesn't let you add rows to an empty sheet. (See FAQ)
But it's not about the heading.
(Headings are not special in Sheets. They are just dead text in row 1.)
It's about using 0 as the base instead of 1 as the base for identifying rows.
I see. So are all the row identifiers off by one, as in its 0-indexed rather than 1-indexed?
Yes.
For a query that matches rows 4,5,6 the returned row numbers are 3,4,5.
That's indicative of a 0-based row enumeration.
Yup. This is not how it should work. I'm putting it on my issues to fix.
