Geeks With Blogs
Patrice Calve Life's short, have fun October 2005 Entries
Disable Date "Autocorrect" in MS Excel 2003


In MS Excel 2003 (and maybe others), when you enter a value that looks like a data (to Excel), it automatically converts it to a date.  Enter 4.2.1 and press enter, it will convert the data to a date format? 

Excel converts automatically my chapter numbers to a date format ! :(


Posted On Tuesday, October 11, 2005 10:35 AM

Need Help with 3 tier pattern
I have a recurring problem with Data Tiers. Most entities have two important properties: ID and DisplayName. The id for the link and DisplayName for the text to show. In a 2 tier, it's easy: select ID, DisplayName and get the values directly. Most 3-tier examples work 1 table at a time. While groovy, not usefull in a 2 table scenario. Table1: ID: unique identifier DisplayName: string Field1: string Field2: int Table 2: ID: unique identifier Table1ID: unique identifier DisplayName: string Field3: ......

Posted On Sunday, October 9, 2005 12:40 PM

Finally got the finally{} !
It took me a few years to get this Finally{}. try{ DoA(); //known to throw an exception}catch(Exception ex){ LogError(ex);}DoC(); Whether that DoC() is in a Finally or not, it would be called. So I never could understand the use of that finally. Yesterday, I had it ! I asked my great friend Michel Prevost. The finally{} exists to perform actions regardless of any “weird” actions in that catch{}. And by “weird” I mean a “throw” or a “return“. try{ DoA(); ......

Posted On Thursday, October 6, 2005 9:57 AM

Copyright © Patrice CalvĂ© | Powered by: