[ PROPOSAL ] A new REVERSE string function for Spreadsheets

[Ross Murray]

I hope my suggestion reaches its intended target, and meets your
community's standards for submission of additional functions.

I would like to see a REVERSE function, which returns a new string with
characters in reverse order to the target string.

I am attempting to remove duplicates after merging many files to create a
very large list of names. Names may or may not have middle names; and/or
initials which may or may not be follows by full stops. I would like to
extract the last names and use those the primary sort key. While feasible
with existing functions, it would seem easiest to - REVERSE the full names;
FIND the first space; RIGHT to extract the last names; and REVERSE those to
their original form.

It seems like a simple new tool that the imaginations of users could create
more effective ways to complete many different objectives.

... From a devoted and appreciative user,

Ross Murray.

Re: Global oder Public

[technik]

Danke.

Dann kann man damit praktisch auch Daten an andere Makros in anderen 
Programmen übergeben, ob man will oder nicht.


Horst

Am 13.01.2016 um 14:20 schrieb RA Stehmann:

On 13.01.2016 13:11, technik wrote:

Hallo,

was ist eigentlich der Unterschied zwischen globalen und public Variablen?
Soweit ich das sehen machen sie genau das selbe.


Im Zweifelsfalle ja, aber der Scope ist trotzdem unterschiedlich.

Disclaimer: Es gibt Menschen, die sagen, mit public und erst recht mit
globalen Variablen solle man möglichst sparsam umgehen.

Public Variablen stehen allen Modulen in der Bibliothek zur Verfügung.

Bei globalen Variablen gilt das gleiche. Es bleiben ihre Werte aber auch
dann noch erhalten, wenn die Ausführung des verknüpften Makros beendet
wurde (AFAIK, solange Apache OpenOffice noch läuft.).

Gruß
Michael

P.S.: Spielen ist ein ausgezeichneter die Welt zu erkunden und die
Neugier zu befriedigen. Spielen kann man auch mit Makros.




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

Re: Global oder Public

[technik]

Hallo,

danke, dauerte etwas bis ich merkte, was das wie macht.

Horst

Am 13.01.2016 um 14:02 schrieb Wolfgang Jäth:

Am 13.01.2016 um 13:11 schrieb technik:

was ist eigentlich der Unterschied zwischen globalen und public Variablen?

In welchem Zusammenhang? Ich vermute mal, Du meinst in OO-Basic.


Soweit ich das sehen machen sie genau das selbe.

Nein; leg einfach mal 2 Module an (Extras => Makros => Verwalten =>
Basic => Verwalten => Neu => ...) mit folgenden Inhalten:

Module1:

   Dim A As Integer
   Global B As Integer

   Sub Main
 Flip
 Flop
   End Sub

   Sub Flip
A = A + 1
B = B + 1
   End Sub


Module2:

   Sub Main
 Flop
   End Sub

   Sub Flop
 A = A - 1
 B = B - 1
   End Sub

Dann fügst Du unten ins Beobachtungsfenster noch die beiden Variablen A
und B ein. Anschließend führst Du /zuerst/ das 'Main' aus Module2 aus
(F5), und /dann/ debugst(F8) Du das 'Main' aus Module1 (unten am
Fensterrand kannst Du zwischen den Modulen wechseln). Achte mal dabei
genau auf die Start-Werte der beiden Variablen.

Wolfgang



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

Donate Link

[Bart Bowers]

OpenOffice,

I have been using AOo for a few years and just donated $50 in Bitcoin.

The link to donate was hard to find. I think you should put the link on the
top main menu, just to the right of "Download"

Thank you for all of your hard work.

Regards,

Bart Bowers
bart.bow...@gmail.com
Las Vegas, NV, USA

RE: Problem opening files

[Dennis E. Hamilton]

> -Original Message-
> From: Danny Wilcox [mailto:dwilcox...@btinternet.com]
> Sent: Friday, January 15, 2016 03:16
> To: users@openoffice.apache.org
> Subject: Problem opening files
[ ... ]
> If a “repair” to the Open Office installation is attempted via Windows
> Control Panel “Programs and Features” the Error message “Fatal Error in
> Installation Files” is given. 
[orcmid] 

