Re: [libreoffice-users] Gray boxes on copy paste from browser

2014-02-21 Thread Brian Barker
At 10:50 20/02/2014 -0800, Shawn Yve wrote: Background info: I'm a moderator for a writers workshop forum and we turn our lessons into a PDF at the end of a workshop. When I copy/paste from chrome into writer I end up with small gray boxes (one space height/width) scattered through my

[libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

2014-02-21 Thread Dennis Regan
MY EMAIL ADDRESS IS: dennispreg...@hotmail.com DEAR SIR OR MS., MY NAME IS DENNIS REGAN AND I HAVE A QUESTION FOR YOU THAT I COULDN’T FIND THE ANSWER TO ONLINE OR IN LibreOffice Calc Help. +) HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC? THERE ARE AN AWFUL LOT OF

Re: [libreoffice-users] Re: [tdf-announce] LibreOffice 4.2.1 is already available to improve the experience of early adopters

2014-02-21 Thread MR ZenWiz
Still no download. I get a connection, but nothing seems to be available. Is the download page working? On Thu, Feb 20, 2014 at 10:34 PM, MR ZenWiz mrzen...@gmail.com wrote: The site may be overloaded at the moment - I can't get the help download. sigh On Thu, Feb 20, 2014 at 5:48 AM, Tom

Re: [libreoffice-users] Re: read-only problem

2014-02-21 Thread Stephan Bergmann
On 02/20/2014 11:03 PM, edo1 wrote: sberg wrote On 02/19/2014 06:04 PM, edo1 wrote: I saved a small (14 page) styled part of a large project as read-only What exactly do you mean with save as read-only? In windows: After the file is saved to some folder, go to that folder and right-click

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

2014-02-21 Thread Paul
I think the formula you want is TEXT. I'm not too sure on the format parameter to this function, haven't checked that, but for me a format string of #.## worked fine for a number with a decimal place. You should be able to find further details of the format string in the help or online. So, for

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

2014-02-21 Thread Paul
Hi Dennis, What format will the numbers themselves be entered in? In addition to TEXT you can also use the DOLLAR function, which will use your localization information to format the number as text string with a currency symbol, thousands separator and decimal places. To use the TEXT function,

[libreoffice-users] Random crashes Calc

2014-02-21 Thread informatichien
facturesAvecErreurs.ods http://nabble.documentfoundation.org/file/n4098348/facturesAvecErreurs.ods hello all, my app crash randomly! using the drop down list Nouvelle Facture to choose a client, then the button Iprimer Facture without changing anything else, I crash after 5-60 manipulations.

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

2014-02-21 Thread C
Hi there! You can convert a number in text if you place an apostrophe sign before your number (e.g. '123). Also, you can select desired cells and then use Format menuCellsNumbers tabCategoryText OK. Cristi On 21/02/2014 09:55, Dennis Regan wrote: MY EMAIL ADDRESS IS:

Re: [libreoffice-users] Re: [tdf-announce] LibreOffice 4.2.1 is already available to improve the experience of early adopters

2014-02-21 Thread MR ZenWiz
I'll have to get back to you on that when I get home tonight. Our company firewall is having access problems through the download links: Error: Gateway Timeout Time: Fri, 21 Feb 2014 10:16:47 PST Your Source IP: 128.222.234.115 External Host: mirrors.syringanetworks.net Appliance: 10.13.130.30

Re: [libreoffice-users] Re: [tdf-announce] LibreOffice 4.2.1 is already available to improve the experience of early adopters

2014-02-21 Thread Tom Davies
Hi :) Sorry! I missed all that. It seems to be working now. My web-browser tries to block such downloads but i just click on the Allow button in the grey 'tool'-bar that appears at such times and then the pop-up appears asking if i want to save or open it. So, it's working now afaik. I'm not

[libreoffice-users] Re: Gray boxes on copy paste from browser

2014-02-21 Thread shawnyve
Brian Barker wrote At 10:50 20/02/2014 -0800, Shawn Yve wrote: Background info: I'm a moderator for a writers workshop forum and we turn our lessons into a PDF at the end of a workshop. When I copy/paste from chrome into writer I end up with small gray boxes (one space height/width) scattered

Re: [libreoffice-users] Re: read-only problem

2014-02-21 Thread Tom Davies
Hi :) I think a few of us have found that files do become read-only without us being really clear exactly why. We just work-around it rather than hunt down specific causes and those work-arounds often result in creating a back-up of the file so it's a bonus rather than a problem. I hadn't

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

