1,388 reputation
42446
bio website
location Singapore
age
visits member for 3 years, 8 months
seen 19 hours ago

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
Nov
25
suggested approved edit on What are Google Sites Shared with me and where to view them?
Nov
24
comment Does Google Bookmarks show us how many total bookmarks we have?
This is a different thing. I'm talking about google.com/bookmarks while you are talking about the browser bookmarks.....
Nov
2
revised How to cancel Google Fusion Table importing data?
added 185 characters in body
Oct
31
comment Can I duplicate a folder in Google Drive?
-1, doesn't work.