Do you keep the folder that the setup files are extracted into (by default to 
the desktop)?

Open Office has been downloaded and
> installed a number of times, each time deleting as many of the previous
> files as could be found[orcmid] .
[orcmid] 

Um, what does this mean?  It is not necessary to uninstall a previous version 
to install a new version.  But if you did, did you use the uninstall via the 
Control Panel and nothing else?  Direct removal of files is not advisable.


> 
> The previous version 4.1.1 of Open Office operated without any problems
> and no alterations have been made to the PC.
> 
> 
> Please could any replies take into account that I am a user with limited
> PC OS knowledge.
> 
> 
> Thank you,
> 
> 
> D.M. Wilcox (Mr)
> 
> 
> 
> 
> 
> 
> 



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

RE: Lotus Word Pro

[Dennis E. Hamilton]

There is no support for Lotus Word Pro documents in Apache OpenOffice 4.1.2.

> -Original Message-
> From: Piers Weston [mailto:piersw...@sky.com]
> Sent: Friday, January 15, 2016 07:10
> To: users@openoffice.apache.org
> Subject: Lotus Word Pro
> 
> Hi, I have just downloaded the update but I can find no way to read
> Lotus Word Pro documents which is strange as I note you have included a
> facility to read Lotus 123 Spread Sheet sheets.
> Can you help with this issue please.
> 
> My Email  piersw...@sky.com
> 
> Regards – Piers Weston.


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

Lotus Word Pro

[Piers Weston]

Hi, I have just downloaded the update but I can find no way to read Lotus Word 
Pro documents which is strange as I note you have included a facility to read 
Lotus 123 Spread Sheet sheets.
Can you help with this issue please.

My Email  piersw...@sky.com 

Regards – Piers Weston. 

Re: [ PROPOSAL ] A new REVERSE string function for Spreadsheets

[Maurice Howe]

Oh, that's easy.  The facility already exists -- No need to "add" a
feature.  I often have lists of names that need sorting is various ways.
TABLES are the answer.  It may be cumbersome to make a table from a list,
but it really pays off for applications like yours.  Table elements are
usually separated with tabs but spaces work, as well.  And it's easy to
convert a table to text when that's appropriate.  Play around -- you'll
find a way that fits your need.

Maurice Howe


On Fri, Jan 15, 2016 at 11:49 AM, Ross Murray 
wrote:

> I hope my suggestion reaches its intended target, and meets your
> community's standards for submission of additional functions.
>
> I would like to see a REVERSE function, which returns a new string with
> characters in reverse order to the target string.
>
> I am attempting to remove duplicates after merging many files to create a
> very large list of names. Names may or may not have middle names; and/or
> initials which may or may not be follows by full stops. I would like to
> extract the last names and use those the primary sort key. While feasible
> with existing functions, it would seem easiest to - REVERSE the full names;
> FIND the first space; RIGHT to extract the last names; and REVERSE those to
> their original form.
>
> It seems like a simple new tool that the imaginations of users could create
> more effective ways to complete many different objectives.
>
> ... From a devoted and appreciative user,
>
> Ross Murray.
>

Re: Lotus Word Pro

[M Henri Day]

2016-01-15 20:39 GMT+01:00 Dennis E. Hamilton :

> There is no support for Lotus Word Pro documents in Apache OpenOffice
> 4.1.2.
>
> > -Original Message-
> > From: Piers Weston [mailto:piersw...@sky.com]
> > Sent: Friday, January 15, 2016 07:10
> > To: users@openoffice.apache.org
> > Subject: Lotus Word Pro
> >
> > Hi, I have just downloaded the update but I can find no way to read
> > Lotus Word Pro documents which is strange as I note you have included a
> > facility to read Lotus 123 Spread Sheet sheets.
> > Can you help with this issue please.
> >
> > My Email  piersw...@sky.com
> >
> > Regards – Piers Weston.
>

​It would seem, however, that they can be opened and read in LibreOffice :
https://ask.libreoffice.org/en/question/5192/can-libreoffice-open-lotus-wordpro-lwp-files/


Henri​

Windows 11

