all 3 sample functions can write to sheet with sheetid = 0 (ie 'Sheet1') but only 2 to active sheet

[davidtew]

I have created a spreadsheet to demonstrate: https://docs.google.com/spreadsheets/d/1aYb1mycYTwy67j2E9KNbJ7YVeAITQUO-hjWmm6iBoeA/edit?usp=sharing

This is how I reproduced the situation:

A:)
The sheet 'validation' I have prepared in a column (ColC) with each function preceded by a tick '
In cell 'validations'!B2 I have put formula =filter(C:C,len(C:C))
Via Data validations which reference 'validations'B:B the formulas are now accessible in any other cell to run the sample functions.

B:)
Since in any cell the formulaes in validations!B:B are accessible via Data validation, I created a data validation in one cell, then copied cell to other cells, to a total of 3 cells, in 'Sheet1' .

C:)
I then duplicated 'Sheet1' to create 'Copy of Sheet1' (which of course has a different sheetid).

D:) Experiment
1)
From the drop down in 'Copy of Sheet1'!B8 , I chose from the list: =RUN("getFileNamesFromFolderName"," ' Scarlett")

This wrote file names to sheet 'Copy of Sheet1'

From the drop down in 'Copy of Sheet1'!B7 I chose from the list =RUN("putValues","sample1","sample2","sample3")
And from the drop down in 'Copy of Sheet1'!B6 I chose from the list =RUN("setColors",ROW(),COLUMN(),10,15)

The experiment results:
Firstly, 'Copy of Sheet1'

Secondly,'Sheet1'

[tanaikech]

Thank you for your comment. The sample script is a simple sample script for confirming this methodology. So I think that this cannot be used for various situations. About this, I have to apologize.

The sample script uses the sheet ID of 0 by sheetId: 0,. I think that this is the reason of issue. And also, these sample scripts put the below rows of the formula. So when the formula is put to the continuous rows, it might not be able to be used. But, this is not the bug. If you want to use the sample script for other sheets and the continuous rows that the formulas are put, please modify the scripts.

If I misunderstood your comment, I apologize. At that time, please tell me.

[davidtew]

Thank you for responding. I have read the thread more deeply (op gilbert_RGI <gilbert.rgi@gmail.com> ) and I can understand now that the challenge is mysterious. I apologize for taking your time since I have not helped with the issue. However, I would like to take this opportunity to thank you for all your very useful work. I have learnt a lot from your code, sometimes to adapt for use in my work, and other to give good ideas for how to improve productivity. In this particular case I have learned both: from your code, particularly wrt creating the object for batchupdate (so I have understood that I can add values as well as their formats in a batchupdate); and your wonderful idea of RUN, whereby, using the dropdown I have shown in my example, I can experiment with another way to enhance the interface for my team, when they might have to list the latest modified files, for example. So, I thank you Kanshi for your excellent and leading contribution Regards David Tew

…

On Tue, 7 Jul 2020 at 06:23, Kanshi TANAIKE ***@***.***> wrote: Thank you for your comment. The sample script is a simple sample script for confirming this methodology. So I think that this cannot be used for various situations. The sample script uses the sheet ID of 0 by sheetId: 0,. I think that this is the reason of issue. And also, these sample scripts put the below rows of the formula. So when the formula is put to the continuous rows, it might not be able to be used. But, this is not the bug. If you want to use the sample script for other sheets and the continuous rows that the formulas are put, please modify the scripts. If I misunderstood your comment, I apologize. At that time, please tell me. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#1 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABWG6GH6IP7ZIP5DOTDW3IDR2KWOLANCNFSM4OSNQBRQ> .

-- Regards David Tew *01522 704293*