Posts for 12/2008

31 December 2008 - 06:05

Photoshop CS4 removed contactsheet and other plugins

One of things on my todo list is the tryout of the new Adobe CS4 programs, especially Dreamweaver and Photoshop.

Trying out Photoshop first, I soon discovered that the Contactsheet plugin, amongst others, have been removed in the new version CS4. For some plugins I understand as there seems to be better functionality in the new version, but I couldn't find anything yet replacing the Contactsheet plugin. I know it's not ideal (the simple but great functionality on the matter in Paintshop Pro could be of inspiration), but I like it and so was really wondering immediately is there was a 'workaround'.

Yes of course, googling it didn't take long: you can download them here at the Adobe site.

And I found following installation instructions at The Luminous Landscape Forum.

  1. From the Photoshop CS4 install disc, drop the //#language#/Goodies/Optional Plug- Ins/Automate/ContactSheetII plug-in into the //Adobe Photoshop CS4/Plug-ins/Automate folder (this is for both Contact Sheet and Picture Package).
  2. From the Photoshop CS4 install disc, drop the //#language#/Goodies/Presets/Layouts folder into the //Adobe Photoshop CS4/Presets folder and restart Photoshop.
  3. Optional: To add this legacy functionality back into Bridge (as a menu item):
    From the Photoshop CS4 install disc, drop the //#language#/Goodies/Optional plugins/ Bridge Startup Scripts/photoshop_contact_sheet_ii folder and the photoshop_contact_sheet_ii.jsx file into following locations and then restart Bridge.
    • Macintosh: //Library/Application Support/Adobe/Startup Scripts CS4/Adobe Photoshop/
    • Windows XP: //Program Files/Common Files/Adobe/Startup Scripts CS4/Adobe Photoshop/
    • Windows Vista: //Program Files (x86)/Common Files/Adobe/Startup Scripts CS4/Adobe Photoshop/
(2) Comments ·
30 December 2008 - 06:50

Excel: Data validation, combo lists and autocompletion to search values quickly

Is it possible to type in the first letter in an Excel validation list to quickly go to some values within the list?
Another of those questions falling in between the lines of an Excel course.
The answer is : no. But of course even if the answer is right, it isn't satisfying really... or is it?

data validation [Read more on Excel: Data validation, combo lists and autocompletion to search values quickly...]
(2) Comments ·
29 December 2008 - 12:21

Accumulated subtotals in a filtered list or table in Excel

How to obtain cumulated subtotals in filtered data in Excel (be it in a list or table asper Excel 2007)?

cumulated subtotals in filtered data

It's not very difficult actually, but it seems to have a tweak ! This is how it works.

Create your list or table as usual first. Make sure you have a blank column to the right of your table to add your main formula. As you might already know we'll have to use the subtotal() formula here, as this is the only one considering filters and giving you correct results with filtered data. (Excel 2007 uses this by default in the creation of Tables by the way if you add the totals from the Table Data sub-ribbon).
If you want cumulative subtotals, just fix the first reference (make it absolute) and leave the second half relative as follows:

=SUBTOTAL(9;$F$3:F3)

Copy this through and you're basically done.

If you don't leave a blank column and/or don't make sure Excel does not include your subtotals column, there seems to be a problem in the results you'll get when filtering. You get one or more extra lines which do not match the filters. This might be linked to the fact that we're referring here to the cells in a rather unusual way...
Only disadvantage of this tweak is that if you use alternated row colouring (a new feature in tables from Excel 2007 onwards), you won't be able to get this formatting in the subtotals column. You could transform your subtotals column also in a table and format it in the same way, but this doesn't seem to be a solid solution either.

Don't hesitate to drop a line with your experiences on the matter or if you've got a better solution !

(0) Comments ·
28 December 2008 - 15:25

Double Clicking format painter in Office rocks … not always

The format painter is one of the most use features in Office programs and many people also use it by double clicking on it once the source has been set to enable multiple pasting of the formatting.

