[libreoffice-users] How to select a rectangle area and export only content (and not whole page) as *.png in Draw?

2011-03-21 Thread benxs
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

[libreoffice-users] File saving integrity

2011-03-21 Thread Steve Edmonds
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

[libreoffice-users] Zeros when linking cells between sheets

2011-03-21 Thread John Kennedy
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

Re: [libreoffice-users] How to select a rectangle area and export only content (and not whole page) as *.png in Draw?

2011-03-21 Thread Helmar
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

Re: [libreoffice-users] No mail.

2011-03-21 Thread Helmar
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

Re: [libreoffice-users] Zeros when linking cells between sheets

2011-03-21 Thread Stefan Weigel
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 --

Re: [libreoffice-users] Zeros when linking cells between sheets

2011-03-21 Thread John Kennedy
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

[libreoffice-users] What happened to the delete row/column icons?

2011-03-21 Thread bill purvis
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

Re: [libreoffice-users] What happened to the delete row/column icons?

2011-03-21 Thread Andy Brown
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

Re: [libreoffice-users] What happened to the delete row/column icons?

2011-03-21 Thread Stefan Weigel
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... |

[libreoffice-users] Word Count Progress Bar

2011-03-21 Thread Michael Redman
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

Re: [libreoffice-users] Word Count Progress Bar

2011-03-21 Thread Steven Shelton
-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.

Re: [libreoffice-users] What happened to the delete row/column icons?

2011-03-21 Thread bill purvis
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

Re: [libreoffice-users] Word Count Progress Bar

2011-03-21 Thread Michael Redman
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

Re: [libreoffice-users] Word Count Progress Bar

2011-03-21 Thread Michael Redman
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

Re: [libreoffice-users] Word Count Progress Bar

2011-03-21 Thread Leif Lodahl
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

[libreoffice-users] Convert formulae to actual

2011-03-21 Thread James Wilde
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

Re: [libreoffice-users] Convert formulae to actual

2011-03-21 Thread Jean-Francois Nifenecker
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

[libreoffice-users] LO Calc very slow and freezes

2011-03-21 Thread Thomas Bouchard
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

Re: [libreoffice-users] Re: LO Calc very slow and freezes

2011-03-21 Thread Thomas Bouchard
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

Re: [libreoffice-users] Convert formulae to actual

2011-03-21 Thread James Wilde
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

Re: [libreoffice-users] Convert formulae to actual

2011-03-21 Thread Charles Marcus
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

Re: [libreoffice-users] Convert formulae to actual

2011-03-21 Thread Jean-Francois Nifenecker
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

Re: [libreoffice-users] Convert formulae to actual

2011-03-21 Thread James Wilde
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.

[libreoffice-users] Re: Word Count Progress Bar

2011-03-21 Thread aqualung
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

[libreoffice-users] Re: LO Calc very slow and freezes

2011-03-21 Thread plino
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