Tag Archives: 10.6 Snow Leopard

fixed : place a picture behind an Excel chart or graph

Posted on by
Reply

Question :

I am using Excel (from Microsoft Office) and I want to put the chart I’ve just made on top of a picture. How can I do that ?

Answer :

In Excel v14 (from MS Office 2011 for Mac), this can be done like this :

1- create the chart

2- select the chart area (you will see a bold, light blue frame around the entire chart area), then click the “Charts>Format”-tab (the purple tab in-between the green tabs), then in “Current Selection” click the “Format Selection”-button

3- in the window that opens select “Fill”, then the “Solid”-tab, and set the “Color:”-dial to “No Fill” and click “OK”

4- select the chart itself (inside the chart area – you will see a black lined square with light blue dots on the corners around the actual chart), then again, click “Charts>Format”-tab (the purple tab in-between the green tabs), and again, in “Current Selection” click the “Format Selection”-button

5- in the window that opens, again select “Fill”, then the “Solid”-tab, and set the “Color:”-dail to “No Fill” and click “OK”

6- then de-select the chart

7- in the upper Excel menu bar that’s fixed in the Finder, select the “Insert”-tab, and from the drop down menu that appears, select “Photo > Picture From File” and in the “Choose a Picture”-window that appears, select the image you need and click “OK”

8- the image will appear on top of your chart, now first resize it (by dragging the light blue corner-dots) and place it over your chart area

9- select the image (again, if it’s not already selected), click the “Format Picture”-tab and remove the background color(s) of the image if you need (using the “Remove Background”-option from “Adjust”)

10- then, also in the “Format Picture”-tab, select the “Reorder”-option from “Arrange”, and select “Send to Back” from the 4 options that appear in the pulldown menu ; your image will now be behind your chart

11- for fine-tuning, if needed, you can now resize or rearrange the image and the chart until the align exactly as you need them to

12- if you want the Excel-cell-grid behind your chart to disappear also, select the area of cells behind and around your chart and select WHITE (or any other color you need) from small triangle-shaped arrow just next to the “Fill Color”-button (the paint bucket icon)

That’s it !

Enjoy !

Donate Button (all)

fixed : I get a Track Following Error using Roxio Toast

Posted on by
Reply

Question :

Each time I’m trying to burn a DVD+/-R in Roxio Toast, the DVD won’t get burned and I get this error :

The drive reported an error:

Sense Key = HARDWARE ERROR

Sense Code = 0x09

TRACK FOLLOWING ERROR

I can read any DVD or CD on my Mac without a problem, but when I try to record a blank DVD (or CD), I keep getting this error…

…what can I do ?

Answer :

The solution to this Track Following Error is rather simple, even though I couldn’t find it available on the internet anywhere :

this just means your burning laser’s lens is dirty (even if your reading laser’s lens might be clean…)

so…

just get a cleaning DVD of the type that las a small soft brush on it (either with or without cleaner fluid), use it to clean your DVD burner (a.k.a. your SuperDrive) and when done, try burning with Toast again…

that’s it !

———————————————————————————————

some examples of the cleaning DVDs that you could use :

Hama CD/DVD Lens Cleaner

Allsop Ultra ProLens Cleaner

Hama DVD Laser Cleaning Disc

…but, you could also get one from you local electronics shop, just make sure on these :

– get the DVD-version, not the CD-only version

– get the version with the small brush on it ; no need to get one that also requires cleaning liquid, neither for multiple brushes, just make sure the brush is not too hard

– read the fine print on the product description, if it says “not for use in laptops”, it won’t mean that it will definitely not work, it just means it might not work (or even get stuck in) slot-loading SuperDrives like the ones in iMacs, MacBooks and MacBook Pros

– keep in mind that in this case, it’s not “more expensive = better product”, so get the cheapest one you feel comfortable with…

Donate Button (all)

fixed : this PDF will not print correctly

Posted on by
Reply

Question :

I’ve received an invoice from energy-provider Essent in PDF. In OSX’s Preview the PDF displays perfectly on-screen, but when printed, part of the text is messed up into unreadable text. I’ve called the Essent Help-desk and they told me that this is a Mac-problem that cannot be fixed…

…is that true and isn’t there any solution for this ?

Answer :

The Essent Helpdesk is wrong (I’m sorry…). The problem is that a non-standard font is used in the invoice for which a license of €500 is needed… (this actually is the FrescoSans font family…)

Even though Preview can’t properly print this font, Adobe Reader will…

So, download Adobe Reader (if you haven’t already done so) and open and print the invoice from there.

