Some notes on software development... RSS 2.0
# Tuesday, 15 April 2008

To get the rightmost value in a range you can use the Lookup function:


The 1st parameter is the value to lookup in the range. However if the value cannot be found the lookup function will return the highest value in the range by default.
So setting the 1st parameter to 1E+100 basically sets the lookup value to be a huge numeric value, 1 + 100 zeros. If you know what your max value will be you can change this to be max value + 1.

Microsoft Discussion Groups - Microsoft.Public.Excel.Misc

Tuesday, 15 April 2008 08:07:19 (GMT Standard Time, UTC+00:00)  #    -
# Tuesday, 08 April 2008

To put a new line inside an Microsoft Excel cell you can use ALT+ENTER.
Handy for keeping text neat :)

Tuesday, 08 April 2008 11:37:05 (GMT Standard Time, UTC+00:00)  #    -
# Wednesday, 02 April 2008

If you have a char array that contains the string you want but is padded out with null terminators e.g. '\0' you can use the String.TrimEnd method to get the exact string you need.

A 12 element char array contains the following chars: M y S t r i n g \0 \0 \0 \0

To convert to a string you can use the String constructor to pass in a Char[] type. Unfortunately a .NET string can happily contain null characters so your resulting string would be MyString\0\0\0\0
Using the TrimEnd('\0') will return the correctly terminated string.


Note: Outputting a string containing null characters to other classes like form controls may automatically terminate the strings correctly at the first null character but behind the scenes the string still contains the null characters.

MSDN String.TrimEnd Method
Strings In .NET and C# (Jon Skeet)

Wednesday, 02 April 2008 09:46:35 (GMT Standard Time, UTC+00:00)  #    -
# Wednesday, 26 March 2008

The excellent Paint.NET application does not support .ico files out of the box.
So, to save .ico files you need to install a plug-in from Evan's Web Site.

Extract the IcoCur.dll to the FileTypes folder in the Paint.NET directory, for a default install it is C:\Program Files\Paint.NET\FileTypes

When you do a 'save as' your will now have .ico and .cur file extensions in the type list:


Wednesday, 26 March 2008 11:45:08 (GMT Standard Time, UTC+00:00)  #    -

Sign In
Total Posts: 116
This Year: 0
This Month: 0
This Week: 0
Comments: 36
About the author/Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2019
Hadrian Phillips

All Content © 2019, Hadrian Phillips
DasBlog theme 'Business' created by Christoph De Baene (delarou)