Re: [libreoffice-users] busca de soluções para Excel
At 10:57 25/08/2013 +0100, Tom Davies wrote: Again using "Quick Translate" but this time from English into Portuguese. Unfortunately machines are not good at speaking human languages so this might be nonsensical. Which is why it's always best to leave messages in the writer's own language and let the recipient manage the translation - as indeed the original questioner did. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Cross Platfrom Support Question **CLOSED Thread**
On Sat, 24 Aug 2013, Doug wrote: On 08/24/2013 06:22 PM, Jay Ridgley wrote: To those who responded, I guess the bottom line is that currently LibreOfffice does not and will not without a LOT of work support mobile devices. I am not a mobile user, so I have no frame of reference. It does appear that this feature (mobility) will be required at some future point, however. Thanks, Jay What kind of masochist would wish to do any serious writing--the kind that would require a word-processor--on a mobile phone, or a touch-screen tablet? Get real! --doug you can add a small bluetooth keyboard. some come in a kind of sleeve where you can fold the keyboard and the 10" tablet together held by velcro; you unfold it and the tablet is propped up and the keyboard laid out flat. folded up, it all fits into a woman's purse or a small satchel. the keyboard is pretty easy to use for normal-sized hands and fingers. opposite of masochism. not my taste though - I prefer more power and gear - but perfectly understandable setup for many use-cases. F. -- Felmon Davis Better some of a pudding than none of a pie. -- John Ray -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?
Hi :) Can you send them all as Doc? if you can convert the DocX to Doc then it might work better. DocX can be a bit unpredictable at times. Do the documents have lots of images, frames, tables and charts and stuff? Also i'm just wondering if it's possible to send Pdfs of the documents in addition to the documents themselves. LibreOffice can use lossless compression easily and remembers the settings for the next one. Regards from Tom :) From: Info/UX To: users@global.libreoffice.org Sent: Sunday, 25 August 2013, 18:38 Subject: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats? Hello, Apologies if this is a basic question. I've been given some documents to format according to certain style guidelines. The files are mostly .docx and .doc and must be sent off in this format. I work only with LibreOffice. My questions is, if I format the articles using paragraph and page styles rather than just directly changing the format in the body of the document, will the formatting be maintained when the documents are opened in MS Office? I am not concerned with small discrepancies that can be tweaked later on, rather whether this method of formatting generally transfers well. Again, sorry if it's a silly question. Many thanks. Ryan -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Cross Platfrom Support Question **CLOSED Thread**
In data sabato 24 agosto 2013 21:40:14, Doug ha scritto: > On 08/24/2013 06:22 PM, Jay Ridgley wrote: > > To those who responded, > > > > I guess the bottom line is that currently LibreOfffice does not and will > > not without a LOT of work support mobile devices. > > > > I am not a mobile user, so I have no frame of reference. It does appear > > that this feature (mobility) will be required at some future point, > > however. > > > > > > Thanks, > > Jay > > What kind of masochist would wish to do any serious writing--the kind > that would require a word-processor--on a mobile phone, or a > touch-screen tablet? Get real! Well, maybe not in a phone, but a 10" tablet is suitable enough to work with office stuff. Maybe the important point is to re-think the way the commands have to be available to the user, fine-tuned for touch screens: drag&drop, automatic context menu and so on. For example, a simply way could be a setup wizard (always available) to customized the various context menus resulting by the context. Ciao -- Valter Open Source is better! LibreOffice: www.libreoffice.org KDE: www.kde.org Kubuntu: www.kubuntu.org -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] LibreOffice paragraph styles exported to other software/formats?
Hello, Apologies if this is a basic question. I've been given some documents to format according to certain style guidelines. The files are mostly .docx and .doc and must be sent off in this format. I work only with LibreOffice. My questions is, if I format the articles using paragraph and page styles rather than just directly changing the format in the body of the document, will the formatting be maintained when the documents are opened in MS Office? I am not concerned with small discrepancies that can be tweaked later on, rather whether this method of formatting generally transfers well. Again, sorry if it's a silly question. Many thanks. Ryan -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Writer tab stops setting keeps reverting to .5" (solved)
Well that tab stop bug must have happened in 4.0.3 or 4.0.4, since it was not in 4.0.2 Debian based install[s]. Yes, it is best to upgrade to the newest of the versions that is not marked as an "early adopter" version. https://wiki.documentfoundation.org/File:LibOReleaseLifecycle.png "They" changed the graphic, so it is easier to read. 3.6.7 is the "conservative" version 4.0.5 is the "recommended" version and 4.1.0 is the "early adopter" version. On 08/25/2013 04:21 AM, Tom Davies wrote: > Hi :) > Congrats! :) Apparently the 4.0.5 has fixed over 90 bugs too and > compatibility with MS formats has improved quite a bit. I really should > install it now i have downloaded it! > Regards from > Tom :) > > > > > > From: Tim Deaton > To: users@global.libreoffice.org > Sent: Sunday, 25 August 2013, 5:32 > Subject: Re: [libreoffice-users] Writer tab stops setting keeps reverting to > .5" (solved) > > > Thank you for your help. Since Kracked_P_P was using 4.05, I upgraded > from 4.04 to 4.05 tonight. That appears to have solved the problem. > > -- Tim > === > > > On 8/24/2013 10:11 AM, Tom Davies wrote: >> Hi :) >> The best guide about renaming your UserProfile is this one >> https://wiki.documentfoundation.org/UserProfile >> Regards from >> Tom :) >> >> >> >> >> >>From: Kracked_P_P---webmaster >> To: users@global.libreoffice.org >> Sent: Friday, 23 August 2013, 20:42 >> Subject: Re: [libreoffice-users] Writer tab stops setting keeps reverting to >> .5" >> >> >> >> You are saying that the table stop to .25 and then when you go back into >> Writer the next time, the original .49 inch is back? >> I am now using 4.0.5 64-bit Debian install and I do not see that happening. >> >> Ok >> I just booted up a Win7 laptop - oops - it had 4.1.0 >> Trying another system. >> Win7 Pro >> It has 4.0.2.2 >> >> I had no problem keeping the tab stop in place. >> >> Maybe there is a glitch in your user profile. >> I do not know the link to show you where it is, but you should rename >> your user profile "folder" and then restart LO again. This will give >> you a clean copy. See if it still gives you that issue. If it does, >> then it is a 4.0.4.2 Windows issue. Since I have 4.0.2 and 4.1.0 on >> Windows 7 [Home and Professional] and 4.0.5 on Ubuntu 12.04, I cannot >> test the 4.0.4 version without a full reinstall. >> >> The 4.0.2 will be upgraded to 4.0.5 later. >> >> Sorry for you lack of responses. >> Sometimes the questions get lost or no one has seen the reported issue >> before. I had a printer issue that had a check-box option that only was >> seen in a dialog windows of the Debian install versions of LO, and not >> on the Windows install, that solved the problem for one printer, while >> the other[s] did not have the issue at all. >> >> >> >> >> >> On 08/23/2013 01:12 PM, Tim Deaton wrote: >>> This WAS a new thread. And your message was the first response I've >>> seen. Still have no answer. What other new thread were you referring to? >>> >>> -- Tim >>> === >>> On 8/22/2013 11:14 AM, Tom Davies wrote: >>> Hi :) Is this related to the new thread? Did you find a good answer? Regareds from Tom :) From: Tim Deaton To: LO users Sent: Sunday, 18 August 2013, 13:23 Subject: [libreoffice-users] Writer tab stops setting keeps reverting to .5" I'm using LO 4.0.4.2 on Windows 7. Before moving to 4.0, I had my Writer tab stops set to .25" (using Tools - Options - Writer - General - Tab Stops). I set it once and it stayed that way. But since moving to 4.0, it reverts to the default .5" settingevery time I start Writer - even on existing documents - and I have to redo my .25" setting. Does anyone know if this is being fixed in 4.1, or how to cure the problem? -- Tim === I know the plans I have for you: Plans to prosper you and not to harm you; Plans to give you hope and a future. --- God (Jeremiah 29:11) > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] mail merge does not send appropriate documents (was: Fwd: Regarding Mail Merge sending Document)
Hi Shiv, I can confirm the bug with LibreOffice 4.1.0.4 and 3.6.5.2. Did you search bugzilla (http://bugs.freedesktop.org) if it has been reported already? Regards, Nino Am 24.08.2013 07:15, schrieb Shiv Chauhan: > Dear Sir, > > I have created a document using mail merge and inserted data of 10 users by > data source.. > > Name:- > Mail ID:- > Adderss:- > Age:- > > but when i sent this document to all employees on their mail id which is > used in document. > > full document sent on every id and every employee can read information of > all Employee.. > > how to send a individual employee information on individual emails in mail > merge in openoffice.. > > pls help me .. > > With regards > Shiv > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] mail merge does not send appropriate documents (was: Fwd: Regarding Mail Merge sending Document)
Hi Shiv, I can confirm the bug with LibreOffice 4.1.0.4 and 3.6.5.2. Did you search bugzilla (http://bugs.freedesktop.org) if it has been reported already? Regards, Nino Am 24.08.2013 07:15, schrieb Shiv Chauhan: > Dear Sir, > > I have created a document using mail merge and inserted data of 10 users by > data source.. > > Name:- > Mail ID:- > Adderss:- > Age:- > > but when i sent this document to all employees on their mail id which is > used in document. > > full document sent on every id and every employee can read information of > all Employee.. > > how to send a individual employee information on individual emails in mail > merge in openoffice.. > > pls help me .. > > With regards > Shiv > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: SQLException when using ADO driver and prepared statements
Le 25/08/2013 13:05, Alex Thurgood a écrit : Me again. You also might want to read this thread : http://forum.openoffice.org/en/forum/viewtopic.php?f=30&t=41226 which basically resumes the whole situation pretty well. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: SQLException when using ADO driver and prepared statements
Le 22/08/2013 11:52, mhaverin a écrit : Hi, I went and added this: https://www.libreoffice.org/bugzilla/show_bug.cgi?id=68417 Thank you for your help! No problem, the only difficulty now will be finding a QAer who has the same setup or can attempt to do what you are trying to do. I don't think that there are many of those around unfortunately, so your report may go unconfirmed for a while. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Mail merge manual field entry
Le 23/08/2013 03:45, Carl Paulsen a écrit : Hi Carl, Thank you Alex. I'll give your ideas some thought. The key issue for me is that I can manually enter "placeholders" for fields as text that Salesforce can interpret for the merge on their platform (well, I think I can but haven't been able to test it yet). What I can't do is enter any LO commands that trigger a next record or next page that Salesforce can interpret. In the old report designer, before the Oracle Report Builder was integrated, this was a feature of the report designer wizard, which inserted a NextRecord (hidden field as I recall) field into a Writer document and used variables to fill the form with data upon next opening/running of the query supplying data to the form. So, in theory, it should be attainable in some (possibly obscure) fashion. All that said, I still don't really understand how LO handles mail merges and it seems to be tailored to those who want to generate merges with a Calc spreadsheet (even that should be simpler IMHO) or a Base dB or a connected dB for someone who knows a little more. Well, yes, that is what mailmerges are generally based on, some kind of datasource which can be displayed/imported as a spreadsheet or a db query, à la Excel for example, and then taking that datasource and providing the means to insert the data to provide the mailmerge. Your problem is that you don't have a datasource that LO can access. At a minimum, LO requires either a query, a view, a CSV file, or an Excel or LO spreadsheet. If you are using queries or views, then these have to be reachable via the database functionality of LO, which means that you have to have a corresponding connector or connection mechanism, e.g. via a Basic macro that will setup the connection to your remote database instance, execute the query, store the resultset in a stack or array of some kind in a form accessible to LO, and then allow you to proceed to mailmerge. There is an extension that is supposed to help with mailmerges in AOO/LO and which doesn't use the built-in mailmerge functionality : http://extensions.libreoffice.org/extension-center/mail-merge-db Note however, that the author of the extension states that it requires a database in order to work (without specifying what kind of database). I also don't know whether this extension works with a current version of LO. There is also the following : http://extensions.openoffice.org/en/project/fastmailmerge but I have no idea whether it works with LO. It requires at least a spreadsheet as a datasource in order to function. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: [libreoffice-users] busca de soluções para Excel
HI :) Again using "Quick Translate" but this time from English into Portuguese. Unfortunately machines are not good at speaking human languages so this might be nonsensical. HI :) Novamente usando "Quick Translate", mas desta vez do Inglês para o Português. Infelizmente, as máquinas não são bons em falar línguas humanas então isso pode ser sentido. " Não está totalmente claro o que você está esperando como seu resultado aqui: você só precisa de uma lista de viajantes dizem, coluna B desses valores - sem nada em os casos em que o valor não é igual? Em B2, digite: =IF(A2=A$1;A5;"") e preencher esta coluna B. baixo Isso vai dar uma lista dos valores que você precisa, intercaladas com cadeias vazias, onde o valor de um não é igual a A1. Note-se que a sua lista de exemplo apresenta um problema com sua exigência: o que você gostaria de acontecer para o fundo da sua lista quando a terceira célula abaixo uma que jogos está fora da final do lista e, portanto, vazio? Talvez valha a pena dizer que, se você tiver um problema como esse usado, ele pode muito bem ser sensato olhar para trás, o design do seu planilha. Talvez haja um método mais fácil de alcançar o que você realmente precisa. Se você explicar o problema original que você está tentando resolver, alguém pode ser capaz de dar-lhe uma ajuda mais útil. Note que há de língua Português (e Português de fato Brasileiro) listas de discussão: ver https://wiki.documentfoundation.org/Local_Mailing_Lists spero que isso ajude Brian Barker " I have also forwarded the original question to the international translators list. Hopefully they will forward it to the correct language list Eu também encaminhou a pergunta original para a lista internacional de tradutores. Esperemos que eles vão encaminhá-lo para a lista de idioma correto Regards from Tom :) From: Brian Barker To: users@global.libreoffice.org Cc: M Valdes Velasque Sent: Saturday, 24 August 2013, 20:51 Subject: Re: [libreoffice-users] busca de soluções para Excel Sorry, but I do not write Portuguese. At 21:19 24/08/2013 +0300, M Valdes Velasque wrote: >Sempre que a coluna A tiver célula igual a A1 >localizar e copiar a terceira célula que esta >embaixo. Preciso localizar e copiar >simultaneamente somente as terceira célula que >esta embaixo de todas quando for idêntica >A1. Quando for idêntica a A1 localizar e copiar >a terceira celula que esta embaixo It's not entirely clear what you are expecting as your result here: do you just need a list in, say, column B of these values - with nothing in the cases where the value is not equal? In B2, enter: =IF(A2=A$1;A5;"") and fill this down column B. This will give a list of the values you require, interspersed with empty strings where the value in A does not equal A1. Note that your sample list displays one problem with your requirement: what would you like to happen towards the bottom of your list when the third cell below one that matches is off the end of the list and therefore empty? It is perhaps worth saying that if you run into a problem such as this, it may well be sensible to look back at the design of your spreadsheet. Perhaps there is an easier method of achieving what you actually need. If you explain the original problem you are trying to solve, someone may be able to give you more useful help. Note that there are Portuguese-language (and indeed Brazilian Portuguese) mailing lists: see https://wiki.documentfoundation.org/Local_Mailing_Lists . I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Writer tab stops setting keeps reverting to .5" (solved)
Hi :) Congrats! :) Apparently the 4.0.5 has fixed over 90 bugs too and compatibility with MS formats has improved quite a bit. I really should install it now i have downloaded it! Regards from Tom :) From: Tim Deaton To: users@global.libreoffice.org Sent: Sunday, 25 August 2013, 5:32 Subject: Re: [libreoffice-users] Writer tab stops setting keeps reverting to .5" (solved) Thank you for your help. Since Kracked_P_P was using 4.05, I upgraded from 4.04 to 4.05 tonight. That appears to have solved the problem. -- Tim === On 8/24/2013 10:11 AM, Tom Davies wrote: > Hi :) > The best guide about renaming your UserProfile is this one > https://wiki.documentfoundation.org/UserProfile > Regards from > Tom :) > > > > > > From: Kracked_P_P---webmaster > To: users@global.libreoffice.org > Sent: Friday, 23 August 2013, 20:42 > Subject: Re: [libreoffice-users] Writer tab stops setting keeps reverting to > .5" > > > > You are saying that the table stop to .25 and then when you go back into > Writer the next time, the original .49 inch is back? > I am now using 4.0.5 64-bit Debian install and I do not see that happening. > > Ok > I just booted up a Win7 laptop - oops - it had 4.1.0 > Trying another system. > Win7 Pro > It has 4.0.2.2 > > I had no problem keeping the tab stop in place. > > Maybe there is a glitch in your user profile. > I do not know the link to show you where it is, but you should rename > your user profile "folder" and then restart LO again. This will give > you a clean copy. See if it still gives you that issue. If it does, > then it is a 4.0.4.2 Windows issue. Since I have 4.0.2 and 4.1.0 on > Windows 7 [Home and Professional] and 4.0.5 on Ubuntu 12.04, I cannot > test the 4.0.4 version without a full reinstall. > > The 4.0.2 will be upgraded to 4.0.5 later. > > Sorry for you lack of responses. > Sometimes the questions get lost or no one has seen the reported issue > before. I had a printer issue that had a check-box option that only was > seen in a dialog windows of the Debian install versions of LO, and not > on the Windows install, that solved the problem for one printer, while > the other[s] did not have the issue at all. > > > > > > On 08/23/2013 01:12 PM, Tim Deaton wrote: >> This WAS a new thread. And your message was the first response I've >> seen. Still have no answer. What other new thread were you referring to? >> >> -- Tim >> === >> On 8/22/2013 11:14 AM, Tom Davies wrote: >> >>> Hi :) >>> Is this related to the new thread? Did you find a good answer? >>> Regareds from >>> Tom :) >>> >>> >>> >>> >>> >>> From: Tim Deaton >>> To: LO users >>> Sent: Sunday, 18 August 2013, 13:23 >>> Subject: [libreoffice-users] Writer tab stops setting keeps reverting >>> to .5" >>> >>> I'm using LO 4.0.4.2 on Windows 7. >>> >>> Before moving to 4.0, I had my Writer tab stops set to .25" (using Tools >>> - Options - Writer - General - Tab Stops). I set it once and it stayed >>> that way. But since moving to 4.0, it reverts to the default .5" >>> settingevery time I start Writer - even on existing documents - and I >>> have to redo my .25" setting. >>> >>> Does anyone know if this is being fixed in 4.1, or how to cure the >>> problem? >>> >>> -- Tim >>> === >>> I know the plans I have for you: >>> Plans to prosper you and not to harm you; >>> Plans to give you hope and a future. >>> --- God (Jeremiah 29:11) >>> >>> >> > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