Simple as that !

Donate Button (all)

fixed : which fonts are used in this PDF I’ve received ?

Posted on by
Reply

Question :

I want to know what the exact fonts are that are used in a PDF-file someone has send me, but I can’t find a way to do that in OSX’s Preview and I do not have Adobe Acrobat Pro.

Is there any other way to get this info ?

Answer :

Yes !

Even though Preview currently has no solution for this and the Acrobat Pro is probably the easiest way of knowing which fonts are used in a PDF, there are a few alternatives :

Option 1

In Adobe Reader (the free, light version of Acrobat Pro), do exactly as you would in Acrobat Pro :

– open the PDF in Adobe Reader

– go to File –> Properties –> Fonts

that’s it

Option 2

Use the Terminal command-line :

– open the Terminal app

– type ” strings /path/to/document.pdf | grep FontName “, that is :

— type “strings” followed by a [SPACE]

— than drag & drop the PDF onto the cursor in the Terminal

— then typ another [SPACE], followed by a [VERTICAL DASH], another [SPACE] and “grep FrontName”

— then finish with a [RETURN]

that’s it !

Donate Button (all)

fixed : setup LogiLink WL0083 as WiFi-to-ethernet-bridge

Posted on by
Reply

Question :

I have a Philips BluRay player which has the option to connect to the internet (for things like YouTube and Picasa), which I think would be interesting to every once in a while.  The BluRay player has two options to connect to the internet, either using an ethernet network cable or using the special Philips WiFi-to-USB-dongle that is very expensive.

Problem is the BluRay player is next to my TV (and my AppleTV), but I do not have an ethernet cable connection there, only WiFi… (and my AppleTV cannot share it’s WiFi connection through it’s ethernet port…)

My first thought was to use an Apple AirPort Express and connect it to the BluRay player’s ethernet-port to use it as a WiFi/AirPort-client… but since I do not have an AirPort Express (yet), buying one would even be a more expensive option than buying the official Philips WiFi-to-USB-dongle…

On the other hand… I do happen to have a mini/portable WiFi-router (a LogiLink WL0083) lying around, which should be able to act as a WiFi-to-ethernet-bridge also…

But… even after several tries, I did not succeed in setting the WL0083 up properly…

Any idea how that should be done ?

Answer :

Yes !

Actually it’s rather simple, you just have to setup the LogiLink WL0083 as “Client+AP” and use the setup-wizard of the web-interface, but there are 3 things to know :

-1- the default IP-address of the LogiLink WL0083 is 192.168.2.1 so you need to be sure that the network you want it to connect to does not use the 192.168.2.0 to 192.168.2.255 range of IP-adresses (so you might have to reconfigure your ‘entire’ network to use the 192.168.3.1 to 192.168.3.255 range…)

-2- to make it a “Client only” instead of a “Client+AP”, you should set SSID broadcast to “Hidden” and leave the additional (extender) SSID in default “Logilink” and “Disabled”

-3- and… when finishing up, do not forget to change the IP-address of your Mac’s WiFi and ethernet connection back to “DHCP”

in a step-by-step guide, that would be :

– make sure your WiFi network is not using the 192.168.2.0 to 192.168.2.255 range of IP-adresses (if it does, reconfigure your network router to use another range of IP addresses, and reconfigure all clients in your network that use Static IP addresses)

– then unplug your ethernet cable from your regular network

– disconnect from your regular WiFi/AirPort-network

– connect the LogiLink WL0083 to your Mac using an ethernet cable, and connect it’s USB-cable to a powered USB-port (e.g. on your Mac)

– then press the small “WPS/Reset”-button on the WL0083 for about 5 seconds (to reset it)

– then, on your Mac, go to Apple Menu (Apple icon top-left on the screen) –> System Preferences –> Network –> Ethernet and change it to “Using DHCP with manual address” and type the IP-address 192.168.2.100 in the input field

– then open Safari and type 192.168.2.1 into the URL-field ; for User Name and Password type “admin” (both the same)

– now the LogiLink web interface should open

– click on the “Client+AP” tab, then “Setup Wizard” on the left, followed by “Next” on the left

– on the next screen, start by clicking on the “Scan”-button, and wait for the list of SSIDs of local WiFi/AirPort-networks to appear

– then select your WiFi/AirPort-network from the list

– everything will then be automatically filled out, apart from “Pass Phrase:”, there you should type your WiFi/AirPort-password

– then click “Next”