Recently a course participant expressed his frustration as this feature didn't work on his PC - and he seemed to have a friend wrestling with the same issue.
Not much more is needed to invite me on the investigation path.... and indeed not much to be found by googling it and in Microsoft knowledge base only some rare confirmations of a couple of people having had or having the same issue.

format painter problem

Looking a bit more careful to the cursor behavior, brought me to the inspirational thought: "and if it would be linked to the double speed of the mouse button ?"
And indeed, soon we found out that double click speed was set to maximum and that by reducing speed a bit, the format painter rocked again...

Well the wonders of refined technology - 'wah' and 'oh', but all so often 'grrrr' before the 'aha' brings back the 'omm' .... :-)
(1) Comments ·
26 December 2008 - 08:43

Text Conversion problem with Word 2007

Hadn't noticed this before with Word 2003, but when trying to open very old text documents (made with wordperfect 4.2 and 5) I got a funny "the selected text converter is an old version" error message.
I reinstalled the text converter... in vain. Downloaded Microsoft's text converter from their site... in vain. Searched the MS knowledgebase... you got it yes... in vain.

But what a wonderful place the internet is, as you always find one or another thread leading to a breakthrough.

This time my lucky one was this one.

The problem seems indeed that the older text converters don't seem to be updated when installing Word 2007 (or even 2003 as mentioned in the post).
The solution for me was:

  • Rename the current folder with older converter files at C:\Program Files\Common Files\Microsoft Shared\TextConv
  • Reinstall the text converters - this provided the updated dll and so indeed solved the issue
21 December 2008 - 12:45

Selectoracle : English (& Spanish) translations of CSS2 and CSS3 selectors

Css Select Oracle

I've bumped on this one today, through a CSS book: an online CSS selector dictionary, so to say.
From their intro:

Ever wondered what a particularly complex CSS selector really means? Here's your chance to find out! Simply enter one or more semi-colon separated selectors or rulesets into the following "Direct Input" area, or provide the URL of a stylesheet in the "URL Input" area. Best of all, the SelectORacle will flag potential errors and other problems, and it won't choke on any actual rules. You've always wanted to know what makes those line-noise posers tick-- now you can.

The link: http://gallery.theopalgroup.com/selectoracle/.

(0) Comments ·
18 December 2008 - 12:23

Excel Shortcut Keys

excel shortcuts

A question I regularly get asked during Excel courses is: where do I find some good Excel shortcut keys?
Well, on the net of course :-)

Just two links to get you going:

And if you're after a downloadable document with shortcuts:
http://officeblogs.net/excel/Charlie_Keyboard_Shortcut_Book.xls.

(2) Comments ·
16 December 2008 - 04:07

Windows Explorer crashes when selecting or previewing AVI files

If ever you run in this problem this is the solution:

Launch 'Regedit' from the Run command - Then navigate to following entrees:
  • HKEY_CLASSES_ROOT\*\shellex\ContextMenuHandlers\ : If there is a key in there with the name DivX in it, you can delete it.
  • HKEY_CLASSES_ROOT\SystemFileAssociations\.avi\shellex\ : If there is a key called PropertyHandler in there, delete the value (Default). Then it will appear as an empty value.

Finally close the registry editor and reboot the computer; .avi files should now not cause explorer to crash anymore.
You'll find more on simular topics at this source url: http://finalbuilds.edskes.net/faq.htm

(0) Comments ·
11 December 2008 - 09:57

Save embedded images from an Outlook 2007 message

"Why have it simple, if you can complicate it" - one often wonders...

If you've ever wondered why you just can't copy/paste embedded images from Outlook 2007 messages... well you're definitely not the only one.
I don't really know the exact reason - I sense the Word rendering engine now used by default might behind it, but I do found the solution to the problem here.

It works through a VB macro, which you need to embed into a module and trigger off by a button. Very like much a procedure to save all attachments at once, but this one saves the embedded images as well.
Watch out, this macro needs you to activate a special reference through the VB editor (Microsoft Shell controls and automation) and saves all attachments and embedded images at once in a directory you can choose.

If you want to use something more flexible you could try the Outlook plugin from EZ Detach

.
(2) Comments ·
Page 1 of 1 pages