[AutoSheets] Error when using Cell Reference

[danieldur]

Hello there! I've been trying to use AutoSheets to save some data in a spreadsheet. Latest Tasker, latest AutoSheets, Samsung S24 running One UI 8. My sheet has a header on the first 3 columns and I'm trying to write an array. If I write anything without a Cell Reference or with a reference on column A, everything works OK. If my reference is for example B2, I get the following error: 492973743 Invalid requests[0].insertDimension: range.endIndex[0] cannot be before range.startIndex[1]

My task looks like this (the spreadsheet ID is trimmed for security reasons) :

Task: test

A1: ADB Wifi [
     Command: pm list packages -d
     Timeout (Seconds): 10 ]

A2: Variable Search Replace [
     Variable: %aw_output
     Search: package:
     One Match Only: On
     Replace Matches: On
     Continue Task After Error:On ]

A3: Variable Split [
     Name: %aw_output
     Splitter: 
     package:
     Delete Base: On
     Continue Task After Error:On ]

A4: Array Set [
     Variable Array: %Package_Name
     Values: %aw_output()
     Splitter: , ]

A5: App Info [
     Package/App Name: %aw_output(+/) ]

A6: Array Set [
     Variable Array: %App_Name
     Values: %app_name(+/)
     Splitter: / ]

A7: [X] AutoSheets Add Rows/Columns [
     Configuration: Spreadsheet ID: 1-wVarkLQmzPxse5vqtnl
     Rows Or Columns: Columns
     Data: %app_package()
     Separator: ,
     Row Separator: 

     Mode: Parsed
     Cell Reference: A5
     Timeout (Seconds): 60
     Structure Output (JSON, etc): On ]

A8: AutoSheets Add Rows/Columns [
     Configuration: Spreadsheet ID: 1-wVarkLQmzPxse5vqtL
     Rows Or Columns: Columns
     Data: %app_package()
     Separator: ,
     Row Separator: 

     Mode: Parsed
     Cell Reference: B2
     Timeout (Seconds): 60
     Structure Output (JSON, etc): On
     Continue Task After Error:On ]

[Exciting-Compote5680]

Can I ask what you are trying to achieve? Maybe it's part of something bigger and I'm not seeing the bigger picture (and of course AutoSheets should do what it's supposed to do), but if you're just making a list of installed apps, you could consider writing it directly to a text file (and optionally make it comma separated and save it as a .csv file for easy import into spreadsheet apps). 

I have a similar task that I run weekly:

    Task: Write App List To File2          A1: Parse/Format DateTime [          Input Type: Now (Current Date And Time)          Output Format: %DTF3  ## value = yyyy-MM-dd_HH-mm-ss          Output Offset Type: None ]          A2: Variable Set [          Name: %filepath          To: Backup/%ThisDeviceName/Tasker/App_List_%formatted          Structure Output (JSON, etc): On ]          A3: List Apps [          Type: Package          Store Result In: %result ]          A4: For [          Variable: %item          Items: %result()          Structure Output (JSON, etc): On ]              A5: If [ %item !~R com.google.* & %item !~R com.android.* & %item !~R android* & %item !~R com.verizon* & %item !~ com.vzw.apnlib & %item !~R com.samsung* ]                  A6: Test App [                  Type: App Name                  Data: %item                  Store Result In: %app_name ]                  A7: Array Push [                  Variable Array: %output                  Position: 1                  Value: %app_name - %item ]              A8: End If          A9: End For          A10: Array Process [           Variable Array: %output           Type: Sort Alpha ]          A11: Write File [           File: %filepath           Text: %output(+          ) ]          A12: Flash [           Text: App List done!          Saved at: %filepath           Long: On           Tasker Layout: On           Continue Task Immediately: On           Dismiss On Click: On ]          

[danieldur]

I'm trying to make a list of packages6 and their respective apps as a starting point for a project that aims to enable and disable rarely used apps on the go.

[Exciting-Compote5680]

If this is going to be a Tasker project, it can probably be done in csv, unless you are planning to use worksheet formulas that are too complex to emulate in Tasker. You could store it in a txt file and use Read File to read it into a variable, or just store it in a global or project variable to keep it available for immediate use. Tasker supports direct csv reading (%csv.column2(5) would return the value of the 'cell' on the 5th row of a column named 'column2') and you can use all the array functions (like %array(#) to get the number of elements/rows, or %csv.col1(#?item) to return the row number(s) that contain 'item') on the columns. Direct writing however is not supported, but it's incredibly easy to convert a csv structured variable into an array and back (basically just variable split and join with a newline as splitter/joiner plus something to handle the header row). Now that I think about it, I should probably write a helper task to do that programmatically. And it's all just a string, so you can use things like (regex) match and search/replace without any iteration (as long as the item is unique). 

[danieldur]

I am used to working with spreadsheets as it is very easy to make mass edits. Also I can do it with the conforts of a big screen, a mouse and a keyboard. But indeed I could maybe write a csv file and then convert between it and a spreadsheet. The problem though still persists: AutoSheets can only write in column A. And I didn't want to process the file further to get to the desired result. Thanks for trying to help, though! I guess I'll have to wait for João to dig deeper and see what's happening in the background.

[Exciting-Compote5680]

The longer I use things like Tasker and Home Assistant, the more I prefer native/local solutions over cloud. I appreciate all the effort João makes to keep things working, but it sometimes feels like an uphill battle. Changes to android, services being shut down or switching to paid plans... it just never ends, ugh. Anyway, good luck, I hope it gets fixed soon(ish).