David Huby’s Blog Technical and business stuff

27Mar/090

OpenOffice Calc, numbers blue and formulae green!?

With so many shortcuts come many opportunities to execute a command unintentionally. At some stage in the last few days I hit Ctrl+F8 in OpenOffice's Calc application, and all the numbers on my spreadsheet turned blue, and all formulae turned green. I was wondering what had happened for a while, I hope this post saves someone time.

You can turn off the feature by pressing Ctrl+F8 or clicking on "Value Highlighting" in the View menu.

Filed under: Uncategorized No Comments
25Mar/090

Windows Powershell recursing, regular expressions, and sorting

On a project I'm currently working on, I was looking for unused JavaScript files in the scripts/ subdirectory. The easiest way to do this was by checking for references to these files in all other files in the project.

PS E:\projects\source\tickets\trunk> Get-ChildItem Website\* -recurse | Select-String -pattern "scripts\/.+js" |% { [regex]::Replace($_, ".*(scripts/.+js).*", "`$1" ); } | sort -unique

Tagged as: No Comments
15Mar/090

Wireframes considered harmful … under some circumstances

Web Standards Group Sydney presentation: On the 11th of March 2009 Tom Voirol spoke about an alternative development process for websites.

Tom said wireframes are harmful. But he didn't really mean it. What he was trying to say was that you shouldn't present the customer with wireframes and expect them to understand them in the same way we do as designers and developers. Customers don't speak the language of wireframes.

Tom suggested that we should create high fidelity prototypes to present to our customers.

Slides

15Mar/091

Raphael Vector graphics in Javascript

Web Standards Group Sydney presentation: On the 11th of March 2009 Dmitry Baranovskiy presented Raphael, a vector graphics library for JavaScript.

  • supports Firefox 3.0+, Safari 3.0+, Opera 9.5+ (via SVG)
  • supports Internet Explorer 6.0+ (via VML)
  • works in Chrome but it is quite buggy
  • Website
  • Twitter
Tagged as: , 1 Comment
1Mar/090

Apache displaying PHP source – update httpd.conf

If Apache is displaying the source of your PHP files, try adding something similar to your MIME module in httpd.conf:

Note - this refers to PHP5 & Apache 2.2. Ensure you are using the correct binary (php5apache2_2.dll) for your php / apache combination.

LoadModule php5_module "C:\Program Files (x86)\Apache Software Foundation\Apache2.2\bin\php5apache2_2.dll"

AddType application/x-httpd-php-source .phps

AddType application/x-httpd-php .php .php5 .php4 .php3 .phtml .phpt
Filed under: Sysadmin No Comments