[Richard Beeston]

Dear all

Does anyone know if Open Office is compatible with Windows 11.

Thanks

Re: Windows 11

[Fernando Cassia]

There is no such thing as "Windows 11" AFAIK.

FC

On Fri, Jan 15, 2016 at 3:34 PM, Richard Beeston 
wrote:

> Dear all
>
> Does anyone know if Open Office is compatible with Windows 11.
>
> Thanks




-- 
During times of Universal Deceit, telling the truth becomes a revolutionary
act
Durante épocas de Engaño Universal, decir la verdad se convierte en un Acto
Revolucionario
- George Orwell

Re: Windows 11

[Richard Beeston]

Hi Jim

Sorry to inform you but Windows 11 was launched the day before yesterday and 
is in stores now.


Regards Richard

-Original Message- 
From: Jim McLaughlin

Sent: Saturday, January 16, 2016 7:55 AM
To: users@openoffice.apache.org ; ar2l...@bigpond.com
Subject: Re: Windows 11

There is, as yet, no Windows 11.  If your question was meant to refer to
Windows 10, which does exist, AOO is reportedin many posts on this list,
be compatabl with Windows 10.   I have not, yet, personally used AOO 4.1.2
with Win 10.

On Fri, Jan 15, 2016 at 12:34 PM, Richard Beeston 
wrote:


Dear all

Does anyone know if Open Office is compatible with Windows 11.

Thanks 



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

RE: Change all margins together in OO Writer.

[Dennis E. Hamilton]

It is useful to keep in mind that Bugzilla issue #126789 is where this 
enhancement has been requested,
.

When discussing this on the users@ list please also ensure that useful 
discussions are reflected there or are linked from there (although linking into 
posts on the lists is trickier).  Also, note that discussion on the dev@ list 
is the usual place where technical aspects are addressed, if needed.

Also, if there is discussion on the Community Forums, these should be tied 
together also.

The easiest way is to have list discussions and forum discussions also point to 
the Bugzilla issue.  It is also easy to cross-link from Bugzilla issue to a 
forum thread.

It is important not to fragment this conversation in a way where it reaches a 
conclusion among the participants but is not anywhere that management of the 
issue is carried and there is nothing where developers and the project 
management committee track requests.

 - Dennis

PS: I grant you that the Bugzilla is not the most user-friendly arrangement.  
Regardless, it is where the developers and testers and users work to identify 
issues and look for resolutions.

PPS: It would be great if the super-user folk who invest time on these lists 
would take on ensuring there is cross-connection of issues among the places 
where they are discussed.  I understand that there are preferences about where 
folks prefer to discuss.  The question is whether or not it is done in a way 
where it is kept in the attention of the project.  These days, as imperfect as 
it is, the Bugzilla is the place.

> -Original Message-
> From: Brian Barker [mailto:b.m.bar...@btinternet.com]
> Sent: Friday, January 15, 2016 00:07
> To: users@openoffice.apache.org
> Cc: Malcolm Gregson 
> Subject: Re: Change all margins together in OO Writer.
> 
> At 18:25 13/01/2016 +, Malcolm Gregson wrote:
> >I do not use page styles, and would probably forget to use them if I
> >had them! Perhaps I should!
> 
> Actually, you do use page styles. Unlike the character and paragraph
> cases, where you have the choice of local or style formatting, page
> formatting is available only in styles. If you change the margins of
> a document, you are changing the page style used by the document or
> the relevant part of it.
> 
> Should you understand and use styles? Definitely!
> 
> >I frequently want to change the margins of documents that have come
> >from other people, before sending them out again to largish groups -
> >perhaps 50 people, particularly to save printer paper by decreasing
> >the margins so that more text fits on a page, thus reducing the
> >number of pages printed.
> 
> Two possible schemes:
> 
> o Create a template with your preferred margins. Each time you need
> to effect this solution, open a new document from this template,
> select all the content of the original document, and copy and paste
> it into your new document with its preferred margins.
> 
> o In some document (it could be otherwise empty), create a new page
> style (with your own choice of new name for it) with the required
> margins. Save this document. When you receive your original document,
> go to the Styles and Formatting window in the original document and
> use New Style from Selection | Load Styles... (tick Pages) | From
> File... to browse to your document and import its styles - including
> your new page style. Apply this style to your original document.
> 
> But all this does not deny the validity of your request. What you are
> asking for is a Synchronise tick box at Format | Page... | Page |
> Margins, just as is already available in various other places:
> o Format | Page... | Borders | Spacing to contents
> o Table | Table Properties... | Borders | Spacing to contents
> o Format | Frame/Object... | Borders | Spacing to contents
> 
> 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


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

