138 reputation
6
bio website epeleg.blogspot.com
location Israel
age 43
visits member for 1 year, 11 months
seen Jul 13 at 4:56

Trying to reach out to me? use "epeleg" my username on gmail.com.


Jul
9
comment Looking for an “isFormula” formula for Google Spreadsheets
but what is the type if the parameter I will get in such a function? can I have a custom function called sizeOf(range) that will return the number of cells in that range? (and again - gets called as sizeOf(a1:b2) and not sizeOf("a1:b2") or any other syntax ?
Jul
9
comment Looking for an “isFormula” formula for Google Spreadsheets
interesting. it works for my gmail account but not in my google apps account...
Jul
9
comment Looking for an “isFormula” formula for Google Spreadsheets
nice. looks like Google are adopting my recommendation :) But how do I switch to the "New Google Sheets" ?
Apr
21
comment Looking for an “isFormula” formula for Google Spreadsheets
what would be the value that a custom function would get if you call it with isFormula(a1:a1)? and what about isFormula(a1:b2)?
Apr
20
comment Looking for an “isFormula” formula for Google Spreadsheets
Just to clarify - what you two are saying that I can not have a function that gets called like this: isFormula(a1)? and have it receive a range object? what about if i agree to call it with isFormula(a1:a1) can that work?
Jan
27
comment Looking for an “isFormula” formula for Google Spreadsheets
:) so you changed it so that instead of getting the address it now gets a column and row. is here no syntax such that the call would just be isFormula(a1) ? (in MS excel it would be a function that gets a range parameter)
Jan
24
comment Looking for an “isFormula” formula for Google Spreadsheets
I was wandering... Your function is actually getting a string which is the address of a cell isFormula2("A1"). so I tried to create a new version of it like this: function isFormula2(cell) { return (cell.getFormula())!=""; } and I expected it to be callable using isFormula2(A1) but this does not seem to work and when trying to debug it shows cell as undefined... any idea why is this and if things could be changed so it will work with f(A1) instead of f("A1") ?
Jan
24
awarded  Scholar
Jan
24
accepted Looking for an “isFormula” formula for Google Spreadsheets
Jan
23
asked Looking for an “isFormula” formula for Google Spreadsheets
Jan
13
awarded  Commentator
Feb
25
awarded  Autobiographer
Jan
9
awarded  Supporter
Jan
7
comment Google spreadsheets editing of a VLOOKUP formula that references a pivot table
And Yet another UPDATE: The same happens if you use =Indirect("B1") where B1 is inside a pivot table.
Jan
7
comment Google spreadsheets editing of a VLOOKUP formula that references a pivot table
I was finally able to replicate the issue on a test worksheet. The missing part was that this happens only when the array parameter of the VLOOKUP formula references columns of a pivot table. – epeleg just now
Jan
7
comment Google spreadsheets editing of a VLOOKUP formula that references a pivot table
I was finally able to replicate the issue on a test worksheet. The missing part was that this happens only when the array parameter of the VLOOKUP formula references columns of a pivot table.
Jan
7
awarded  Editor
Jan
7
revised Google spreadsheets editing of a VLOOKUP formula that references a pivot table
found that the issue is pivot table related and edited the Q to reflect it.
Jan
7
comment Google spreadsheets editing of a VLOOKUP formula that references a pivot table
As I already commented on the Q. I realize that this is not a general issue. but still it does happen to me. I will try to create an example that will demonstrate the issue.
Jan
6
comment Google spreadsheets editing of a VLOOKUP formula that references a pivot table
sorry, I can't data is sensitive. however it must be something with my specific worksheet as when I tried to create a sample one showing the same issue it just worked. maybe related to my having hebrew names to the sheets or the vlookup being across sheets, I will try to create a smaple.