You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Brian Barnard <br...@gmail.com> on 2021/05/03 12:09:46 UTC

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

Re: Excel equivalent

Posted by Brian Barker <b....@btinternet.com.INVALID>.
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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Re: Excel equivalent

Posted by Girvin Herr <gh...@fastmail.com>.
On 5/3/21 8:48 AM, Brian Barker wrote:
<snip>
> 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

<snip>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Re: Excel equivalent

Posted by Robin Lord <ro...@fastmail.fm>.
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-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
> 
> 


-- 
Best Regards

Robin

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Re: Excel equivalent

Posted by Brian Barker <b....@btinternet.com.INVALID>.
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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org