Re: Windows 11

[Maurice Howe]

No, there isn't.
See:
http://www.techradar.com/us/news/software/operating-systems/microsoft-confirms-there-will-be-no-windows-11-1293309

There is an Internet Explorer 11.  Could you have confused the non-existant
W-11 with IE-11?

On Fri, Jan 15, 2016 at 4:09 PM, Richard Beeston 
wrote:

> Hi Jim
>
> Sorry to inform you but Windows 11 was launched the day before yesterday
> and is in stores now.
>
> Regards Richard
>
> -Original Message- From: Jim McLaughlin
> Sent: Saturday, January 16, 2016 7:55 AM
> To: users@openoffice.apache.org ; ar2l...@bigpond.com
> Subject: Re: Windows 11
>
> There is, as yet, no Windows 11.  If your question was meant to refer to
> Windows 10, which does exist, AOO is reportedin many posts on this list,
> be compatabl with Windows 10.   I have not, yet, personally used AOO 4.1.2
> with Win 10.
>
> On Fri, Jan 15, 2016 at 12:34 PM, Richard Beeston 
> wrote:
>
> Dear all
>>
>> Does anyone know if Open Office is compatible with Windows 11.
>>
>> Thanks
>>
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: Windows 11

[Jim McLaughlin]

There is, as yet, no Windows 11.  If your question was meant to refer to
Windows 10, which does exist, AOO is reportedin many posts on this list,
be compatabl with Windows 10.   I have not, yet, personally used AOO 4.1.2
with Win 10.

On Fri, Jan 15, 2016 at 12:34 PM, Richard Beeston 
wrote:

> Dear all
>
> Does anyone know if Open Office is compatible with Windows 11.
>
> Thanks

Re: Windows 11

[Jim McLaughlin]

Hi Richard --

If you find Windows 11 in a  store, I hope you'll let Satya Nadella know
right away.

See,
http://www.techradar.com/us/news/software/operating-systems/microsoft-confirms-there-will-be-no-windows-11-1293309

On Fri, Jan 15, 2016 at 1:09 PM, Richard Beeston 
wrote:

> Hi Jim
>
> Sorry to inform you but Windows 11 was launched the day before yesterday
> and is in stores now.
>
> Regards Richard
>
> -Original Message- From: Jim McLaughlin
> Sent: Saturday, January 16, 2016 7:55 AM
> To: users@openoffice.apache.org ; ar2l...@bigpond.com
> Subject: Re: Windows 11
>
>
> There is, as yet, no Windows 11.  If your question was meant to refer to
> Windows 10, which does exist, AOO is reportedin many posts on this list,
> be compatabl with Windows 10.   I have not, yet, personally used AOO 4.1.2
> with Win 10.
>
> On Fri, Jan 15, 2016 at 12:34 PM, Richard Beeston 
> wrote:
>
> Dear all
>>
>> Does anyone know if Open Office is compatible with Windows 11.
>>
>> Thanks
>>
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: Windows 11

[Richard Beeston]

Well what is this then


Image result for windows 11


Windows 11 Release Date, Feature Concepts, Update And ...



windows11update.com/

Get all Windows 11 news, and update. Also find Windows 11 release date, 
features concepts, news and video of operating system.


-Original Message- 
From: Maurice Howe

Sent: Saturday, January 16, 2016 8:37 AM
To: Apache OpenOffice
Subject: Re: Windows 11

No, there isn't.
See:
http://www.techradar.com/us/news/software/operating-systems/microsoft-confirms-there-will-be-no-windows-11-1293309

There is an Internet Explorer 11.  Could you have confused the non-existant
W-11 with IE-11?

