About
Patrick O'Beirne's blog, Risk Management, Data Quality, Testing, Spreadsheet check and control
Patrick O'Beirne
Report any problems to
Subscribe
Subscribe to a syndicated feed of my weblog,
brought to you by the wonders of RSS.
Flavours
There's more than one way to view this weblog; try these flavours on
for size.
Links
raelity bytes - the author of blosxom
__________
__________
Mon, 29 Oct 2007
Excel oddities
Some annoyances I came across in Excel and VBA:
- Maximum application.statusbar message length is 255 characters. Setting it to a string of 256 or more characters long gives error 1004.
- A Text formatted cell displays # characters to fill the cell (eg ##########) when the length of the text is between 256 and 1024 characters.
- Excel 2007 with European regional Windows date settings cannot import dBase dbf file dates correctly. Although the data is stored in the record unambigously as YYYYMMDD, Excel 12 imports it as mm/dd/yyyy so dates with days above 12 appear as text. It imports correctly when the regional date format is mm/dd/yyyy.
- Excel VBA once gave an error with a Double variable appearing as -1.#IND. In Microsoft C, that is an uninitialised variable, or Not a Number (NaN). I could not reproduce the error.