This article covers how to install VMWare on Gento Linux if you are getting errors like the "/etc/init.d/vmware: line 919: [: -: integer expression expected" error when trying to configure the VMWare options.
On an Android phone there is a notification ringtone which will be used by default for all notifications. The Gmail app allows you to specify a different notification ringtone which can be quite useful for having the default for SMS messages and something else for new emails, but the option is buried quite deep and I can never remember where it is, so this post will help to remind me in the future.
If you have a lot of files to upload to a website and the only access is via FTP then you can use a nice GUI tool to just drag and drop the directory, or you can use the command line ncftpput tool.
Google’s remarketing code inserts an iframe (with no content) directly below the opening <body> tag, which is 300x13px and can throw out a website’s layout. This post looks at how to effectively hide it with CSS in a couple of different ways that hopefully shouldn’t mess with its functionality at all.
Add this to your CSS and it will use absolute positioning, pushing it off the left side of page so it cannot be seen and doesn’t affect content flow:
iframe[name='google_conversion_frame'] {
position: absolute;
left: -1000px;
}
Another method is to set the height instead:
iframe[name='google_conversion_frame'] {
height: 0;
}
I’ve seen posts that suggest setting display: block as well, but just setting the height seems to work OK. If you find it’s not setting the hide in a particular browser, then try adding display block too.
This will work to hide the frame, but it’s probably not a good idea because it may mess with the functionality of the remarketing code. Obviously the above options may too, but something needs to be done to prevent it from pushing layouts out.
The HTML/CSS background position can be set using px, % and the constants top, center, bottom for vertical positioning and left, center, right for horizontal positioning. This post looks at the order they need to be in, and a "gotcha" that can catch you out when moving from constants to pixels.
Want to count rows and/or columns in a range with Excel no matter what content they contain? This post shows you how.
Use this formula, where you want the number of rows selected from e.g. A1 to A10
=ROWS(A1:A10)
This example will show 10 in the cell where the formula is.
Use this formula, where you want the number of columns selected from e.g. A1 to E1
=COLUMNS(A1:E1)
This example will show 5 in the cell where the formula is.
Note that the formulas will count the number of rows or columns, no matter what the selection. If we ran both rows() and columns() on the range A1 to E10, it would show 10 rows and 5 columns.
=ROWS(A1:E10)
ouputs 10
=COLUMNS(A1:E10)
outputs 5
Yes, selecting 5 cells from A to E is obviously 5 columns, but I personally manage a very basic ad booking system using a spreadsheet that is very very wide and I need to know numbers of days an ad is booked for. Using these functions makes it a lot easier, especially when it’s running across cells FB17 to GS17. No, it’s not the best ad booking system, but it works 🙂
And I’m sure you have your own reasons for needing to use these formulas, otherwise you wouldn’t have been looking for this post.