On Fri, Jan 15, 2016 at 4:09 PM, Richard Beeston 
wrote:


Hi Jim

Sorry to inform you but Windows 11 was launched the day before yesterday
and is in stores now.

Regards Richard

-Original Message- From: Jim McLaughlin
Sent: Saturday, January 16, 2016 7:55 AM
To: users@openoffice.apache.org ; ar2l...@bigpond.com
Subject: Re: Windows 11

There is, as yet, no Windows 11.  If your question was meant to refer to
Windows 10, which does exist, AOO is reportedin many posts on this list,
be compatabl with Windows 10.   I have not, yet, personally used AOO 4.1.2
with Win 10.

On Fri, Jan 15, 2016 at 12:34 PM, Richard Beeston 
wrote:

Dear all


Does anyone know if Open Office is compatible with Windows 11.

Thanks




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





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

Re: Windows 11

[Elaine]

http://www.geek.com/microsoft/windows-10-is-the-last-version-there-is-no-windows-11-1622504/


There is no Windows 11  but there is an Internet Exploder version 11.


The best job goes to the person who can get it done without passing the buck or 
coming back with excuses. ~~ Napoleon Hill



-Original Message-
From: Richard Beeston 
To: users 
Sent: Fri, Jan 15, 2016 2:09 pm
Subject: Re: Windows 11

Hi Jim

Sorry to inform you but Windows 11 was launched the day before yesterday and 
is in stores now.

Regards Richard

-Original Message- 
From: Jim McLaughlin
Sent: Saturday, January 16, 2016 7:55 AM
To: users@openoffice.apache.org ; ar2l...@bigpond.com
Subject: Re: Windows 11

There is, as yet, no Windows 11.  If your question was meant to refer to
Windows 10, which does exist, AOO is reportedin many posts on this list,
be compatabl with Windows 10.   I have not, yet, personally used AOO 4.1.2
with Win 10.

On Fri, Jan 15, 2016 at 12:34 PM, Richard Beeston 
wrote:

> Dear all
>
> Does anyone know if Open Office is compatible with Windows 11.
>
> Thanks 


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

Re: Windows 11

[Maurice Howe]

Take a moment and read what that site is saying.

On Fri, Jan 15, 2016 at 4:58 PM, Richard Beeston 
wrote:

> Well what is this then
>
>
> Image result for windows 11
>
>
> Windows 11 Release Date, Feature Concepts, Update And ...
>
>
>
> windows11update.com/
>
> Get all Windows 11 news, and update. Also find Windows 11 release date,
> features concepts, news and video of operating system.
>
> -Original Message- From: Maurice Howe
> Sent: Saturday, January 16, 2016 8:37 AM
> To: Apache OpenOffice
> Subject: Re: Windows 11
>
> No, there isn't.
> See:
>
> http://www.techradar.com/us/news/software/operating-systems/microsoft-confirms-there-will-be-no-windows-11-1293309
>
> There is an Internet Explorer 11.  Could you have confused the non-existant
> W-11 with IE-11?
>
> On Fri, Jan 15, 2016 at 4:09 PM, Richard Beeston 
> wrote:
>
> Hi Jim
>>
>> Sorry to inform you but Windows 11 was launched the day before yesterday
>> and is in stores now.
>>
>> Regards Richard
>>
>> -Original Message- From: Jim McLaughlin
>> Sent: Saturday, January 16, 2016 7:55 AM
>> To: users@openoffice.apache.org ; ar2l...@bigpond.com
>> Subject: Re: Windows 11
>>
>> There is, as yet, no Windows 11.  If your question was meant to refer to
>> Windows 10, which does exist, AOO is reportedin many posts on this list,
>> be compatabl with Windows 10.   I have not, yet, personally used AOO 4.1.2
>> with Win 10.
>>
>> On Fri, Jan 15, 2016 at 12:34 PM, Richard Beeston 
>> wrote:
>>
>> Dear all
>>
>>>
>>> Does anyone know if Open Office is compatible with Windows 11.
>>>
>>> Thanks
>>>
>>>
>>
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org
>>
>>
>>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: Windows 11

