Re: Removing Duplicate entries?
At 17:29 20/06/2019 -0400, Daniel Noname wrote: Is there a way to remove duplicates from a mail list using a TextEdit ... A what? ... with OpenOffice on a Mac Computer? Yes. o Open a new spreadsheet (Calc) document. o Paste your list into a column. o Select the range containing the list (or just the entire column). o Go to Data | Filter > | Standard Filter... . o For the first "Field name", select "- none -" from the drop-down menu. o Click More Options. o Ensure that "Range contains column labels" is not ticked (unless you have included a column label). o Tick "No duplication". o Click OK. Duplicate entries are now hidden. o Select the (reduced) range. o Copy the range (Edit | Copy or Ctrl+C). Crucially, entries hidden using a filter are omitted from the copy action. o Paste the edited list back into your source. Remember that small and perhaps insignificant differences between entries - different cases, spacing, punctuation - will prevent otherwise similar entries being identified as duplicates. 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: Unfound file extension.
As an aside you should never use an office file to pass on crucial information because it can be changed, unless you passward protect it and I'm not absolutley sure you can do this when sending a file. It should be allowed to send as PDF and even then it can be changed. Original message From: Julian THOMAS Date: 20/06/2019 14:32 (GMT+00:00) To: users@openoffice.apache.org Subject: Re: Unfound file extension. Typical burrocrats!Options - find a windoze user with Office and have them save as xlsx.Or a Mac user - I'm almost positive that the [free] Numbers app will save as xlsx. Sent from JT's Ipad - maybe using voice dictation!> On Jun 19, 2019, at 23:51, Diana Allen wrote:> > This is a problem since according to the revenue department, when filing electronically, it MUST be in this format.Is there a workaround for this problem, or will I have to file on paper and pay fees? -To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional commands, e-mail: users-h...@openoffice.apache.org
Re: Removing Duplicate entries?
if you are on a unix machine or a linux machine, and your list is a text file (lets say mylist.txt); then you can eliminate duplicates in this way: sort -f mylist.txt | uniq > mylist2.txt the -f option ignores the case of the characters (ie. upper or lower). On 6/20/19, daniel wrote: > Hi Friends, > > Is there a way to remove duplicates from a mail list using a TextEdit with > OpenOffice on a Mac Computer? > > Thank you for your time! > > daniel > - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Removing Duplicate entries?
I do not know what you mean by "using a TextEdit". However I can offer the following suggestions (all presume each mail list address is on a single line) ... 1. sort the address list and then remove the duplicate entries by inspecting the list 2. for a long list, import the entries to a table then run a query for unique entries, save the query result as the new list On Thu, Jun 20, 2019 at 5:31 PM daniel wrote: > Hi Friends, > > Is there a way to remove duplicates from a mail list using a TextEdit with > OpenOffice on a Mac Computer? > > Thank you for your time! > > daniel > -- Alan Boba CISSP, CCENT, ITIL v3 Foundations 2011
Removing Duplicate entries?
Hi Friends, Is there a way to remove duplicates from a mail list using a TextEdit with OpenOffice on a Mac Computer? Thank you for your time! daniel
Re: letzte eingabe löschen
Mit den Tasten STRG + Z geht das noch schneller, und die Rückgängigkeit wieder rückgängig geht auch: STRG + Y Aber so ein Button gibt es, den kannst du ins Menü hinzufügen On Thu, 20 Jun 2019 at 21:16, richard kohl wrote: > In jedem ähnlichen programm gibt es an prominenter Stelle einen button, > um die > > letzte Eingabe rückgängig zu machen oder zu löschen. > > Ich finde derartiges nicht . > > Biite um einen Hinweis. > > mfg Richard Kohl > > > - > To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-de-h...@openoffice.apache.org > >
letzte eingabe löschen
In jedem ähnlichen programm gibt es an prominenter Stelle einen button, um die letzte Eingabe rückgängig zu machen oder zu löschen. Ich finde derartiges nicht . Biite um einen Hinweis. mfg Richard Kohl - To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-de-h...@openoffice.apache.org
Just a quick thank you
I am not sure if I am sending this e-mail to the right web address, but I just wanted to send a warm, heartfelt thank you to Apache - Open Office for allowing me to utilize your open office software over the last 10 years. Although I haven't used it much, it has been invaluable to me. So thanks again, and thanks to all of you for your continued hard work. Sincerely,Myles
Re: Unfound file extension.
If it was me, I would just change the extension after I saved it as an xls file. :) I would bet it will be opened on the other end fine. Shari On 6/19/2019 10:51 PM, Diana Allen wrote: I have an Excel document from a state revenue department that is in .xlsx format.OO opens it correctly and allows it to be filled out, but I note that this file extension (.xlsx) is NOT in the available Excel extensions to SAVE the file in. This is a problem since according to the revenue department, when filing electronically, it MUST be in this format.Is there a workaround for this problem, or will I have to file on paper and pay fees? What is the difference between .xls and .xlsx anyway? There IS a way to file the paperwork as an .xml file, but the instructions for THAT are very confusing! An answer is needed ASAP as the form needs to be filed within 20 days of the end of the quarter, (last day of June;) and I do NOT want to have to buy MSOffice when I have been using OO for more than 20 years! Thank you. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: open office calc
At 12:49 20/06/2019 +, Andy Moss wrote: How do I select multiple names once I have put a standard filter on. It is only letting me do 1 or all. But I want to do 5 or 10 at the same time? The standard filter applies whatever condition you have chosen. If you want a more complex filter condition, you have to embody that in the filter itself, which you can do using AND and OR in the Operator field of the Standard Filter dialogue. Perhaps Names = John OR Names = Mary? If you want as many as five otherwise random names to appear, presumably they have something in common. Should you have an extra column in your spreadsheet showing that property - date of joining?, subscription overdue? - and filter on that property instead? 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: Unfound file extension.
Typical burrocrats! Options - find a windoze user with Office and have them save as xlsx. Or a Mac user - I'm almost positive that the [free] Numbers app will save as xlsx. Sent from JT's Ipad - maybe using voice dictation! > On Jun 19, 2019, at 23:51, Diana Allen wrote: > > This is a problem since according to the revenue department, when filing > electronically, it MUST be in this format.Is there a workaround for this > problem, or will I have to file on paper and pay fees? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
open office calc
Good afternoon, How do I select multiple names once I have put a standard filter on. It is only letting me do 1 or all. But I want to do 5 0r 10 at the same time? Thanks Andy Moss
Re: Unfound file extension.
Since you are not subscribed to this list you may not see all the replies to your query. To subscribe to Apache OpenOffice mailing lists go to http://openoffice.apache.org/mailing-lists.html As a courtesy I have sent a copy of this reply to you as well as to the mailing list. Do Not reply to me personally but just to the list at - replies to my personal email address will be ignored. On 20/6/19 1:21 pm, Diana Allen wrote: I have an Excel document from a state revenue department that is in .xlsx format.OO opens it correctly and allows it to be filled out, but I note that this file extension (.xlsx) is NOT in the available Excel extensions to SAVE the file in. This is a problem since according to the revenue department, when filing electronically, it MUST be in this format.Is there a workaround for this problem, or will I have to file on paper and pay fees? LibreOffice is capable of reading and writing XLSX files. What is the difference between .xls and .xlsx anyway? Have a look at https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac/what-is-the-real-difference-between-a-xls-vs-xlsx/c7a9d641-d6cf-485d-81d8-1bee60bb17d0 There IS a way to file the paperwork as an .xml file, but the instructions for THAT are very confusing! An answer is needed ASAP as the form needs to be filed within 20 days of the end of the quarter, (last day of June;) and I do NOT want to have to buy MSOffice when I have been using OO for more than 20 years! Thank you. Cheers -- David Robley Mac error message: Like, dude, something's wrong. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org