Enable

i have lookup formula use gather information different page in spreadsheet: =(vlookup($a$3,lookup!$a$3:$ag$472,2,false)*0.01) but if there no data in cell of lookup page, returns value of 0 . cell remain blank, same original cell. try this: =if(vlookup($a$3,lookup!$a$3:$ag$472,2,false)="","",vlookup($a$3,lookup!$a$3:$ag$472,2,false)*0.01)

i know how set og tags pages specify image, here situation: i have page 4 shareable objects. 1 leads page it's own open graph tags, he's okay. other 3 share link anchor position on same page. how make each of own image? so instance: shareable 1: http://www.demo.com/page <--- fb get's og tags page shareable 2: http://www.demo.com/home#video <-- fb get's og tag home, want specify different image shareable 3: http://www.demo.com/home#photos <-- fb get's og tag home, want specify different image shareable 4: http://www.demo.com/home#cheese <-- fb get's og tag home, want specify different image information afer hashtags gets ignored, have rewrite or parameter, example: http://www.demo.com/home?id=xxx http://www.demo.com/home/video

i have folder may or may not contain forms , connected response spreadsheets. however, code below returns false when these files present. //checks number of google forms in subdomain folder var files = myfolder.getfilesbytype('google_sheets'); logger.log(files.hasnext()); this code returns true: var files = myfolder.getfiles(); logger.log(files.hasnext()); i'm imagining i'm somehow getting mimetype wrong, far can see in google's documentation correct. i'd rather check these file types instead of checking files. any thoughts? mimetype.google_sheets try instead of 'google_sheets'. i'm not able test @ moment, format google documentation asking for. take notice there not quotes around it.

i created little module in drupal 7 use custom config file ck editor. works, because can adapt ui color or can activate scayt , edit options imn scayt. so think custom config file working ok. tried saomething plugins in install folder of ck ... seems these not active or not loaded. there difference between assemble ck editor via ck builder , download plugins manually , activate plugins via config.extraplugin = 'floating-tools'; i have expierence, lot of plugins, download not active .... why there no visible control in settings dependig plugins???? how check if plugin loaded. there thing after configuration in custom config file made changings take effect? ...sorry seems dont understand way use ck builder ... i´m confused ... today uploaded build-config.js , added , reduce plugins ... downloaded new version 4.5.4. .. ??? used 4.5.3 before ... then pasted new ck-editor libraries folder of drupal installation , nothing works ... no ckeditor comes editing content...

i having trouble code. when run it, prints out 2 lines in while statement. i'm trying run if statement until mortgageleft can see mistake i'm making? idk if helps, if delete else statement, program runs fine #include <stdio.h> #include <stdlib.h> int main(){ float mortgageleft, interestrate, monthlypayment, monintrate, amountowed; int month=0; printf("what value left on mortgage?\n"); scanf("%f", &mortgageleft); printf("what annual interest rate of loan, in percent?\n"); scanf("%f", &interestrate); printf("what monthly payment?\n"); scanf("%f", &monthlypayment); monintrate= (interestrate/12)/100; printf("month\t\t payment\t amount owed\n"); while (mortgageleft>0) { if(mortgageleft>monthlypayment) { mortgageleft=(mortgageleft*monintrate)+mortgageleft; mortgageleft=mortgageleft-mon...

i'm attempting use nsbatchdeleterequest delete pile of entities, many of these entities have delete cascade and/or nullify rules. my first attempt delete fails , nserror includes string "delete rule not supported batch deletes". had thought fine delete such things responsible making sure constraints satisfied before save. should able batch delete these managed objects? (i want keep delete rules, other delete paths don't have easy way know set of objects delete) kinds of batch deletes work in case, others not? (say predicates fail, list of object ids work?) batch delete problematic relationships. it goes directly database , deletes records suspending object graph rules, including delete rules. have correctly identified requirement need constraint checking again. (that deal-breaker.) even if manage delete entities , necessary related entities correctly, still left lots of entries in (opaque) join table core data creates in background. there ...

i don't know what's happening powershell. have shell registry key allows me open powershell window in directory. content is: c:\windows\system32\windowspowershell\v1.0\powershell.exe -executionpolicy unrestricted -noexit and custom defined prompt function: function prompt { write-host ("on ") -nonewline -foregroundcolor white write-host ("$env:computername") -nonewline -foregroundcolor gray write-host (" in ") -nonewline -foregroundcolor white write-host ($(get-location)) -foregroundcolor gray write-host ("$") -nonewline -foregroundcolor magenta return "> "; } it should return on pc-name in c:\ $> however, returns this: on pc-name in c:\ $> ps c:> anything wrong @ powershell? how more debug information guys? i fix issue commenting out few functions in psreadline module installed. module add `b end of current prompt, append user prompt it, , re...