[Elaine]

That is correct!  There will NOT be a Windows 11 version as Windows 10 is their 
last.  I posted links as well have other users have.


The best job goes to the person who can get it done without passing the buck or 
coming back with excuses. ~~ Napoleon Hill



-Original Message-
From: Doug 
To: users ; ar2lebe 
Sent: Fri, Jan 15, 2016 4:15 pm
Subject: Re: Windows 11



On 01/15/2016 03:55 PM, Jim McLaughlin wrote:
> There is, as yet, no Windows 11.  If your question was meant to refer to
> Windows 10, which does exist, AOO is reportedin many posts on this list,
> be compatabl with Windows 10.   I have not, yet, personally used AOO 4.1.2
> with Win 10.
>
> On Fri, Jan 15, 2016 at 12:34 PM, Richard Beeston 
> wrote:
>
>> Dear all
>>
>> Does anyone know if Open Office is compatible with Windows 11.
>>
>> Thanks
It seems to me that I recently heard that there will be no Windows 11. I 
guess they are just going to keep upgrading Windows 10 every time you 
try to shut down!

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

RE: [ PROPOSAL ] A new REVERSE string function for Spreadsheets

[Dennis E. Hamilton]

These are always fun:

   [The Right Honorable] Sir Winston Leonard Spencer-Churchill, KG, OM, CH, TD, 
PC, DL, FRS, RA

   William Henry Gates II
   William Henry "Bill" Gates III

The only solution I have managed for this is to separate the printed/presented 
form of the name from the form of name to be used in sorting, ranking, and 
maybe searching.  There is redundancy, but it all works.

The presented form might be derived from the fragments which are more easily 
handled in separate fields, especially for sorting and searching purposes.  
I've seen forms that ask for a prefix, given name(s), family name, and 
suffixes.  Then they are arranged appropriately into a concatenated form for 
presentation, mailing labels, organization rosters, whatever. 

Now, in some cultures and languages, the family name is written before, not 
after the given name(s), and that is also how the name is spoken.  Have to deal 
with that too sometimes.

 - Dennis 


> -Original Message-
> From: Julian Thomas [mailto:j...@jt-mj.net]
> Sent: Friday, January 15, 2016 16:22
> To: Open Office Apache list 
> Subject: Re: [ PROPOSAL ] A new REVERSE string function for Spreadsheets
> 
> 
> > On Jan 15, 2016, at 11:49, Ross Murray 
> wrote:
> >
> > I would like to see a REVERSE function, which returns a new string
> with
> > characters in reverse order to the target string.
> >
> > I am attempting to remove duplicates after merging many files to
> create a
> > very large list of names. Names may or may not have middle names;
> and/or
> > initials which may or may not be follows by full stops. I would like
> to
> > extract the last names and use those the primary sort key. While
> feasible
> > with existing functions, it would seem easiest to - REVERSE the full
> names;
> > FIND the first space; RIGHT to extract the last names; and REVERSE
> those to
> > their original form.
> 
> If I were to face this issue today [I think I've struggled with it in
> the past and most of the manipulations were manual], I'd save the file
> as a CSV. I would then in the scripting language of your choice [Rexx or
> Python would be mine] process each line of the CSV, parsing the name
> fields and add a new field for last name, writing out a new CSV which
> could then be opened and sorted.
> 
> Don't forget John Smith PhD or Sam Adams IV or Jr.
> 
>  —
> jt - j...@jt-mj.net
> 
> Hard work pays off in the future. Laziness pays off now.
> 
> 
> 
> 
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org


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

Re: Windows 11

[toki]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 15/01/2016 20:34, Richard Beeston wrote:

> Does anyone know if Open Office is compatible with Windows 11.

I've forgotten the name of the division in Microsoft that is the
equivalent to Apple's _Worldwide Loyalty Team_, but I'm pretty sure that
they would like to know how you obtained a copy of Windows 11.

jonathon
-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.22 (GNU/Linux)

