1,433 reputation
42448
bio website
location Singapore
age
visits member for 3 years, 11 months
seen Mar 20 at 8:04

Will only answer questions with incorrect, suboptimal, or missing answers. All my posts are necromancers, with 25% of them badged as such.


Quora link.


Mar
11
awarded  Popular Question
Mar
8
comment Will “Trash” in Google Docs be automatically deleted?
That's besides the point. The point is Can we count on items in "Trash" to be still recoverable after a few months/years?
Jan
8
awarded  Nice Question
Jan
8
accepted How do we set up notifications for documents shared to us in Google Docs?
Dec
21
comment How to save temporary variables in Google Spreadsheet formula?
@pnuts, A script solution would be a possible next-best-alternative. As long as the data does not appear in a cell it's a viable solution.
Dec
20
comment How to save temporary variables in Google Spreadsheet formula?
@pnuts, It doesn't matter where it's stored as long as it is not stored in the cells. Cells are meant for storing business data.
Dec
20
comment How to save temporary variables in Google Spreadsheet formula?
@pnuts, Hmm, variables are part and parcel of formulas. Hacking cells as temporary variables feel like a dirty solution because cells are meant for storing business data, not ram.
Dec
20
comment Google Spreadsheet: How to prevent cut and paste data changing references in formulas?
@Leonard, I meant the default behavior is different, so instead of $G$1&Sheet1!B3&Sheet1!A3&$G$2, we do G1&Sheet1!$B$3&Sheet1!$A$3&G2.
Dec
20
revised How can I stop Google Spreadsheet Now() function from auto updating?
added 62 characters in body
Dec
20
asked How can I stop Google Spreadsheet Now() function from auto updating?
Dec
20
asked How to save temporary variables in Google Spreadsheet formula?
Dec
20
comment Google Spreadsheet: How to prevent cut and paste data changing references in formulas?
@Leonard, Wow the syntax is horrible. It's much more intuitive if it's the other way round, i.e. relative cells use $ while absolute cells are default.
Dec
20
comment Google Spreadsheet: How to prevent cut and paste data changing references in formulas?
But you would have to repeat this for each cell.... Is there any way to do text copy through multiple cells?
Dec
20
comment Google Spreadsheet: How to prevent cut and paste data changing references in formulas?
Doesn't work, -1.
Dec
10
comment How to use full screen width in Google Docs
This is technically an upwards zoom webapps.stackexchange.com/a/70788/10579 so stuff like font shape, table borders, images, etc are pixelated and looks horrible.
Dec
10
answered How to use full screen width in Google Docs
Dec
9
awarded  Nice Question
Dec
6
awarded  Civic Duty
Dec
1
comment How to get “word count” of a book?
Hmm, it doesn't seem to work. For example, I tried itusing dp=0439139600 and dp=0470267585 but for both pages, the "text stats" doesn't appear.....
Nov
25
revised What are Google Sites Shared with me and where to view them?
added in-link