[users] Calc - how to count cells by background color
I found a way to do this using MS Excel 2007 and was looking for a way to do the same in OpenOffice Calc. Anyone had success with counting of cells of a particular color ? Phil - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Change path for .~lock.xyz files
Exactly - as this is the only place where it makes sense. Not really - it causes problems when you try to edit a document that you have read/write privs for, but the doc is located in a folder where you do NOT have privs to create NEW files. I know, because this bug has created big problems for me - but when I reported it, of course I was told it isn't a bug, it is an 'improvement'... right, it is an improvement that changes the way it worked for YEARS, and caused (and still causes) me no end of grief. I would *love* the ability to change the path for the lock files... or better yet, I'd prefer for OOo to go back to the way it determined if a file was being edited or not prior to the change (don't remember which version this changed in, but it was some time ago)... Thanks (again) devs.. Did you open a bug report with an appropriate description (ie, unable to open a document read-only in a directory to which you cannot write... Hard to argue with "not able to open a document for edit in a directory you cannot write"). If they shoot you down, then change it to enhancement and convince others to vote on it. Not reasonable to expect an enhancement to be created just because it is something that you want. On the other hand, if you want it as well as a 200 of your closest friends and relatives it is more likely to receive attention. Finally, perhaps you can implement this yourself, but, there are very specific reasons that it is now done this way. For years, there were complaints of how it used to be handled because of specific networking shares (or something like that). Because of this, I doubt that they will revert to the old method without making it a configuration specific thing (or perhaps setting something in the environment). -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Change path for .~lock.xyz files
On 10/29/2010 2:03 PM, Tanstaafl wrote: On 2010-10-29 10:40 AM, Malte Timmermann wrote: Marcello Romani wrote, On 10/29/10 16:10: Il 29/10/2010 16:03, Sébastien Moretti ha scritto: > Exactly - as this is the only place where it makes sense. Not really - it causes problems when you try to edit a document that you have read/write privs for, but the doc is located in a folder where you do NOT have privs to create NEW files. I know, because this bug has created big problems for me - but when I reported it, of course I was told it isn't a bug, it is an 'improvement'... right, it is an improvement that changes the way it worked for YEARS, and caused (and still causes) me no end of grief. I would *love* the ability to change the path for the lock files... or better yet, I'd prefer for OOo to go back to the way it determined if a file was being edited or not prior to the change (don't remember which version this changed in, but it was some time ago)... Thanks (again) devs... Lock files are created to prevent two or more different users from editing the same file at the same time, and interfering with each other's edits. It makes no sense to have the lock file saved differently on your machine, as this would permit the simultaneous edits that are trying to be prevented in the first place. To solve your problem, get your IT department to set your write permissions properly. It sounds as if you have EDIT but not CREATE flags set. Joe Conner, Poulsbo, WA USA - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Change path for .~lock.xyz files
On 2010-10-29 10:40 AM, Malte Timmermann wrote: > Marcello Romani wrote, On 10/29/10 16:10: >> Il 29/10/2010 16:03, Sébastien Moretti ha scritto: >>> I would like to change path for .~lock.xyz files. >>> They are currently in $HOME. >>> >>> How to put them in /tmp by example ? >> I think they're created in the same folder where the document file is. > Exactly - as this is the only place where it makes sense. Not really - it causes problems when you try to edit a document that you have read/write privs for, but the doc is located in a folder where you do NOT have privs to create NEW files. I know, because this bug has created big problems for me - but when I reported it, of course I was told it isn't a bug, it is an 'improvement'... right, it is an improvement that changes the way it worked for YEARS, and caused (and still causes) me no end of grief. I would *love* the ability to change the path for the lock files... or better yet, I'd prefer for OOo to go back to the way it determined if a file was being edited or not prior to the change (don't remember which version this changed in, but it was some time ago)... Thanks (again) devs... - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] columns and footnotes
2010/10/29 Daniel Lewis : > Guy Voets wrote: >> >> Hello, >> >> I have a section with 2 equal-length columns. I type text in the >> columns, and this text is equally spread over both columns. So far so >> good. Then I make a footnote. Now, the word with the (1) passes to the >> next page, leaving the second column empty. The text of the note is >> too long to fit at the bottom of the first column, but I would expect >> that the note text would be split over both columns (continue from the >> first into the second, as happens with the text in the columns - or >> with a footnote in a text without columns). >> Is this a bug, or is there a solution? >> -- >> Guy >> > > Perhaps it is a bug, perhaps not. > I do have a suggestion. It appears you have formatted the section so > that the text is equally spread over both columns. Then you added a > footnote. Perhaps you have the wrong order for these operations. From my > testing of this, it appears that the footnote is a part of the section. > This is what I tried. I created a section and formatted it. (Format > > Sections > Options) "Evenly distribute content to all columns" was not > checked (not ticked). I copied a little less than 2 pages of text into the > section. Then I added a footnote in the first column of the first page. > Finally, I formatted the section by checking (ticking) "Evenly distribute > content to all columns". The footnote was still at the bottom of column 1 of > page 1. Even though I then added 8 more lines to the footnote, the footnote > remained where it was. At this point, the footnote was 20 lines long! > Again, it may be a bug, but the solution may be to leave "Evenly > distribute content to all columns" unchecked (not ticked) until after you > have all of the text AND footnote in the section. Then check (tick) this > selection. > > Dan Thanks Dan, I'll try it out tomorrow. As an alternative I changed them into endnotes, but footnotes would be better. -- Guy using LibO 3.3.0 and OOo 3.2.1 on a iMac Intel DualCore Snow Leopard -- please reply only to users@openoffice.org -- Dodoes can't afford to have headaches - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Change path for .~lock.xyz files
On Saturday 30 October 2010 03:40, Malte Timmermann wrote: > Marcello Romani wrote, On 10/29/10 16:10: > > Il 29/10/2010 16:03, Sébastien Moretti ha scritto: > >> Hi > >> > >> I would like to change path for .~lock.xyz files. > >> They are currently in $HOME. > >> > >> How to put them in /tmp by example ? > >> > >> Thanks > > > > I think they're created in the same folder where the document file is. > > Exactly - as this is the only place where it makes sense. And AFAIK the lock file should only exist while the document is being edited. Exceptions being unusual program exits. -- Michael - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] OpenOffice.org community council - only Oracle employees now??
On Thursday 28 October 2010 13:05, webmas...@krackedpress.com wrote: All sorts of things. FUD mainly. My reply on the discuss mailing list. -- Cheers - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Change path for .~lock.xyz files
Marcello Romani wrote, On 10/29/10 16:10: > Il 29/10/2010 16:03, Sébastien Moretti ha scritto: >> Hi >> >> I would like to change path for .~lock.xyz files. >> They are currently in $HOME. >> >> How to put them in /tmp by example ? >> >> Thanks >> > > I think they're created in the same folder where the document file is. > Exactly - as this is the only place where it makes sense. Malte. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] columns and footnotes
Guy Voets wrote: Hello, I have a section with 2 equal-length columns. I type text in the columns, and this text is equally spread over both columns. So far so good. Then I make a footnote. Now, the word with the (1) passes to the next page, leaving the second column empty. The text of the note is too long to fit at the bottom of the first column, but I would expect that the note text would be split over both columns (continue from the first into the second, as happens with the text in the columns - or with a footnote in a text without columns). Is this a bug, or is there a solution? -- Guy using LibO 3.3.0 and OOo 3.2.1 on a iMac Intel DualCore Snow Leopard -- please reply only to us...@libreoffice.org -- Dodoes can't afford to have headaches Perhaps it is a bug, perhaps not. I do have a suggestion. It appears you have formatted the section so that the text is equally spread over both columns. Then you added a footnote. Perhaps you have the wrong order for these operations. From my testing of this, it appears that the footnote is a part of the section. This is what I tried. I created a section and formatted it. (Format > Sections > Options) "Evenly distribute content to all columns" was not checked (not ticked). I copied a little less than 2 pages of text into the section. Then I added a footnote in the first column of the first page. Finally, I formatted the section by checking (ticking) "Evenly distribute content to all columns". The footnote was still at the bottom of column 1 of page 1. Even though I then added 8 more lines to the footnote, the footnote remained where it was. At this point, the footnote was 20 lines long! Again, it may be a bug, but the solution may be to leave "Evenly distribute content to all columns" unchecked (not ticked) until after you have all of the text AND footnote in the section. Then check (tick) this selection. Dan - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Change path for .~lock.xyz files
Il 29/10/2010 16:03, Sébastien Moretti ha scritto: Hi I would like to change path for .~lock.xyz files. They are currently in $HOME. How to put them in /tmp by example ? Thanks I think they're created in the same folder where the document file is. -- Marcello Romani - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Change path for .~lock.xyz files
Hi I would like to change path for .~lock.xyz files. They are currently in $HOME. How to put them in /tmp by example ? Thanks -- Sébastien Moretti - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] columns and footnotes
Hello, I have a section with 2 equal-length columns. I type text in the columns, and this text is equally spread over both columns. So far so good. Then I make a footnote. Now, the word with the (1) passes to the next page, leaving the second column empty. The text of the note is too long to fit at the bottom of the first column, but I would expect that the note text would be split over both columns (continue from the first into the second, as happens with the text in the columns - or with a footnote in a text without columns). Is this a bug, or is there a solution? -- Guy using LibO 3.3.0 and OOo 3.2.1 on a iMac Intel DualCore Snow Leopard -- please reply only to us...@libreoffice.org -- Dodoes can't afford to have headaches - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] OpenOffice.org community council - only Oracle employees now??
On 10/28/2010 9:53 AM, jonathon wrote: Technically, the code in OOo is open source, but with Oracle as the sole copyright owner. As such, there is nothing that the contributors can legally do, to prevent Oracle from declaring OOo 4.0 to be closed source, proprietary, and by the way you have to pay US$90 per license, with a 100 license minimum. It seems to me that would result in massive defection to TDF and LO by all users and most of the non-Oracle developers. Would Oracle do that? They certainly can legally do that, but more likely is a model that Sun supported as StarOffice. Such a move might done using the model that Cygnus Software used for its clients before their acquisition by Red Hat. The most recent updates (GPL) went to paid clients for whom I assume requested and paid for the updates, and these were released, still GPL, to the public at a significantly later date. --David
Re: [users] OpenOffice.org community council - only Oracle employees now??
Who is now in charge of the code our volunteers contribute? If it goes into the OOo cvs system, Oracle. If it goes into the LibreOffice, Go-OO, OxygenOffice, etc cvs system, the community. Again I need to correct jonathon. Code committed to OpenOffice.org is open to be taken and used from all others. go-oo did that in the past and LibreOffice is doing that again. They take code from OpenOffice.org. In contrary go-oo and LibreOffice have choosen a license politics that make it impossible to take their code and integrate it into OpenOffice.org. So if you contribute code to OpenOffice.org it will went into most flavors or forks. If you choose to contribute to LibreOffice in contrary the code will only be there. Kind regards, Ingrid dear Ingrid, wich kinds of license politics libo and go-oo chosen to make impossible integrate and take their code? Thanks Pier - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Endnote 9 and writer
On Fri, 29 Oct 2010 20:45:42 +1300 Michael Adams dijo: >On Thursday 14 October 2010 01:06, Ekain Rojo Labaien wrote: >> I just want to know if endnote 9 is available in open office writer >> like in Microsoft word 2003, if I can cite in my text and as always >> endnote create the bibliography. And is it possible to carry all the >> references that I have create in word? Writer will recognize them? >> Thank you very much >Zotero is very popular as a FOSS (GPL) alternative. >http://en.wikipedia.org/wiki/Zotero >http://www.zotero.org/ > >Surprised it hasn't been mentioned before. It was recommended to me by >a computer tutor at my University. Zotero is wonderful! Too bad so many are still struggling with that pathetic Endnote. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Endnote 9 and writer
On Thursday 14 October 2010 01:06, Ekain Rojo Labaien wrote: > I just want to know if endnote 9 is available in open office writer like in > Microsoft word 2003, if I can cite in my text and as always endnote create > the bibliography. And is it possible to carry all the references that I > have create in word? Writer will recognize them? Thank you very much Zotero is very popular as a FOSS (GPL) alternative. http://en.wikipedia.org/wiki/Zotero http://www.zotero.org/ Surprised it hasn't been mentioned before. It was recommended to me by a computer tutor at my University. HTH -- Michael - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org