iQIcBAEBAgAGBQJWma0UAAoJEKG7hs8nSMR7LUQQAJZJmaymk1ixywAip445VY9Q
VbeZ0ix01Xn2u6A0S2OUbQCOygQ/oe0nNzHJPEEB+zUgarC5Xxc8Ki6fKBqA7U9D
B9FGno1JHQ0VTid4mEgLayEIiI1lnxJFoOAksG73IIghcooVmt5vsIiojoxMN9qX
L0XuxesHGCFsVwow5SHwZv2plGQCuZ4t6PrfhoECt9T5RtteWGVK+DiymqQdtzk5
EnWg192rW6Bxx5aJ0itvCWY6zok54IOnLDJWmjykWypJ2lWGPNuM/NcHdS9SfOvj
rIIkTvV6ed8P/63eO55mCuO4zX0uKmpjYlmVdh6E1VQuWIXIHlOXgHw8JB15sTVZ
HjEZhpbX0wB/CvBVUUVgQjqmafWaxtGvb8QrrAwyF1HiOgel9CrAfvwusZ7D+YSM
PjeQQOf+56j94fgWDM+HduiQQcN2kFuvDL8rOoTMbwFBiaG8JE6DcJUijv/yNgJ2
WpTMB0GB579G2Flhnd4kxYZXIB0D8BHRHSs9xZ6pt8Urdyw5rpXV2yD7sJfELEvz
P2gcmvDj8Ywxn8Cw8ceyCJhqMsvc8wgR79Vx86rfDLwelM+XmUFDjm6l8Swa2wVh
KKgi8zWm91+l4Pl/0dpgwZM4kpVNZSl1j0dLJDmDeS5E2rCa2PrgFb9rJTBKl0VR
+dHcBFkAs29ybAvFPMQG
=KVtZ
-END PGP SIGNATURE-

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

Re: [ PROPOSAL ] A new REVERSE string function for Spreadsheets

[Julian Thomas]

> On Jan 15, 2016, at 11:49, Ross Murray  wrote:
> 
> I would like to see a REVERSE function, which returns a new string with
> characters in reverse order to the target string.
> 
> I am attempting to remove duplicates after merging many files to create a
> very large list of names. Names may or may not have middle names; and/or
> initials which may or may not be follows by full stops. I would like to
> extract the last names and use those the primary sort key. While feasible
> with existing functions, it would seem easiest to - REVERSE the full names;
> FIND the first space; RIGHT to extract the last names; and REVERSE those to
> their original form.

If I were to face this issue today [I think I've struggled with it in the past 
and most of the manipulations were manual], I'd save the file as a CSV. I would 
then in the scripting language of your choice [Rexx or Python would be mine] 
process each line of the CSV, parsing the name fields and add a new field for 
last name, writing out a new CSV which could then be opened and sorted.

Don't forget John Smith PhD or Sam Adams IV or Jr. 

 —
jt - j...@jt-mj.net

Hard work pays off in the future. Laziness pays off now. 





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

Re: Donate Link

[Dave Fisher]

Please go to www.apache.org and click ASF sponsors link. Granted it may be a 
small % of their revenue. Could it be greater? Yes! It is critical.

Sent from my iPhone

> On Jan 15, 2016, at 3:47 PM, John Hart  wrote:
> 
>> On 1/15/2016 8:41 AM, Bart Bowers wrote:
>> OpenOffice,
>> 
>> I have been using AOo for a few years and just donated $50 in Bitcoin.
>> 
>> The link to donate was hard to find. I think you should put the link on the 
>> top main menu, just to the right of "Download"
>> 
>> Thank you for all of your hard work.
>> 
>> Regards,
> Until the people demand politicians establish tax credits for contributions 
> to Open Source Software, it will
> never be a viable alternative to commercial products.  Companies that fund, 
> and individuals that donate
> time or money to OSS, will always be at a disadvantage in the market place. 
> Their work can be used by
> companies that don't contribute, which gives them an advantage over time, and 
> they become dominant.
> 
> This is the fatal flaw of unbridled capitalism, what empowers the greedy to 
> take over. By not giving credit
> to individuals and corporations that serve the people, those that don't gain 
> control. When the only
> alternative people are offered is Socialism, the system oscillates back and 
> forth between two unworkable
> options until the system fails and the society dies.
> 
> Support Rand, he's one of the few who understands the concentration of power 
> is what's causing America
> to fail, not which party holds it. When people are empowered to solve 
> problems, things get better, when
> government or large corporations take over, things get worse.
> 
> jrh
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
> 

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

