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: trouble installing latest OpenOffice
Many WindoZE and Mac apps have a setting to keep a small part of the program running (so it can start up quickly (QuickStarter?) and installing a new version will hang unless the install program is programmed to search for and kill the running stub. Apparently OpenOffice does not do this )or at least consistently). On May 2, 2021 at 5:26:07 PM, Keith N. McKenna (keith.mcke...@comcast.net) wrote: All; This sounds more like that the QuickStarter is running. To check go to Tools->Options->Memory and at the bottom of the dialog window there is an entry Loan OpenOffice at System Startup. If the check box has a check mark in it then the QuickStarter is active and needs to be closed before trying to install a new version. Most newer systems do not need the QuickStarter running. If the box is checked, uncheck it and that will turn it off permanently. Regards, Keith N. McKenna On 2021-04-30 22:34, jd1008 wrote: > One of the problems I have always had with windows is that even when I > exit an application, the app does not not fully exit. For some reason, > it stays resident, but not visible. So I have always had to use other > apps to display all running apps, and kill the one that should have died > in the first place. > > > On 4/30/21 8:06 PM, David Belina wrote: >> Try shutting your Windows machine down and turned off, restart and >> before you do anything else, try to use the install. This should be >> the quickest way t stop the installer from starting twice. >> >> >> >> On April 30, 2021 at 8:01:09 PM, Lix Newton (wildfire...@shaw.ca) wrote: >> >> Hello Apache >> >> I have been trying to install the version 4.1.9 but everytime I run the >> installation wizard it gets stuck at the window where I have to indicate >> if I want to create a start link on the desktop - another window pops >> up, saying "Please exit OpenOffice 4.1.9 and the OpenOffice 4.1.9 >> Quickstarter before you continue. If you are using a multi-user system, >> also make sure that no other user has OpenOffice 4.1.9 open" and if I >> hit the OK button or close the window down, it aborts the installation. >> >> Help please, I need to print some OpenOffice files out today for a job I >> have to tomorrow. >> >> Many thanks >> >> Liz Newton >>
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 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
Android OpenOffice: the urgent need for a "go-back-one-step" - function/key
The CEO OpenOffice Dear Sir/Madam, I use Android OpenOffice daily, and continuously, on my Android tablet, and I need an additional function built into the software please. I explain: I have an 800 page "Text Document" which I edit for my personal use on a daily basis - and I have to move forth and back continuously. To move forward I use search& find, but then I have to go back every time to my previous position... and your software does not have that function. Could you please build it into your software. The absence of it is a real problem and I am sure that many users would appreciate such a function. If you need more information, please email me. Sincerely and with appreciation, Fanie Bekker Knysna - South Africa