[libreoffice-users] Calc as a Flat File Database
Hi All I was thinking the other day about using Calc as a Flat File Database - ie with no relationships. Many users make use of a Spreadsheet as a kind of Database but the problem is viewing the data. So I was wondering if there is and Add-On or Extension available to give you a "Form" to overlay the Spreadsheet so that you can view the data one row at a time?? Or if not would it be possible to achieve this using Macros?? I would be most interested in any suggestions or input. Thanks IanW Pretoria RSA -- 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] Calc as a Flat File Database
On Tue, Mar 8, 2016 at 8:02 AM, Ian Whitfield wrote: > So I was wondering if there is and Add-On or Extension available to give > you a "Form" to overlay the Spreadsheet so that you can view the data one > row at a time?? > Hello Ian - I don't know the particulars but can say that the Form... option in the Data menu works for me for a simple test file. I created a spreadsheet and put column titles in row A then entered several rows of data. Selecting Data>Form with any cell within the boundaries of the column labels and data already selected brought up the form. If the selected cell was outside the range then the form was empty. There was no need to name the data range. Simply entered column titles and rows of data and it worked. -- 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 Draw Has Been Reviewed at ListOfFreeware
Hello, I am Ramesh from www.listoffreeware.com. This is a popular tech blog that lists best free software out there. I am sending this mail to let you know that we recently reviewed LibreOffice Draw on our website here: http://listoffreeware.com/best-free-svg-editor-software-for-windows/ Congrats! If you want to flaunt this review on your website, feel free to use the badge that I have included with this email, or you can also use the code I have added below: href="http://listoffreeware.com/best-free-svg-editor-software-for-windows/"; title=""> src=" http://listoffreeware.com/wp-content/uploads/Reviewed_At_ListOfFreeware.png "/> Feel free to get back to me with any questions. Have Fun, Ramesh Collaboration Manager w: http://www.listoffreeware.com/ https://www.facebook.com/listoffreeware https://twitter.com/listoffreeware -- 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] SharePoint y LibreOffice 5.1
Your image did not accompany the email. If you can upload it to the internet and then provide a link to it we can download it. Attachments are stripped off before it is sent to the users. On 03/07/2016 10:50 PM, Eva María Piñero Girón wrote: Good morning, I'm trying to test the integration of SharePoint 2013 with LibreOffice 5.1. If you create a new document is stored without problems in the particular library , but if what I want is to edit a document already created shows me the following error: [cid:image001.png@01D17881.16BFD500] Does anyone know is happening? Thank you. Eva. -- Blessings, Joe Conner Joshua 24:15 "...as for me and my house, we will serve the LORD." -- 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] drop down box set value ?
Hi I have a dropdownbox using a cell range $data.$E$2:$E$3 how can i set a default value or can i put the same data in a list thanks Beau -- 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: LO ver. 5.1.0.3 calc - missing menu functions
Update - my apologies for omitting this information, although I doubt that it much matters in this case: I'm running Linux Mint - Cinnamon 17.2 (Rafaela), based on Ubuntu 14.04 t. On Tue, Mar 8, 2016 at 2:31 PM, Tom Cloyd wrote: > This upgrade has destroyed the functionality of a spreadsheet I utterly > depend upon throughout my day. > > So far, here is what I've discovered, in a mere few minutes working with > it, and this is just on the main menu ("file, edit", etc.): > > * INSERT: missing - "Cells, Rows, Columns, Sheet" - LO Help says they are > there. Look at "Inserting rows", etc. But they are not. > * EDIT: missing - the "Fill > Series" function. Again, LO help says it's > there - Look at "filling;cells, automatically". But it's not. > > This is a disaster for me. I'm reverting to previous version, just so I > can get my work done. > > Tom > > -- > ~ > > Believe that life is worth living and your belief will help create the > fact. ~ William James > > ~ > Tom Cloyd, MS MA LMHC (WA) > Psychotherapist (psychological trauma, dissociative disorders) > Spokane, Washington, U.S.A: (435) 272-3332 > << t...@tomcloyd.com >> (email) > << TomCloyd.com >> (website) > ~ > -- ~ Believe that life is worth living and your belief will help create the fact. ~ William James ~ Tom Cloyd, MS MA LMHC (WA) Psychotherapist (psychological trauma, dissociative disorders) Spokane, Washington, U.S.A: (435) 272-3332 << t...@tomcloyd.com >> (email) << TomCloyd.com >> (website) ~ -- 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] LO ver. 5.1.0.3 calc - missing menu functions
This upgrade has destroyed the functionality of a spreadsheet I utterly depend upon throughout my day. So far, here is what I've discovered, in a mere few minutes working with it, and this is just on the main menu ("file, edit", etc.): * INSERT: missing - "Cells, Rows, Columns, Sheet" - LO Help says they are there. Look at "Inserting rows", etc. But they are not. * EDIT: missing - the "Fill > Series" function. Again, LO help says it's there - Look at "filling;cells, automatically". But it's not. This is a disaster for me. I'm reverting to previous version, just so I can get my work done. Tom -- ~ Believe that life is worth living and your belief will help create the fact. ~ William James ~ Tom Cloyd, MS MA LMHC (WA) Psychotherapist (psychological trauma, dissociative disorders) Spokane, Washington, U.S.A: (435) 272-3332 << t...@tomcloyd.com >> (email) << TomCloyd.com >> (website) ~ -- 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] SharePoint y LibreOffice 5.1
Hi Joe, the text that appears in the error is: "Failed to save the document Pruebas: General error. General error Input / Output" Could you help me? Thanks -Mensaje original- De: Joe Conner [mailto:joeconner2...@gmail.com] Enviado el: martes, 08 de marzo de 2016 19:51 Para: Eva María Piñero Girón; users@global.libreoffice.org Asunto: Re: [libreoffice-users] SharePoint y LibreOffice 5.1 Your image did not accompany the email. If you can upload it to the internet and then provide a link to it we can download it. Attachments are stripped off before it is sent to the users. On 03/07/2016 10:50 PM, Eva María Piñero Girón wrote: > Good morning, > > I'm trying to test the integration of SharePoint 2013 with LibreOffice 5.1. > If you create a new document is stored without problems in the particular > library , but if what I want is to edit a document already created shows me > the following error: > > > [cid:image001.png@01D17881.16BFD500] > > > Does anyone know is happening? > > > > Thank you. > > Eva. > > > > > -- Blessings, Joe Conner Joshua 24:15 "...as for me and my house, we will serve the LORD." -- 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] LO ver. 5.1.0.3 calc - missing menu functions
Tom You will find all these items under "Sheet". The built-in help seems to be out-of-date. Graham On 8 March 2016 at 23:31, Tom Cloyd wrote: > This upgrade has destroyed the functionality of a spreadsheet I utterly > depend upon throughout my day. > > So far, here is what I've discovered, in a mere few minutes working with > it, and this is just on the main menu ("file, edit", etc.): > > * INSERT: missing - "Cells, Rows, Columns, Sheet" - LO Help says they are > there. Look at "Inserting rows", etc. But they are not. > * EDIT: missing - the "Fill > Series" function. Again, LO help says it's > there - Look at "filling;cells, automatically". But it's not. > > This is a disaster for me. I'm reverting to previous version, just so I can > get my work done. > > Tom > > -- > ~ > > Believe that life is worth living and your belief will help create the > fact. ~ William James > > ~ > Tom Cloyd, MS MA LMHC (WA) > Psychotherapist (psychological trauma, dissociative disorders) > Spokane, Washington, U.S.A: (435) 272-3332 > << t...@tomcloyd.com >> (email) > << TomCloyd.com >> (website) > ~ > > -- > 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