– in the “Wireless Basic Settings”-screen that opens, set “Network Mode” to “11b/g/n mixed mode”, leave “SSID” as it is (probably “Logilink”), set “Broadcast SSID” to “Disable” and leave the rest as it is automatically set

– then click “Next”

– in the “Wireless Security Settings”-screen that opens, set “Security Mode” to “Disable”, and leave the rest as it is

– then click “Next”

– in the next screen click “Apply” and the WL0083 will reboot

– then, on your Mac, make sure that you are NOT connected to a WiFi/AirPort-network

– then go to Apple Menu –> System Preferences –> Network –> Ethernet and change it to “Using DHCP”

– then, in Safari, manually type the URL of any existing website that you do not often visit (e.g. the website of the city you live in) and see if it loads, to check if the WL0083 is properly configured as a WiFi-client on your network

– then disconnect the LogiLink WL0083’s ethernet and USB cable from your Mac

– so, go over to your BluRay player, and connect the LogiLink WL0083’s ethernet cable to it and connect the USB cable to a powered USB-port (or USB-poweradapter)

– now try and see if your BluRay player can use it’s internet services

– if your BluRay player needs any additional configuration, just set it to “ethernet” and “DHCP”

Enjoy !

Donate Button (MacManusNL)

Note #1 : the LogiLink WL0083 supports WiFi-N only at 150Mbps speed, even though the normal maximum speed of WiFi-N is 300Mbps (just like Apple’s implementation of WiFi-N in AirPort), most of the time you will probably not notice any decline in quality, but you might if you’re a heavy user…

Note #2 : if you want to adjust something small on your LogiLink WL0083 after you’ve configured it, you just need to temporarily switch your ethernet-connection from “Using DHCP” to “Using DHCP with manual address” and 192.168.2.100 as the actual IP-address ; then you can login to the LogiLink web-interface at the 192.168.2.1 URL (and do not forget to change back to “Using DHCP” afterwards)

fixed : what’s the location of Apple’s official Mac icons in OSX ?

Posted on by
Reply

Question :

I want to change the icon of my hard drive into an icon-sized picture of my Mac.

How do I do that ?

Answer :

For (nearly) every model of Mac, iPhone, iPad & iPod, the ‘official’ icon is already included inside OSX. If you want to use it, e.g. as an icon for a hard drive or folder, or as a profile pic on a website (a.k.a. an Avatar), you just have to did a little inside OSX…

– in the Finder, select “Go” in the top Menu-bar, and select “Go to folder” from the pulldown-list

– in the screen that opens, paste the following line :

/System/Library/CoreServices/CoreTypes.bundle/Contents/Resources

– now the folder that holds all Apple’s hardware icons and system icons will open

Note : be sure not to mess things up in this folder ! do not delete anything ! deleting or messing up could mean you will have to reinstall OSX !

– in this folder the hardware icon of (nearly) any Mac can be found, the names start with “com.apple.”

– find the Mac-icon you’re looking for, some examples :

aluminium iMac 27″ = com.apple.imac-unibody-27

black MacBook 13″ = com.apple.macbook-black

MacBook Air 11″ (2010 and newer) = com.apple.macbookair-11-unibody

MacBook Pro 13″ (with DVD-burner) = com.apple.macbookpro-13-unibody

– then right-click (CTRL-click) on it and select “Copy” from the popup-menu

– then close the folder (to avoid messing things up, keep this folder open no longer than strictly needed)

– then return to your Desktop (in the Finder) and right-click (CTRL-click) anywhere there

– then choose “Paste” from the popup-menu, and on your Desktop a .ICNS-file with the selected Mac as it’s icon will appear

– then, on the Desktop, right-click (CTRL-click) the icon of your hard drive (normally a generic hard drive icon named “Macintosh HD”) and select “Get Info” from the popup-menu

– then in the “Get Info”-window that opens, select the icon so it will get a blue (selection) glow around it

– then drag&drop the .ICNS-file from your Desktop onto the icon in the “Get Info”-window

that’s it !

Donate Button (MacManusNL)

Note #1 :

if you would also like to give your generically named Macintosh HD a different name, go to the chapter “Name & Extension:” in the “Get Info”-window ; if the small triangle icon in front of it is pointing to the right, click on it to let it point down and the chapter will expand to reveal an entry box where you can type the name you want to give to your hard drive

Note #2 :

if you do not see your hard drive on your Desktop, go to “Finder” in the top Menu-bar and select “Preferences…” from the pulldown-menu ; in the “Finder Preferences”-window that opens, click on the “General”-tab/icon and put a checkmark at “Hard disks”