[tdf-discuss] Looking for an easier way to do the following in a spreadsheet
By saving a spreadsheet as a csv file, I can import the values into another program (it creates labels and btw the program is designed for it printer only). The labels are paired numbers Let say I have a column labeled A-O (starting at cell a1 A B C D E F G H and so on (this is row 1) 1 1 2 2 3 3 4 4 5 5 and so on (this is row a2) 6 6 7 7 8 8 9 9 10 10 and so on (this is row a3) Cell A1 will be the starting input value and the rest will be generated a1= a1 b2=a2 c2=a2+1d2=a1+2e2=a1+2 f2=a1+3 and so on. (1) (1) (2) (3) (3) (4) Since column O makes the total columns number odd (15 colums) I cannot just copy the cells down. Any know an easier way of doing this. I am enclosing a sample file (hopefully anyway). :) Thanks ahead to all that helps. http://nabble.documentfoundation.org/file/n3995544/Double_Number_Series.ods Double_Number_Series.ods -- View this message in context: http://nabble.documentfoundation.org/Looking-for-an-easier-way-to-do-the-following-in-a-spreadsheet-tp3995544.html Sent from the Discuss mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
[tdf-discuss] Re: Referencing systems and bibliographies in LO
In response to Charles: I am proposing a future set of ideas for discussion about libreoffice and it's referencing system as I believe it is not very good at the moment compared to other software open source proprietary in the way that companies create referencing systems. ljelly. On Friday, 13 July 2012, Fabian Rodriguez wrote: On 07/12/2012 08:03 PM, lj wrote: If this is is in the wrong place please notify immediately of where I can post this in the right spot! [...] I have a few questions to ask about bibliographic referencing in Libreoffice: (some of these questions and statements are obvious and easy to answer others may not be relevant. Please reply with reasons and answers for disscussion about the referencing system [...]: This statement summarizes it best IMO: [The] bibliography referencing in Libreoffice, is vastly minimal but then is complex to use the referencing system and to follow the direct steps! In my dealings with a few customers I've helped with LibreOffice, they have moved to Zotero, a free, open source system to easily gather, share and use bibliography references. I am not expert with Zotero, but have explored it to determine how it works and what is needed. One important problem is you can't reproduce the current sharing/social/public web part of the service at zotero.org, but everything else is free, open source software. 3. compatability does not work between Microsoft Office and Libreoffice with the usage of both referencing systems from either word or libreoffice, features are excluded or do not work. (I can ellaborate on these if needed to be posted) What I've observed is that once users decide to go for LibreOffice, they will want to convert to other free,open source software (like Zotero). Using both operating systems/applications on either interchangeably becomes impractical very quickly. Keep in mind it's rather difficult to influence important changes/bug fixes in non-free, non-open source software, so it's a waste of time going that route (in my opinion!). I am very biaised about this, though, I encourage you to ask more questions and make your own opinion. 4. Recent versions of Microsoft Office since 2007 have tried to create uncomplex versions of referencing and bibliographic citations. These systems work, but are still limited. OneNote seems very popular. Keep in mind Microsoft is a business and will do everything it can to make it easy/pleasant/profitable to stay with Microsoft Office. Such a system won't exist in LibreOffice in the short or even long term specially when specialized 3rd party alternatives like Zotero exist and speciall when core functionality in LibreOffice is not feature-complete/bug-free yet. Someone / some organization would need to be very motivated and have good resources to attempt this. 5. LO should create a new referencing system. See above. Questions about referencing in LO: Not in any order. [..] I lack the time to answer more, hopefully someone else can jump in and help here. Cheers, Fabian Rodriguez http://libreoffice.magicfab.ca -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.orgjavascript:; Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
[tdf-discuss] Re: Referencing systems and bibliographies in LO
In response to Fabian: Proposing ideas and bug fixes and changes in proprieterary software probably isn't the right direction unless libreoffice have developers that are working in partnership on referencing systems in proprieterary software. Which I believe at this stage they do not. I understand your example with microsoft onenote. A program I have used myself, and I can understand its innovation and ideas, but that software has broadened markets such as being available on different hardware, etc the iOS platform and the Internet with storage of Microsoft skydrive. In regards to the referencing system in LO. zotero is an extension that I have used with LO. Although it works very well with compatability with LO its referencing systems are incompatible with Microsoft office. I think that is an issue with LO, and Microsoft office referencing systems. I will confirm this from a email from zotero about this issue. As a result, I believe this is a main issue and concern with referencing systems in LO. compatability with properitary software referencing systems etc MO. Referencing systems and making bibliographies I believe in LO needs to be created for users with a simplistic default interface without add ons and extensions to avoid in compatability with different versions of software releases from zotero and LO. My problem is having a reference from libreoffice and trying to use it on Mo. it is not compatible. But. The only way to make the software more compatible for users is to propose a new referencing system in libreoffice, that would allow the document to be read in a format in which both office suites would understand. An example would be PDF and integrating referencing compatabilities in a PDF. or referencing systems with .doc files. I'm still not clear about this topic. LO needs a new default referencing system because I believe it is not clear enough or fast enough to store references for users using libreoffice writer. There are some confusing steps involved including using the bibliographic database where functions do not make sense. LO should consider options I believe to make referencing separate from libreoffice base and making 2 referencing systems. One that integrates a utility with storing references using endnotes and footnotes with a simpler and faster design that can be used for advanced users in base to store multiple references for a main project, with a design that is based on the storage of references only. This can be from books images videos and websites. and a simpler system for users that want to generate a reference that is created with the usage of forms and detailed texts that can be linked to end notes and footnotes without the reference being stored in libreoffice base. ljelly. On Sunday, 15 July 2012, lj wrote: In response to Charles: I am proposing a future set of ideas for discussion about libreoffice and it's referencing system as I believe it is not very good at the moment compared to other software open source proprietary in the way that companies create referencing systems. ljelly. On Friday, 13 July 2012, Fabian Rodriguez wrote: On 07/12/2012 08:03 PM, lj wrote: If this is is in the wrong place please notify immediately of where I can post this in the right spot! [...] I have a few questions to ask about bibliographic referencing in Libreoffice: (some of these questions and statements are obvious and easy to answer others may not be relevant. Please reply with reasons and answers for disscussion about the referencing system [...]: This statement summarizes it best IMO: [The] bibliography referencing in Libreoffice, is vastly minimal but then is complex to use the referencing system and to follow the direct steps! In my dealings with a few customers I've helped with LibreOffice, they have moved to Zotero, a free, open source system to easily gather, share and use bibliography references. I am not expert with Zotero, but have explored it to determine how it works and what is needed. One important problem is you can't reproduce the current sharing/social/public web part of the service at zotero.org, but everything else is free, open source software. 3. compatability does not work between Microsoft Office and Libreoffice with the usage of both referencing systems from either word or libreoffice, features are excluded or do not work. (I can ellaborate on these if needed to be posted) What I've observed is that once users decide to go for LibreOffice, they will want to convert to other free,open source software (like Zotero). Using both operating systems/applications on either interchangeably becomes impractical very quickly. Keep in mind it's rather difficult to influence important changes/bug fixes in non-free, non-open source software, so it's a waste of time going that route (in my opinion!). I am very biaised about this, though, I encourage you to ask more questions and make your own
Re: [tdf-discuss] Re: Referencing systems and bibliographies in LO
Ljelly, I still don't know if the dev mailing list would be the right place, because a discussion is just that, a discussion, and it seems you have a whole set of ideas and requirements. Did I get it right? What I would suggest is this; if you have requirements, you can write specs on the wiki or generally outline what would be needed. Then point to the wiki page you have edited to the dev mailing list, and see if you could have developers getting interested in this. Hope this helps, Charles. 2012/7/15 lj ljelou...@gmail.com In response to Charles: I am proposing a future set of ideas for discussion about libreoffice and it's referencing system as I believe it is not very good at the moment compared to other software open source proprietary in the way that companies create referencing systems. ljelly. On Friday, 13 July 2012, Fabian Rodriguez wrote: On 07/12/2012 08:03 PM, lj wrote: If this is is in the wrong place please notify immediately of where I can post this in the right spot! [...] I have a few questions to ask about bibliographic referencing in Libreoffice: (some of these questions and statements are obvious and easy to answer others may not be relevant. Please reply with reasons and answers for disscussion about the referencing system [...]: This statement summarizes it best IMO: [The] bibliography referencing in Libreoffice, is vastly minimal but then is complex to use the referencing system and to follow the direct steps! In my dealings with a few customers I've helped with LibreOffice, they have moved to Zotero, a free, open source system to easily gather, share and use bibliography references. I am not expert with Zotero, but have explored it to determine how it works and what is needed. One important problem is you can't reproduce the current sharing/social/public web part of the service at zotero.org, but everything else is free, open source software. 3. compatability does not work between Microsoft Office and Libreoffice with the usage of both referencing systems from either word or libreoffice, features are excluded or do not work. (I can ellaborate on these if needed to be posted) What I've observed is that once users decide to go for LibreOffice, they will want to convert to other free,open source software (like Zotero). Using both operating systems/applications on either interchangeably becomes impractical very quickly. Keep in mind it's rather difficult to influence important changes/bug fixes in non-free, non-open source software, so it's a waste of time going that route (in my opinion!). I am very biaised about this, though, I encourage you to ask more questions and make your own opinion. 4. Recent versions of Microsoft Office since 2007 have tried to create uncomplex versions of referencing and bibliographic citations. These systems work, but are still limited. OneNote seems very popular. Keep in mind Microsoft is a business and will do everything it can to make it easy/pleasant/profitable to stay with Microsoft Office. Such a system won't exist in LibreOffice in the short or even long term specially when specialized 3rd party alternatives like Zotero exist and speciall when core functionality in LibreOffice is not feature-complete/bug-free yet. Someone / some organization would need to be very motivated and have good resources to attempt this. 5. LO should create a new referencing system. See above. Questions about referencing in LO: Not in any order. [..] I lack the time to answer more, hopefully someone else can jump in and help here. Cheers, Fabian Rodriguez http://libreoffice.magicfab.ca -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org javascript:; Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Re: Referencing systems and bibliographies in LO
On 07/15/2012 09:02 AM, lj wrote: In response to Fabian: Proposing ideas and bug fixes and changes in proprieterary software probably isn't the right direction unless libreoffice have developers that are working in partnership on referencing systems in proprieterary software. Which I believe at this stage they do not. We agree on that. Before going any further, I'd urge you to follow Charles advice and formalize a wiki document with your ideas/proposal. Otherwise this will live and die here in the mailing list unless there is some extraordinary new, numerous groups of LibreOffice + bibliography users here :) Keep in mind you may be proposing something that already exists in other projects (see below). I understand your example with microsoft onenote. A program I have used myself, and I can understand its innovation and ideas, but that software has broadened markets such as being available on different hardware, etc the iOS platform and the Internet with storage of Microsoft skydrive. My main criteria for using software is it must be free, open source. Close second is being as good or better. If you look at mobile applications for Zotero, you'll see you can also use OwnCloud to store its database of documents - hosted on your own server. I try to reproduce the same functionality, or better, with free, open source software integration. I briefly comment on such experiments either on JoinDiaspora or G+: https://joindiaspora.com/posts/1737364 https://plus.google.com/102415554453485274892/posts/PskhYYaDMaR Of course the feature set *at the moment* is not complete. But it's more often than not dictated by actual needs of its users, not mostly by Microsoft or some other corporation which motivation #1 (and obligation to shareholders) is profit. I also have greater influence and chances to get fixes in such projects. With this in mind I find it more productive to bring closer the communities of existing products like Zotero, OwnCloud and LibreOffice, and have them build on each other's work. The goal that you are seeking then looks closer to me. If I were to propose something to LibreOffice devs, it would be to *completely remove the current bibliographic support* and embrace/extend/integrate Zotero into LibO, perhaps as a default 3rd party extension (much like happened recently with some grammar/spelling dictionaries I believe). The current functionality is broken, unreliable and requires careful understanding to wrok at a basic level, nevermind at the same level as Zotero (with social sharing, remote storage, standard formats, etc.). In regards to the referencing system in LO. zotero is an extension that I have used with LO. Although it works very well with compatability with LO its referencing systems are incompatible with Microsoft office. I think that is an issue with LO, and Microsoft office referencing systems. I will confirm this from a email from zotero about this issue. In my opinion you will get limited success and progress with this approach. With the limited resources TDF has, I doubt any developer will be working to make it easier for you to stay working with MS Office. A better use of such resources would be to demonstrate and advocate the use of Zotero + LibreOffice to your peers (or in the environment where you seem to have no choice) - and fix whatever is missing to make it easier for MS Office/Notes users to leave that platform. As a result, I believe this is a main issue and concern with referencing systems in LO. compatability with properitary software referencing systems etc MO. Interoperability is important, but in this case I believe the main issue is a component that is not critical to 100% of LIbO users, and several interesting alternatives (including Zotero). So this is not going to get critical priority assignment, IMO. Referencing systems and making bibliographies I believe in LO needs to be created for users with a simplistic default interface without add ons and extensions to avoid in compatability with different versions of software releases from zotero and LO. You're describing what Zotero already does (including plugins!). Why duplicate efforts? See my rationale above about getting those projects working together, rather than reinventing such tools. My problem is having a reference from libreoffice and trying to use it on Mo. it is not compatible. LibreOffice happens to have a basic tool for a bibliography database. The problem is not incompatibility, the problem is having the expectation it will become One Note (which is primarily to take notes, not references, as I understand it) overnight (or soon). But. The only way to make the software more compatible for users is to propose a new referencing system in libreoffice, that would allow the document to be read in a format in which both office suites would understand. An example would be PDF and integrating referencing compatabilities in a PDF. or referencing systems with .doc files. I'm
Re: [tdf-discuss] Re: Referencing systems and bibliographies in LO
Firstly, Thank You for all of your responses. I will definitely create a wiki page about this topic on wiki.documentfoundation.org I have already created an account. just as a heads up... this is my first wiki page creation.. are there any pages where there are specific rules (criteria) or tips, where i could put my wiki page? that can be given when creating a wiki page. I will ask this in in ask.libreoffice.org.. as well.. and i will discuss this topic on zotero forums as well, i think Fabian, is right that there should be more integration with zotero and libreoffice. at the moment I don't have much time for me to create a fully featured wiki page.. for discussion about referencing systems in libreoffice... but I can create a document which will outline information about the referencing systems as a draft, which I can then transfer the content over to the wiki page creation. I think that is the best approach! ljelly. On Mon, Jul 16, 2012 at 2:43 AM, Fabian Rodriguez magic...@member.fsf.orgwrote: On 07/15/2012 09:02 AM, lj wrote: In response to Fabian: Proposing ideas and bug fixes and changes in proprieterary software probably isn't the right direction unless libreoffice have developers that are working in partnership on referencing systems in proprieterary software. Which I believe at this stage they do not. We agree on that. Before going any further, I'd urge you to follow Charles advice and formalize a wiki document with your ideas/proposal. Otherwise this will live and die here in the mailing list unless there is some extraordinary new, numerous groups of LibreOffice + bibliography users here :) Keep in mind you may be proposing something that already exists in other projects (see below). I understand your example with microsoft onenote. A program I have used myself, and I can understand its innovation and ideas, but that software has broadened markets such as being available on different hardware, etc the iOS platform and the Internet with storage of Microsoft skydrive. My main criteria for using software is it must be free, open source. Close second is being as good or better. If you look at mobile applications for Zotero, you'll see you can also use OwnCloud to store its database of documents - hosted on your own server. I try to reproduce the same functionality, or better, with free, open source software integration. I briefly comment on such experiments either on JoinDiaspora or G+: https://joindiaspora.com/posts/1737364 https://plus.google.com/102415554453485274892/posts/PskhYYaDMaR Of course the feature set *at the moment* is not complete. But it's more often than not dictated by actual needs of its users, not mostly by Microsoft or some other corporation which motivation #1 (and obligation to shareholders) is profit. I also have greater influence and chances to get fixes in such projects. With this in mind I find it more productive to bring closer the communities of existing products like Zotero, OwnCloud and LibreOffice, and have them build on each other's work. The goal that you are seeking then looks closer to me. If I were to propose something to LibreOffice devs, it would be to *completely remove the current bibliographic support* and embrace/extend/integrate Zotero into LibO, perhaps as a default 3rd party extension (much like happened recently with some grammar/spelling dictionaries I believe). The current functionality is broken, unreliable and requires careful understanding to wrok at a basic level, nevermind at the same level as Zotero (with social sharing, remote storage, standard formats, etc.). In regards to the referencing system in LO. zotero is an extension that I have used with LO. Although it works very well with compatability with LO its referencing systems are incompatible with Microsoft office. I think that is an issue with LO, and Microsoft office referencing systems. I will confirm this from a email from zotero about this issue. In my opinion you will get limited success and progress with this approach. With the limited resources TDF has, I doubt any developer will be working to make it easier for you to stay working with MS Office. A better use of such resources would be to demonstrate and advocate the use of Zotero + LibreOffice to your peers (or in the environment where you seem to have no choice) - and fix whatever is missing to make it easier for MS Office/Notes users to leave that platform. As a result, I believe this is a main issue and concern with referencing systems in LO. compatability with properitary software referencing systems etc MO. Interoperability is important, but in this case I believe the main issue is a component that is not critical to 100% of LIbO users, and several interesting alternatives (including Zotero). So this is not going to get critical priority assignment, IMO. Referencing systems and making bibliographies I believe in LO needs
[tdf-discuss] CALC- How to protect cells and remove cell boarder outline
I have a spreadsheet that I want to protect cells from being changed. I am using cell A7 as an input cell. How can I prevent the other cells from being changed? Also, is there a way to turn off the cell outline border? Thanks ahead to hopefully a simple answer x -- View this message in context: http://nabble.documentfoundation.org/CALC-How-to-protect-cells-and-remove-cell-boarder-outline-tp3995701.html Sent from the Discuss mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted