3,008 reputation
513
bio website Blogger-hints-and-tips.blogsp…
location Ireland
age
visits member for 4 years
seen 9 hours ago

1d
comment I made an error and need to change a primary gmail address
What product is this in?
Jul
24
comment How to contour data from a Google Spreadsheet?
Why is using a GIS not allowed? Is this a school assignment that you're asking us to help you with?
Jul
22
comment How can I make Google Sheets tell me how many of each date are in a column?
Just put it in as many rows as you might realistically every have.
Jul
22
comment How can I make Google Sheets tell me how many of each date are in a column?
You need to put the formula in as many rows as you think may realistically by used. Up to 65,536 if you expect that much data - but if you do, you really should be building a solution in a robust database that's scaled for the problem at hand, not using a spreadsheet!
Jul
22
comment Someone's Google account under my domain, how to ask for removal?
If someone wants to lie to other people and mailing list, and say that their email address is theirName@yourDomain.com then there is nothing you can do in the on-line world to stop them. Maybe you could get a court order for harassment (or something) - but only if you can track down who the person is in real life. Good luck with that.
Jul
9
comment Freeze first row of Google spreadsheet when displayed in Google site
How exactly have you displayed the Sheets file in your Site?
Jul
7
comment primary gmail address
You need to tell us more about how "Google made me create a new email address".
Jul
4
comment Can I choose what blog posts will be displayed in the front page with Blogger?
Apologies, now fixed.
Jul
1
comment Preserve Transparent PNG Images on Blogger
Ahh, that raises another thing to check: In blogger, if you have a designer template, go in to Template > customize > images, and check if there's a background. if there is, change it to transparent.
Jun
25
comment Can I use Picasa (or any other desktop client) to manage Picasaweb or Google+ albums?
I'm not being funny - but why do you want to use a desktop app, not a web-app, to manage photos that are stored on-line? What's wrong with just using teh web-app?
Jun
25
comment Recover Picasa people/face data
Did you upload the photos to Picasa-web-albums (or any other host) after you added the tagging? Or did you do it before?
Jun
19
comment Can I duplicate a private blog - to then slightly change the duplicate while keeping the “original”
Do you want to duplicate the contents (ie posts) or the structure and look (the template)?
Jun
16
comment How do you automatically align incoming form responses in Google Sheets?
Is that an old Google Sheets file or a new one? It definitely worked with the first column of an old one when I tested it earlier.
Jun
12
comment Preventing Paste Overwriting Cell Formatting in Google Sheets
With a spreadsheet, what is to stop the person making the booking from simply over-typing someone else's name? How do you keep a record of how many people change their minds, which can be used to predict likely cancellation rates and thus overbooking tolerances. Etc. Seriously - if you're looking for this kind of functionality, you need a proper application, not just a spreadsheet.
Jun
12
comment Preventing Paste Overwriting Cell Formatting in Google Sheets
If you're not a fan of the Socratic method (which I actually find to be quite helpful when the answer involves re-framing the approach), then feel free to edit ...
Jun
9
comment Are tumblr themes updatable by author once used on a live site
That doesn't matter: Tumblr still need the theme to work within their software, so may need to modify it as they make changes.
Jun
9
comment Google spreadsheets showing “shared with xxx” count greater than actual?
A bug which was introduced by Google and then removed quickly? Is it still happening for you ? Is there anything special about the three people you've shared with?
Jun
7
comment Rename Column in Google Spreadsheets
In that case, you should use the approach used in the article you have linked to, along with the View > Freeze Rows > Freeze 1 Row option
Jun
3
comment How can I prevent users from reverting to an old version of a Google Spreadsheet?
I built applications with spreadsheets back in the mid 1990s. These days, I know better :-)
May
30
comment How can I prevent users from reverting to an old version of a Google Spreadsheet?
I'm not even sure that enhancements like that would be a good idea. fundamentally this is a spreadsheet (free-format calculations canvas), trying to do the job of a multi-user application with a database backend (structured calculation processor). The mismatch between the basics is too great for a spreadsheet to realistically provide a good solution, IMHO.