At 13:09 03/05/2021 +0100, Brian Barnard wrote:
Subject: Excel equivalent
It is a mistake to think that any software product is the equivalent of any other. OpenOffice's spreadsheet function ("Calc") is not offered as an equivalent of Microsoft Excel. It would be equally unhelpful to approach Microsoft Excel as an equivalent of OpenOffice.
In your spreadsheet handler ...
Er, it's OpenOffice's, not mine.
... I recently tried to edit a column of literals (all numeric) but your find and replace would not replace the characters that I entered with the new ones. In the same column were alphabetic literals and I could replace these with no problem.
I cannot reproduce this. If you are handling literals which happen to be entirely numeric, you should presumably take care to ensure that they are stored in Text and not Number format. This is a matter of knowing how to design a spreadsheet and how to enter and save values, not about the facilities available. But in any case, I see that Find & Replace will process individual digits even in numerical values, even toggling values between Number and Text format as necessary. So I do not see your difficulty and you may have to be clearer about exactly what doesn't work for you.
As a result of this I have had to buy Office 2019 and uninstall Open Office
Well, you are perfectly entitled to make such a decision - and you are welcome to do so. But this is surely not a result of your failure to solve your problem in OpenOffice. And if you are happy using Microsoft Office, I'm not sure what help you are requesting from the OpenOffice Users list. (And you don't have to remove OpenOffice in order to install and use Microsoft Office anyway.)
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
