Re: Excel equivalent
On 5/3/21 8:48 AM, Brian Barker wrote: Such users will also miss facilities present in the new product that they know nothing of. Here's an example. Suppose you want to concatenate the text in two adjacent spreadsheet cells into a single cell. In OpenOffice, you can merge the two cells - when OpenOffice will offer to combine the contents and even helpfully interpose a blank character - and then immediately unmerge them. The combined text ends up in the first cell. Of course you can achieve the same result in Microsoft Excel, but not (I believe) in the same way or indeed anywhere near as easily. I might add that this feature is not in Calc alone. Writer tables can also merge and split cells. I have used it to create forms with varying width blocks. I am not sure if msWord tables do this. Girvin - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Excel equivalent
At 14:41 03/05/2021 +0100, Robin Lord wrote: I don't agree open office calc is pretty much identical to excel, ... All spreadsheet programs are similar, of course: they simply have to be. Is that what you mean by "pretty much identical"? My point was not to suggest that OpenOffice (Calc) and Microsoft Excel were particularly different, but to say that approaching any new product expecting it to be identical to another was ill advised. I feel that users sometimes expect facilities in a new product to appear just as they did in their previous experience and then reject the new product as wanting as soon as they find this not to be so. (The current questioner's use of the term "equivalent" suggested that he might have been guilty of this.) Such users will also miss facilities present in the new product that they know nothing of. Here's an example. Suppose you want to concatenate the text in two adjacent spreadsheet cells into a single cell. In OpenOffice, you can merge the two cells - when OpenOffice will offer to combine the contents and even helpfully interpose a blank character - and then immediately unmerge them. The combined text ends up in the first cell. Of course you can achieve the same result in Microsoft Excel, but not (I believe) in the same way or indeed anywhere near as easily. ... before I retired the only major difference I found was the number of rows in excel was much bigger, ... You may have missed some of OpenOffice's advantages! Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Excel equivalent
I don't agree open office calc is pretty much identical to excel, before I retired the only major difference I found was the number of rows in excel was much bigger, and even that may have changed in the 10 years since, I never now need to have millions of rows in a spreadsheet. Even when I did have the need it was because people were using excel in ways that they should not have done. On Mon, 3 May 2021, at 14:34, Brian Barker wrote: > 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 > > -- Best Regards Robin - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Excel equivalent
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
Re: Excel equivalent
Hi Brian, a literal is a text. If you want to replace a number which is formatted as text by having a single quote as the first character then you can start the replace string with a single qoute ' to leave it as a literal. Alternatively you can format this number string as text (menu item format cell) In both cases search&replace replaces the string accordingly Kind regardsm Joost Am 03.05.2021 um 14:09 schrieb Brian Barnard: In your spreadsheet handler 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. As a result of this I have had to buy Office 2019 and uninstall Open Office - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Excel equivalent
In your spreadsheet handler 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. As a result of this I have had to buy Office 2019 and uninstall Open Office