882 reputation
21023
bio website erraticdev.blogspot.com
location Slovenia
age 39
visits member for 3 years, 10 months
seen Jul 11 at 15:16

I'm an analyst web developer and development consultant on Microsoft technologies. My main focus is in Asp.net MVC, CSS3, HTML5, Javascript, jQuery, C#, and T-SQL. I'm a contractor by nature working around EU.


Dec
24
comment Google Spreadsheets conditional formatting based on another cell's content
Thanks for pointing this out. It really works exactly as I want it to.
Oct
9
comment How do I add new styles to Google docs?
Exactly why I came to this question. :) I just wanted to make a style called Code and Inline code that wouldn't be paragraph style.
Oct
8
comment Cell reference with colour formatting
@JacobJanTuinstra: So my many many is referring to those 85%. This proves that it does cover majority of formulas of Excel. :) And thanks for posting the link. Great insight.
Oct
8
comment Cell reference with colour formatting
I'd correct you if I definitelly knew hence my question. :) But otherwise. I suspect there's none anyway. So if you rewrite your script to be used as a cell formula I'll accept your answer because it would be best possible solution for the features at hand.
Oct
8
comment Cell reference with colour formatting
I didn't state it clearly in my question, but I was more looking toward existing formulas and not scripts. If there's no formula combination to make this work, then your script would be much better if it was used as a formula called i.e. fullCellRef(cellReference) so one could use it as =fullCellRef(A1) for instance
Oct
8
comment Cell reference with colour formatting
@JacobJanTuinstra: I was looking forward to some already present formula I could use. And since Google Spreadsheets covers many many formulas present in Excel I added it as tag as well. But otherwise I know this is about web apps. I've seen several questions tagged with Excel anyways, hence my tag. But thanks. Won't add it in the future.
Feb
18
comment Connectors (lines and arrows) in Google drawings
I used the polyline as it's still better than adding multiple unconnected lines/arrows. Too bas that <kbd>Shift</kbd> doesn't work with polylines as well.
Feb
13
comment Google Spreadsheets ISEMPTY() formula function
@JacobJanTuinstra: Include it where? Division by 0 is always error.
Feb
12
comment Google Spreadsheets ISEMPTY() formula function
I've already described the problem with isblank() function in my question. It only returns true when cell is actually empty (not having a formula in it either). What I was looking for no content cells if that makes it more clear to you.
Nov
7
comment Sorting data in Google Spreadsheet by cell entry
they want to see what other students' choices are - maybe that's a downside because people make their preference based on people instead of pure interest. But I understand the need of both.
Nov
6
comment Sorting data in Google Spreadsheet by cell entry
Why didn't you create a Google form for it? So everyone would just fill up a form and your resulting table would actually look like your end result. Unless you have particular limitations on number of people per project...
Oct
12
comment How do you change your Microsoft Live global account information, like primary email address?
@RyanHayes: SInce I have a similar problem but instead of using some obsolete school email I'm still using some obsolete previous company address... So just a question: which new email provider are you using that you changed it to? I'm using GMail and for some reason Microsoft account page always tells me that I should try later as if they're preventing me from using rival's email address... So which email did you change it to?
Oct
9
comment Is there a Google Street view to video conversion service?
@StevenRoose: ...or develop it myself. ;)
Oct
8
comment Is this email from Google Wallet spam, fraud, or legitimate?
The easiest way is to register a Google Wallet account. Any email afterwards will be a good indication whether anything's wrong and ringing your bells. :)
Mar
29
comment Securing and sharing a non-web file (ie. PDF) on Google Sites site
But having manual process in this isn't too scalable, is it? I would have to go and add new and new users... And the whole process seems to be too complicated for the end user.
Mar
14
comment Securing and sharing a non-web file (ie. PDF) on Google Sites site
@Zoredache: WHy don't you put your comment into an answer so I can accept it because I think this is as close as possible to what I want and what Google Apps Scripts along with Sites and Docs allow me to do.
Mar
14
comment Securing and sharing a non-web file (ie. PDF) on Google Sites site
@Zoredache: That's an interesting approach. I could always add an additional reader/viewer as long as number of readers/viewers is relatively big (in hundreds at least). FYI: I can see that this number is limited at 200. After you reach this number you can use mailing lists to share with even more...
Feb
23
comment Can I add an autoincrement field to a Google Spreadsheet based on a Google Form?
AFAIK timestamp is automatically added when you create a Form. When you'd look inside the spreadsheet columns, the first one is usually timestamp (unless you deleted it for some reason and I don't really know what happens if you do that)
Feb
23
comment Google Apps Scripts API for Google Docs Table
@benregn: I've updated my question and added an image to make it completely clear which tables I'm talking about. Not the ones, you mentioned in your comment. But those shown in above image.
Feb
19
comment Simple row references in Google Spreadsheets and resorting data
"Name" only exists in this simplified example. What I'm doing is writing user stories (as per agile paradigm). They start with user role, that repeats. I may give them another column ID, but how can I ensure that users will increment the ID since IDs get mixed because of row ordering... This is also outlined in my question... And even if I'd use countif... Can you explain a bit further where to place and use this function?