So your say that the currency symbol is the stopper in all this... what a limited program this is! I think you guys need to develop and extend your ASCII association table. Microsoft have an extended selection catering for pretty much 99% of all symbols and accented characters. In my eyes (And I will test tonight) this is a lack of thought from the programmer. Never heard of NetIQuette, is that a new programming language? is it in the English Dictionary so I might find out its meaning. Or is it a word in a foreign language? Date: Wed, 28 Jan 2015 07:22:16 +0100 From: max.merb...@gmx.de To: dev@openoffice.apache.org; myers_dar...@hotmail.com Subject: Re: Open Office lacking basic functions AGAIN!!
Darren, I've just tried the very thing and it worked. Maybe you simply mistyped your query. If it's what you wrote it's text, not a number. If it's a formatted figure, with a currency symbol, type the number in the query, without the currency symbol. And, by the way, you may want to remember the NetIQuette! ;) Max Am 27.01.2015 um 23:08 schrieb Darren Myers: So I have a spreadsheet... I have a cell in the spreadsheet... In this Cell there is a number .....£-83.04 I Click on Find and it can't find it... I look at the options (That you DONT need to do in EXCEL btw) and its full of unmeaning full complicated functions that don't make a bit of sense..."backwards" what on earth is that? Seriously guys, your product is rubbish btw I do the same search in Excel, finds it first time.... please can you give me the developer who wrote this rubbish as I wish to teach him how to program..