Apache OpenOffice Calc ‘Find’ behaviour

LIke many people I use OpenOffice 3.4.1 for word processing and spreadsheets. It closely resembles the Leading Brand office software suite, yet is completely free!

Using Calc today, I noticed an unexpected behaviour in its Find and Replace feature. I wanted to search for the value ‘55.80’ which I knew was contained somewhere in my spreadsheet. However, it could not find it.

The reason for this is that although the cell apprears to contain ‘55.80’, when you highlight the cell the input line near the top of the screen shows ‘55.8’. Even if you enter ‘55.80’ in the cell, Calc drops the trailing zero.

Is this normal?