2014-02-21 Thread Tom Davies
Hi :) It's an unusual problem that looks a lot like a fairly frequently asked question. Your question has an extra twist which we didn't notice earlier. I am not sure if there is an easy way to convert numbers to words. ie 2,000 to Two thousand So far people have been talking about how to make

[libreoffice-users] Application of Speadsheet

2014-02-21 Thread Pikov Andropov
At my wife's church auction, they are going to use a spreadsheet (as long suffering readers already know :-)). Attendees' names and paddle numbers will be entered at the start of the auction. The second phase is the entry of purchased item codes, winning bid amounts and paddle numbers of

[libreoffice-users] Large fonts

2014-02-21 Thread retiredinor
Hi: I would like to print some things in font size 200. In libreoffice you can only go up to about 96. I have tried putting in a larger number but it won't work. Is there any way in libreoffice to print in larger fonts than 96? M. Whiting

[libreoffice-users] Re: Large fonts

2014-02-21 Thread mariosv
Hi M. Whiting, I think you can do it, writing the size in the box. http://nabble.documentfoundation.org/file/n4098430/Captura.png Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/Large-fonts-tp4098417p4098430.html Sent from the Users mailing list archive at

Re: [libreoffice-users] Application of Speadsheet

2014-02-21 Thread Alan B
On Fri, Feb 21, 2014 at 3:05 PM, Pikov Andropov piko...@gmail.com wrote: Third phase is checkout. I was thinking of copying the spreadsheet as it existed after phase 2 to a second laptop so that people could checkout with last-names-A-through-M going to laptop 1 and N-Z, to laptop 2. The

[libreoffice-users] Re: Calc - sort in to columns

2014-02-21 Thread IGraham
Hi Nice try Paul I've never used pivit tables so didn't know they could produce that, which as you say may be a sufficient workaround, I could use it and it gives the closest result to what I want I've tried. But really the more I think about it the more I know a simple text file will be the

Re: [libreoffice-users] Re: read-only problem

2014-02-21 Thread Stephan Bergmann
On 02/21/2014 04:43 PM, Tom Davies wrote: I hadn't realised it might be worth posting a bug-report but maybe now might encourage people to do so if they encounter the problem in the future. And feel free to put me on CC. (I'd once tinkered with the relevant code, to allow to toggle edit mode

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

2014-02-21 Thread Alex McMurchy
Try this link. Specifically the function getAmountInWord in the described macro. Don't try the extension. Alex On Friday 21 Feb 2014 15:29:18 Tom Davies wrote: Hi :) It's an unusual problem that looks a lot like a fairly frequently asked question. Your question has an extra twist which

Re: [libreoffice-users] Application of Speadsheet

2014-02-21 Thread Pikov Andropov
That would require Internet access, something the church doesn't have. On February 21, 2014 5:07:15 PM EST, Spencer Graves spencer.gra...@prodsyse.com wrote: Have you considered something like a Google Spreadsheet? This could be ideal, as it could allow multiple people to edit at

Re: [libreoffice-users] Application of Speadsheet

2014-02-21 Thread Pikov Andropov
I thought I said that after phase 2, the spreadsheet would be copied to a second computer. I thought that dividing the way I mentioned would make merging easier. On February 21, 2014 4:21:54 PM EST, Alan B abo...@gmail.com wrote: On Fri, Feb 21, 2014 at 3:05 PM, Pikov Andropov

Re: [libreoffice-users] Large fonts

2014-02-21 Thread Don C. Myers
Hi, In all versions of LO I've used, including 4.2.1.1 now, if you highlight the number in the box showing the font size, say for example 12, then type in the size, say 400, you want and press enter, it will change to that size. I use it where I want numbers or letters to be about 4 inches

Re: [libreoffice-users] Re: [tdf-announce] LibreOffice 4.2.1 is already available to improve the experience of early adopters

2014-02-21 Thread MR ZenWiz
I should clarify - this is the Deb x86_64 download that is not working. On Fri, Feb 21, 2014 at 11:46 PM, MR ZenWiz mrzen...@gmail.com wrote: Still inaccessible. On Fri, Feb 21, 2014 at 10:20 AM, MR ZenWiz mrzen...@gmail.com wrote: I'll have to get back to you on that when I get home