[libreoffice-users] How to select a rectangle area and export only content (and not whole page) as *.png in Draw?
Assume I draw some objects with Draw. Now I want to export them as a *.png picture file into a local directory. When I do this then currently the WHole page is always exported (with a lot of white uninteresting space around it). So I need somehow to selected only a part of the page. How can I do this in detail? How can I select e.g. a rectangel area with the objects 1,2, 5 and 11 and an additional white space of 10 pixel around them and export only this rectangle area? Ben -- View this message in context: http://nabble.documentfoundation.org/How-to-select-a-rectangle-area-and-export-only-content-and-not-whole-page-as-png-in-Draw-tp2709003p2709003.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] File saving integrity
Hi. I was following the discussion on sharepoint. I am developing some guidelines for our users for use of LO to minimise loss of data. How does LO handle and store files across networks, what happens if the network goes out partway during a save. When the file is opened is the whole file cached locally for editing Is the file saved as file.odt.part and mv file.odt at the end or is the file held open and written by block. What happens with a time save backup, is that local or remote (although no good for .docs as it doesn't work) I am presently apprehensive about editing a file across the internet that may sit open, especially a largish file and tend to recommend. Opening files on the local server for editing and saving is ok. Files to be edited from a server remote across the internet should be copied to your local HD, edited and copied back across the internet. Does the sharepoint extension being discussed address these issues and would it be applicable to any Webdav server. (I have no intention to connect to a sharepoint server but could be interested in a webdav situation Cheers, steve -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Zeros when linking cells between sheets
I have a spreadsheet with 3 sheets. I want sheets 1 (Phone) and 2 (Network), when edited, to update sheet 3 (All) which is the master view. I have linked each of the needed cells (e.g. cell a3 on the All reads =Phone.a3). If Phone.a3 is empty then All.a3 has a 0 (zero). I would prefer, for readability, for the cell to be blank like the referenced cell. Is there a way to do this? Thanks, John -- John Kennedy -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] How to select a rectangle area and export only content (and not whole page) as *.png in Draw?
If the objects you want to export can be selected with the selection tool (entirely) so it´s easy. Select the objetcs and go to Export... then mark the box Selection just below the automatic extension box But if the area you want to export it comprehends part of one or more object and you can´t simply select the entire objects I think that may be an option creating a rectangle over that area and use the intersection to create a selection from it so you can select it the usual way as a single object. Helmar Fernandes === Ubuntu Maverick Meerkat user www.aquahobby.com www.penguim.net/pocosdecaldas On 21 March 2011 03:42, benxs bxsto...@yahoo.co.uk wrote: Assume I draw some objects with Draw. Now I want to export them as a *.png picture file into a local directory. When I do this then currently the WHole page is always exported (with a lot of white uninteresting space around it). So I need somehow to selected only a part of the page. How can I do this in detail? How can I select e.g. a rectangel area with the objects 1,2, 5 and 11 and an additional white space of 10 pixel around them and export only this rectangle area? Ben -- View this message in context: http://nabble.documentfoundation.org/How-to-select-a-rectangle-area-and-export-only-content-and-not-whole-page-as-png-in-Draw-tp2709003p2709003.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity *** -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] No mail.
I can copy you here from Brazil Howard. Replying to you and to the list. Can you copy both replies? Helmar Fernandes === Ubuntu Maverick Meerkat user www.aquahobby.com www.penguim.net/pocosdecaldas On 20 March 2011 01:18, Howard Barr how...@gol.com wrote: Hi, I am subscribed to this list but since the 11 of March I have not received any emails. I'm based in Chiba, Japan (south-east of Tokyo) but I doubt if that has anything to do with not receiving email. Regards, Howard. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity *** -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Zeros when linking cells between sheets
Hi John, Am 21.03.2011 12:07, schrieb John Kennedy: If Phone.a3 is empty then All.a3 has a 0 (zero). I would prefer, for readability, for the cell to be blank like the referenced cell. Is there a way to do this? Tools | Options... | LibreOffice Calc | View | Zero values Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Zeros when linking cells between sheets
On Mon, Mar 21, 2011 at 13:32, Stefan Weigel stefan.wei...@bildungskreis.org wrote: Hi John, Am 21.03.2011 12:07, schrieb John Kennedy: If Phone.a3 is empty then All.a3 has a 0 (zero). I would prefer, for readability, for the cell to be blank like the referenced cell. Is there a way to do this? Tools | Options... | LibreOffice Calc | View | Zero values Stefan Stefan, Just what I needed. Thanks, John -- John Kennedy -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] What happened to the delete row/column icons?
I have recently converted to LibreOffice from OpenOffice. I have a minor quibble - OpenOffice Calc had toolbar items to delete rows and columns but I can't find these in LibreOffice. I found the insert rows and columns Ok and have added them to the toolbar, but miss those for deleting. I could do without the insert cells icons. Bill -- +---+ | Bill Purvis, Model Engineer | | email: b...@billp.org| +---+ -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] What happened to the delete row/column icons?
bill purvis wrote: I have recently converted to LibreOffice from OpenOffice. I have a minor quibble - OpenOffice Calc had toolbar items to delete rows and columns but I can't find these in LibreOffice. I found the insert rows and columns Ok and have added them to the toolbar, but miss those for deleting. I could do without the insert cells icons. Bill I was not aware of either icon. I have always inserted/deleted by right clicking on the headers, row or column, and select delete/insert row/column. Seems faster to me. Andy -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] What happened to the delete row/column icons?
Hi Bill, Am 21.03.2011 15:13, schrieb bill purvis: OpenOffice Calc had toolbar items to delete rows and columns but I can't find these in LibreOffice. I found the insert rows and columns Ok and have added them to the toolbar, but miss those for deleting. When look at Tools | Customize... | Toolbars | Add... | Edit I can see an icon for Delete Columns as well as an icon for Delete Rows. I am using LibreOffice 3.3.1 on Ubuntu Linux 10.10. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Word Count Progress Bar
I'm looking for a functionality in Writer: a word count progress bar. Set the number of words that is your target, and somewhere in the writer window the program displays the progress real-time. Any ideas? Regards, Mike Redman -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Word Count Progress Bar
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 3/21/2011 11:31 AM, Michael Redman wrote: I'm looking for a functionality in Writer: a word count progress bar. Set the number of words that is your target, and somewhere in the writer window the program displays the progress real-time. Any ideas? I think there's an OOo plug-in for this that should work with LibO. Look at the OOo extensions site. - -- Steven Shelton -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.12 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk2HdwgACgkQXUonIzCvpdNKTgCaAvr9ECby1r5GVp3LigQ7Q4Q5 Wd4An1c2HkRQ/ErXRnL6prsAU+JSKa4z =Ucql -END PGP SIGNATURE- -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] What happened to the delete row/column icons?
On Monday 21 March 2011, Stefan Weigel wrote: Hi Bill, Am 21.03.2011 15:13, schrieb bill purvis: OpenOffice Calc had toolbar items to delete rows and columns but I can't find these in LibreOffice. I found the insert rows and columns Ok and have added them to the toolbar, but miss those for deleting. When look at Tools | Customize... | Toolbars | Add... | Edit I can see an icon for Delete Columns as well as an icon for Delete Rows. I am using LibreOffice 3.3.1 on Ubuntu Linux 10.10. Stefan Great! Thanks a lot. I was sure that it must be somewhere but I've obviously not learned how to find my way round it. Bill -- +---+ | Bill Purvis, Model Engineer | | email: b...@billp.org| +---+ -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Word Count Progress Bar
Yep - it works...thanks! Now I just have to make it more user-friendly to start/autostart for my wifeperhaps a button. On Mon, Mar 21, 2011 at 12:07 PM, Manfred J. Krause courrier.oou.fr@googlemail.com wrote: Hi, On Mon, Mar 21, 2011 at 16:31, Michael Redman wrote: I'm looking for a functionality in Writer: a word count progress bar. Set the number of words that is your target, and somewhere in the writer window the program displays the progress real-time. Any ideas? Maybe wc.py: [Solved+Issue] No visible word count in OpenOffice Writer http://user.services.openoffice.org/en/forum/viewtopic.php?f=7t=22555start=0 That works fine for me with LibO 3.3.1 / 3.3.2 RC. mjk -- Macroprogramming with Python http://lodahl.blogspot.com/2011/03/macroprogramming-with-python.html -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity *** -- Take care, Mike Redman Visionmanager, Creatrix Transformational Solutions Inc www.kimredmannlp.com c.905-716-4854 -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Word Count Progress Bar
Yep, a buttoncreated a custom toolbar and then added a button that pointed to the script. My wife will think I'm a god! Thanks! On Mon, Mar 21, 2011 at 12:26 PM, Michael Redman m...@kimredmannlp.comwrote: Yep - it works...thanks! Now I just have to make it more user-friendly to start/autostart for my wifeperhaps a button. On Mon, Mar 21, 2011 at 12:07 PM, Manfred J. Krause courrier.oou.fr@googlemail.com wrote: Hi, On Mon, Mar 21, 2011 at 16:31, Michael Redman wrote: I'm looking for a functionality in Writer: a word count progress bar. Set the number of words that is your target, and somewhere in the writer window the program displays the progress real-time. Any ideas? Maybe wc.py: [Solved+Issue] No visible word count in OpenOffice Writer http://user.services.openoffice.org/en/forum/viewtopic.php?f=7t=22555start=0 That works fine for me with LibO 3.3.1 / 3.3.2 RC. mjk -- Macroprogramming with Python http://lodahl.blogspot.com/2011/03/macroprogramming-with-python.html -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity *** -- Take care, Mike Redman Visionmanager, Creatrix Transformational Solutions Inc www.kimredmannlp.com c.905-716-4854 -- Take care, Mike Redman Visionmanager, Creatrix Transformational Solutions Inc www.kimredmannlp.com c.905-716-4854 -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Word Count Progress Bar
Hi Michael, Funny but I implemented just these two features this weekend ;-) Take a look at this https://bitbucket.org/yawaramin/oo.o-live-word-count/overview/ and this http://lodahl.blogspot.com/2011/03/macroprogramming-with-python.html Cheers, Leif Lodahl 2011/3/21 Michael Redman light...@gmail.com I'm looking for a functionality in Writer: a word count progress bar. Set the number of words that is your target, and somewhere in the writer window the program displays the progress real-time. Any ideas? Regards, Mike Redman -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity *** -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Convert formulae to actual
I have a calc sheet with full names in one column, thus: John Smith Jane Smollett I want to create a column with forenames and one with surnames. I've created an extra column with the position of the space between first name and last name (in the cases above, it's five in each case), and two other columns in one of which I place the first x-1 characters where x is the position of the space) and in the other I place the right end of the name field from the x+1 character to the end. What I'd now like todo is to change the contents of the first name column from left(1;x-1) to John or Jane, and the last name column likewise, from being a formula which displays as a name to being a name. Can't find it anywhere. TIA //James -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Convert formulae to actual
Le 21/03/2011 17:59, James Wilde a écrit : What I'd now like todo is to change the contents of the first name column from left(1;x-1) to John or Jane, and the last name column likewise, from being a formula which displays as a name to being a name. Select, then Copy Special at the same place with Formula option unchecked. -- Jean-Francois Nifenecker, Bordeaux -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] LO Calc very slow and freezes
Hi I have a simple sheet with lots of lines (30), a graph on 2 columns only but no formulas. LO struggles to open it, freezes all the time, so it's impossible to work with it. My laptop runs correctly (Intel centrino duo with Xubuntu 10.04), memory and cpu are under 50% of use. Is there some special memory settings to make *calc* work flawlessly, or is it a performance problem? Regards /Thomas -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: LO Calc very slow and freezes
Thanks for the quick answer. My file is ODS, but gnumeric can't open it, maybe because of the line number. Le 21/03/2011 18:51, plino a écrit : It is a performance problem. If you are using an xlsx file you can decrease loading time by 2/3 if you save it to ODS. See this topic http://nabble.documentfoundation.org/Why-is-LO-OOo-so-slow-loading-a-spreadsheet-td2006665.html HTH -- View this message in context: http://nabble.documentfoundation.org/LO-Calc-very-slow-and-freezes-tp2710811p2710975.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Convert formulae to actual
On Mar 21, 2011, at 18:10 , Jean-Francois Nifenecker wrote: Le 21/03/2011 17:59, James Wilde a écrit : What I'd now like todo is to change the contents of the first name column from left(1;x-1) to John or Jane, and the last name column likewise, from being a formula which displays as a name to being a name. Select, then Copy Special at the same place with Formula option unchecked. Sorry, Jean-Francois. There is no Copy Special. Only Paste Special. And Paste Special does not have a Formula option. //J -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Convert formulae to actual
On 2011-03-21 4:14 PM, James Wilde wrote: Sorry, Jean-Francois. There is no Copy Special. Only Paste Special. And Paste Special does not have a Formula option. sure it does, I use it all the time... -- Best regards, Charles -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Convert formulae to actual
Le 21/03/2011 21:14, James Wilde a écrit : Sorry, Jean-Francois. There is no Copy Special. Only Paste Special. And Paste Special does not have a Formula option. Ooops! Yes, it should read Paste special, sorry for the typo. And I confirm there *is* a Formula option :) -- Jean-Francois Nifenecker, Bordeaux -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Convert formulae to actual
On Mar 21, 2011, at 21:46 , Jean-Francois Nifenecker wrote: Le 21/03/2011 21:14, James Wilde a écrit : Sorry, Jean-Francois. There is no Copy Special. Only Paste Special. And Paste Special does not have a Formula option. Ooops! Yes, it should read Paste special, sorry for the typo. And I confirm there *is* a Formula option :) Ah, thanks. I didn't realise that, by select, you meant I had to copy the cells in question. When I copied them first, it worked exactly as you said. Thanks for the help. //James -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Word Count Progress Bar
Great, I hope you make this into a .oxt extension and upload it to the extensions repository! -- View this message in context: http://nabble.documentfoundation.org/Word-Count-Progress-Bar-tp2710396p2711100.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: LO Calc very slow and freezes
Gnumeric supports up to 16777216 lines (yes, 16 million...) Maybe you are using an older version. The current build is 1.10.13 -- View this message in context: http://nabble.documentfoundation.org/LO-Calc-very-slow-and-freezes-tp2710811p2712956.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
