21. January 2017

How to freeze 1st row and 1st column in Google Docs Spreadsheet

Freezing 1st column and top row in Google Docs Spreadsheet is little bit different than in Excel or Calc.

Click View, select Freeze from menu, click 1 row.

Click View, select Freeze, click 1 column.

Done ­čÖé

23. May 2015

Flask OAuthlib Multiple Scope Values for calling Google API

Google provides myriad of APIs for invoking operations on Google App Platform. It’s possible to integrate this calls with custom app using OAuth.

One option is to write app based on Flask (Python Microframework) with OAuth support provided by Flask-OAuthlib.

There is simple example of web app in Lepture’s repo.

The key practice in OAuth world is to get user’s consent to access API on her/his behalf. Often implemented by simple consent screen.

google-consent

You need to perform two steps to display consent screen:

  • enable API in Developer Console
  • define scope in your application

The second step is straightdorward:

google = oauth.remote_app(
    'google',
    ...
    request_token_params={
        'scope': 'https://www.googleapis.com/auth/userinfo.email'
    },
    ...
)

It works perfectly. The only problem is that this solution provides access just to one API.

The question is: How to request access to multiple scopes?

You can find many hints about OAtuh for other frameworks, that you should separate scopes by comma. That won’t work.

Correct solution is to use white space as delimiter of scopes (as suggested for HTML forms).

google = oauth.remote_app(
    'google',
    ...
    request_token_params={
        'scope': 'https://www.googleapis.com/auth/userinfo.email https://www.googleapis.com/auth/calendar.readonly https://www.googleapis.com/auth/tasks'
    },
    ...
)

14. May 2013

How to debug :hover pseudo class in Google Chrome Developer tool

Google Chrome developer tool is simply one of the best tools available for debugging of HTML5 applications.

It has one neat feature: possibility to inspect CSS of element and editing it on the fly.

That works fine for normal styles, but what about :hover state?

There is one “hidden” option which allows to switch element to :hover state.

Inspect element of HTML. You should see Styles on the right hand side. There are 3 icons. Click the middle one with arrow sign. It will pop up menu with checkboxes. You can select here CSS pseudo classes like :active, :focus, :hover or :visited.

google-chrome-dev-hover

To learn more about capabilities of Google Chrome developer tools I recommend to go through free course Discover Dev Tools from Codeschool.com.

20. October 2011

What is my IP?

Sometimes you need to know what is your current public IP.

How to determine it?

Yes, you can login via ssh to remote server and type who to see users and hosts.

There is much simpler way. Just google it ­čśë

Ask Google: What is my IP

Kudos to Lordrat for this simple useful tip.

1. July 2011

Google Gravity

Do you know what happens if you apply gravity constant on HTML elements?

No? Try to search for something by this enhanced Google Search page.

5. June 2011

Web based file uploader – uploading more than 100 MB

Klokantech.com provides new commercial version of web based File Uploader.

This uploader is able to upload more than 100 MB file.

Solution is combining HTML5 with Flash fallback for older browsers.

File Uploader is able to upload data to Amazon S3, Google App Engine or own infrastructure.

24. May 2011

WebGL: 3 Dreams of Black

Just grab Google Chrome or Firefox 4 and watch this nice video clip 3 Dreams of Black.

Wonderful piece of computer art. ­čÖé

You can find more info about technology behind the scene in following video:

 

21. May 2011

aDevCamp Prague – slides and links

Box2D Engine: Box2D, Lee Brimelow – GotoAndLearn()

Web: aDevCamp.cz

17. May 2011

Smooth workflow for mobile development

World of mobile devices is quite complex. Increasing number of operating systems and platforms is spliting market and making it harder to implement app that works across different devices.

Thankfully there are some good solutions. Flex development team made a huge step forward and  they prepared tools for whole workflow.

If you’re interested in mobile development take a look at this video from Edge newsletter.

I’ll show part of this workflow also this week in Prague at Android Dev Camp. So feel free to stop by. We can discuss many topics related to mobile and Flex/AIR. ­čśë

2. May 2011

21.5. 2011 – Prague – androidDevCamp

I was invited to give a talk about development based on Adobe AIR platform for Google Android. ­čÖé

This is my favorit topic. AIR platform has been here for several years and it is quite mature. It provides solid framework for large range of applications. AIR platform is good for developing small apps or even the big enterprise systems.

Flex/AIR framework is open source. Flash Builder IDE based on Eclipse is very useful tool for developers.

You can find more details about this event at aDevCamp.cz.

It’s great opportunity to meet people from Android community.

  • Where’s the fish?

  • Translations

  • Further info

  • Twitter

    Follow @jurajmichalek on twitter.

  • Comments

  • Tags

  • Topics