Obsolete
Status Update
No update yet.
Comments
di...@google.com
would be useful!
gf...@google.com
much needed
vi...@google.com
I need to monitor active sheet because I have different side bar for every sheet. What I'm doing now is running a JavaScript from the client side every 1s (second) to call google.script.run.monitorTabChange();. This function reads current active sheet's name and compares it with a sheet name that had been saved in a PropertyService during the last call of google.script.run.monitorTabChange();.
The spreadsheet with this script helps me with creating Purchase Orders. It pulls data from Salesforce and Quickbooks and generates a PO. So for every PO for every customer I am duplicating the spreadsheet and of course the script. The problem that I am facing is running out of quota. I have generated tons of POs already and each of them runs (even if the spreadsheet is not opened - I tested it) the 'monitorTabChange' function, which calls PropertyService. I have 100 000 quota for PropertyService calls. And I'm running out of it pretty quickly now.
The trigger 'OnSheetChange' would then save me (probably many others too) from this issue. At the same time it would saved Google tons of execution overhead (that could be significant if lots of people use the solution I do to track the sheet change).
Thanks!
The spreadsheet with this script helps me with creating Purchase Orders. It pulls data from Salesforce and Quickbooks and generates a PO. So for every PO for every customer I am duplicating the spreadsheet and of course the script. The problem that I am facing is running out of quota. I have generated tons of POs already and each of them runs (even if the spreadsheet is not opened - I tested it) the 'monitorTabChange' function, which calls PropertyService. I have 100 000 quota for PropertyService calls. And I'm running out of it pretty quickly now.
The trigger 'OnSheetChange' would then save me (probably many others too) from this issue. At the same time it would saved Google tons of execution overhead (that could be significant if lots of people use the solution I do to track the sheet change).
Thanks!
Description
Android Studio 3.0
Build #AI-171.4408382, built on October 20, 2017
JRE: 1.8.0_152-release-915-b08 x86_64
JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.o
Mac OS X 10.12.6
Studio Build:
Version of Gradle Plugin: 3.0.0
Version of Gradle: distributionUrl=https\://
Version of Java:1.8.0_152-release-915-b08 x86_64
OS: Mac OS ( Host )
Steps to Reproduce:
1. git clone
2. with Android Studio, "File" -> "New" -> "Import Project", navigate to the source code and point to $local_repo/hello-libs/build.gradle. Wait for Android Studio import complete, and let it upgrade to 3.0 scripts
3. inside Android Studio IDE, open project build.gradle, add "google()" to repositories
4. enable library dependency with:
a) settings.gradle file, uncomment line:
include ':gen-libs'
b) build.gradle(Module:app) file, bottom of the file, enable
compile project(':gen-libs')
( I tried to change "compile" to "api", the result is the same )
5) Sync project and build APK
expected: APK to be built.
The real result/symptoms:
====================
:gen-libs:generateDebugSources UP-TO-DATE
:gen-libs:javaPreCompileDebug UP-TO-DATE
:gen-libs:compileDebugJavaWithJavac UP-TO-DATE
:gen-libs:processDebugJavaRes NO-SOURCE
:gen-libs:transformClassesAndResourcesWithPrepareIntermediateJarsForDebug UP-TO-DATE
:app:javaPreCompileDebug
:app:compileDebugJavaWithJavac
:app:generateJsonModelDebug UP-TO-DATE
:app:externalNativeBuildDebug
Build hello-libs arm64-v8a
ninja: error: '/Users/gfan/proj/android-ndk/hello-libs/distribution/gperf/lib/arm64-v8a/libgperf.so', needed by '/Users/gfan/proj/android-ndk/hello-libs/app/build/intermediates/cmake/debug/obj/arm64-v8a/libhello-libs.so', missing and no known rule to make it
:app:externalNativeBuildDebug FAILED
FAILURE: Build failed with an exception.
* What went wrong:
Execution failed for task ':app:externalNativeBuildDebug'.
> Build command failed.
Error while executing process /Users/gfan/dev/android-sdk/cmake/3.6.4111459/bin/cmake with arguments {--build /Users/gfan/proj/android-ndk/hello-libs/app/.externalNativeBuild/cmake/debug/arm64-v8a --target hello-libs}
ninja: error: '/Users/gfan/proj/android-ndk/hello-libs/distribution/gperf/lib/arm64-v8a/libgperf.so', needed by '/Users/gfan/proj/android-ndk/hello-libs/app/build/intermediates/cmake/debug/obj/arm64-v8a/libhello-libs.so', missing and no known rule to make it
suspecting something wrong with the dependency of lib's native build.