Re: Windows 11

[Jim McLaughlin]

On Fri, Jan 15, 2016 at 1:58 PM, Richard Beeston 
wrote:

> Well what is this then
>
>
> Image result for windows 11
>
>
> Windows 11 Release Date, Feature Concepts, Update And ...
>
>
>
> windows11update.com/



What it is is a non Microsoft site with a bunch of third party speculation.

Its sort of parallel to comic book or movie fan boy site predicting the
content of the next Star Wars episode.  Fun reading but pure fiction.

Microsoft is literally, today, giving away Windows 10 for free as a
download.  No way is Microsoft going to be trying to sell a Windows 11
product in competition with a free giveaway of Win 10.

>
>
> Get all Windows 11 news, and update. Also find Windows 11 release date,
> features concepts, news and video of operating system.
>


Perhaps you could identify the names and locations of ghe stores which you
claim were selling Windows "...the day before yesterday..."?
 -

Re: Donate Link

[John Hart]

On 1/15/2016 8:41 AM, Bart Bowers wrote:

OpenOffice,

I have been using AOo for a few years and just donated $50 in Bitcoin.

The link to donate was hard to find. I think you should put the link on the top main 
menu, just to the right of "Download"

Thank you for all of your hard work.

Regards,


Until the people demand politicians establish tax credits for 
contributions to Open Source Software, it will
never be a viable alternative to commercial products.  Companies that 
fund, and individuals that donate
time or money to OSS, will always be at a disadvantage in the market 
place. Their work can be used by
companies that don't contribute, which gives them an advantage over 
time, and they become dominant.


This is the fatal flaw of unbridled capitalism, what empowers the greedy 
to take over. By not giving credit
to individuals and corporations that serve the people, those that don't 
gain control. When the only
alternative people are offered is Socialism, the system oscillates back 
and forth between two unworkable

options until the system fails and the society dies.

Support Rand, he's one of the few who understands the concentration of 
power is what's causing America
to fail, not which party holds it. When people are empowered to solve 
problems, things get better, when

government or large corporations take over, things get worse.

jrh

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

Festlegung des Formats

[Robin Jacobitz]

Hallo, ...
ich habe offensichtlich diese Anweisung beim Update auf die neueste Open Ofice 
Version nicht berücksichtigt:
Um die Registrierung von OpenOffice als Standard-Anwendung für Microsoft Office 
Dateiformate zu erzwingen oder zu unterdrücken, verwenden Sie die folgenden 
Parameter beim Aufruf des Installers:   
   - /msoreg=1 erzwingt die Registrierung von OpenOffice als Standard-Anwendung 
für Microsoft Office Dateiformate.

Ich kann keine docs mehr öffnen! Will aber auch kein Unheil durch die 
Deinstallation von Microsoft Office anrichten  Habt ihr einen Tipp?
LG, Robin Jacobitz

WG: Festlegung des Formats

[Robin Jacobitz]

Hi, 
stimmt gar nicht  ich kann sie nur als"schreibgeschützte Version" oder als 
"Arbeitskopie" öffnen, was beides ebenfalls extrem nervig ist, da wir hier von 
mehr als tausend .docs reden. Habt ihr einen Tipp?



Hallo, ...
ich habe offensichtlich diese Anweisung beim Update auf die neueste Open Ofice 
Version nicht berücksichtigt:
Um die Registrierung von OpenOffice als Standard-Anwendung für Microsoft Office 
Dateiformate zu erzwingen oder zu unterdrücken, verwenden Sie die folgenden 
Parameter beim Aufruf des Installers:   
   - /msoreg=1 erzwingt die Registrierung von OpenOffice als Standard-Anwendung 
für Microsoft Office Dateiformate.

Ich kann keine docs mehr öffnen! Will aber auch kein Unheil durch die 
Deinstallation von Microsoft Office anrichten  Habt ihr einen Tipp?
LG, Robin Jacobitz